99% of the traders wouldn't know this simple hack...🧐
Here is how you can...
Export 100+ stocks from @ChartinkConnect scanner to @tradingview in just under 3⃣0⃣secs! ⏲️
Let’s go 🧵...
1⃣ Find your chartink scanner!
Open your chartink scanner/dashboard
Let’s take mine for this example 👇
chartink.com/dashboard/34179
If you want to understand CCI, refer to this video
2⃣ Let's download the results!
Click on download from #Chartink dashboard and you will have the scanner results downloaded in an excel sheet
3⃣ Time to do the hack!
Open the excel sheet, right click & click on ‘Add column before’ two times.
It should look like this where column C and D is empty
4⃣ Let's learn some excel!
- Add comma(,) to column C
- Add ‘=CONCATENATE(B2,C2)’ to column D
It should look like this
5⃣ More excel!
- Select cell C2 & D2,
- Copy(Ctrl + C) the content
- Paste(Ctrl + V) it in the below rows
Now, you've populated the hack to all rows!
You should see the content like below
6⃣ More copy paste!
- Select Column D
- Copy (Ctrl+C) the entire column content
Keep this step in mind
7⃣ Time for Tradingview!
- Open Trading view
- Click on ‘watchlist’
You should see the window to the left open up
8⃣ Time to clean up or create a new watchlist!
- Clear list if there are any stocks already in your watchlist
9⃣ last but one step!
- Click + to see the ‘Add symbol’ popup
🔟 Time for the magic!
Remember the content you copied in Step 6?
- Paste(Ctrl+V) this content in the popup & press enter
You will see the watchlist updated with all the 100+ stocks you created or had
You just saved some precious time of yours!
If you loved this hack, please👇
1. Retweet the first tweet
2. Follow
@dmdsplyinvestor
3. Subscribe to my YouTube channel for more content! youtube.com/c/TrendlineInv…
Share this Scrolly Tale with your friends.
A Scrolly Tale is a new way to read Twitter threads with a more visually immersive experience.
Discover more beautiful Scrolly Tales like this.