Hello,
I'm a day trader and want to create chart database of most gainers on each day automatically.
I have an excel list of gainers which is updated on a daily basis as below
the goal is to get the highlighted ticker name from this excel spread sheet, go to tradingview web site, get the relevant ticker's intraday chart and paste it to OneNote (or any other windows or ms office program you might suggest) next to each other without overlapping automatically for every workday by power automate.
Is this really doable?
Thanks is advance for any help!!!
Hi @khanince ,
Very possible and doable. The automation may look like this using Power Automate Desktop:
1) connect to your excel sheet
2) read column A and store in a variable
3) for each (stock)...
3a) open website by going to this dynamic URL (shown below)
3b) click on 1D to get intraday chart
3c) take a screenshot of the desktop
3d) save screenshot to a folder, OneNote, Word, etc.
4) Open next chart, repeat...