Thread by @dmdsplyinvestor

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…

https://twitter.com/dmdsplyinvestor/status/1563079481740660737?s=20&t=e-1objvmU35E0d9UoyUFcg