How to track influencer wallet addresses - NO python, NO API calls, NO coding needed. Only prerequisite is excel
🧵👇
🧵👇
0/n
Target influencer for this tutorial -
Let's call them Influencooor
(Actually used a popular influencer for this example but don't wanna doxx them)
Target influencer for this tutorial -
Let's call them Influencooor
(Actually used a popular influencer for this example but don't wanna doxx them)
1/n
STEP 0
Scroll their twitter and find some tweets on token/coins they are shilling.
Found three tokens in this case.
STEP 0
Scroll their twitter and find some tweets on token/coins they are shilling.
Found three tokens in this case.
2/n
STEP 1
Download $MRI, $MNT and $KIBA CSV files (from holders section) from respective ether scan pages
STEP 1
Download $MRI, $MNT and $KIBA CSV files (from holders section) from respective ether scan pages
3/n
STEP 2
Do a Vlookup between any two. I pick $MRI and $MNT
STEP 2
Do a Vlookup between any two. I pick $MRI and $MNT
4/n
STEP 3
Filter out the NAs
STEP 3
Filter out the NAs
5/n
Now I have a pure list of all wallets that hold $MRI and $MNT
Now I have a pure list of all wallets that hold $MRI and $MNT
6/n
STEP 4
Copy this list and paste into a fresh sheet that has $KIBA wallet addys
*Correction in this picture
The right most text box should say -
"Wallets that hold all three $MRI, $MNT and $KIBA"
STEP 4
Copy this list and paste into a fresh sheet that has $KIBA wallet addys
*Correction in this picture
The right most text box should say -
"Wallets that hold all three $MRI, $MNT and $KIBA"
7/n
STEP 5
Filter out NAs
Note - We're still left with 22 addys 😯
STEP 5
Filter out NAs
Note - We're still left with 22 addys 😯
8/n
STEP 6
Find another coin Influencooor is shilling -
Influencooor retweeted expo so they probably hold some
STEP 6
Find another coin Influencooor is shilling -
Influencooor retweeted expo so they probably hold some
9/n
STEP 7
Download $EXPO excel/CSV and copy paste the 22 wallet addresses next to the $EXPO wallet addresses. Do another vlookup
Have a glass of water because we're down to just three addys
STEP 7
Download $EXPO excel/CSV and copy paste the 22 wallet addresses next to the $EXPO wallet addresses. Do another vlookup
Have a glass of water because we're down to just three addys
10/n
STEP 8
Copy and paste these addys in ether scan one by one
Specimen number 1
Holds $MUTE and $KUBA
Influencooor has never spoken about these two. Rule out.
STEP 8
Copy and paste these addys in ether scan one by one
Specimen number 1
Holds $MUTE and $KUBA
Influencooor has never spoken about these two. Rule out.
11/n
Specimen number 2 -
Holds dream, Influencooor does speak about dream -Looks promising
Specimen number 2 -
Holds dream, Influencooor does speak about dream -Looks promising
12/n
Specimen number 3 -
Holds some random tokens that Influencooor has never spoken about . Rule out
Specimen number 3 -
Holds some random tokens that Influencooor has never spoken about . Rule out
13/n
STEP 9
Verify.
Copy paste specimen two address in Debank and compare twitter posts with tokens across chains (Debank is good here because it give a good overview across chains)
Verified and confirmed. We got them!
STEP 9
Verify.
Copy paste specimen two address in Debank and compare twitter posts with tokens across chains (Debank is good here because it give a good overview across chains)
Verified and confirmed. We got them!
14/n
STEP 10
Now that you have one wallet addy, you can find their other addresses using an app like @AppBreadcrumbs
STEP 10
Now that you have one wallet addy, you can find their other addresses using an app like @AppBreadcrumbs
15/n
Note-
1. Literally used a random influencer. I have nothing against them in particular
2. I have redacted as much as possible
3. We're using these open financial systems, so wallet tracking is inevitable
What are you waiting for? Go become an on-chain detective🔍
Note-
1. Literally used a random influencer. I have nothing against them in particular
2. I have redacted as much as possible
3. We're using these open financial systems, so wallet tracking is inevitable
What are you waiting for? Go become an on-chain detective🔍
Loading suggestions...