I have linked RT data from Nest to Excel. Is there any way to save/backup RT data to other excel?
I’m not sure RT Data saving automatically to excel. But you can copy paste the data of the intraday to an excel. Right click on the chart and select Data Table. Select all(Ctrl+A) and copy(Ctrl+C) paste(Ctrl+V) to excel.
This needs a hell lot of manual work. It’s better you can try any charting tool like Amibroker. You don’t have to specifically backup, unless you missed realtime data.
yeah it’s lot of manual work, but this can be achieved using VB code. I searched on net but did not got exact code what I want. We can use charting tool but for that i need some programming language to do calculations. Just I want to save in excel and want to do some calculations based that I can generate buy and sell signals.
I wish I could help. But I dont have NEST or Data Feed with me to check out what I could do. Have u tried any OCR techniques by capturing the screenshots, Wild Idea! Just a thought, though.