ThinkorSwim Watchlist RTD Export to Excel – Pulling Data At a Specific Time


Category:
0
0

Hello,

 

I am pulling SPX data from one of my watchlists and it is linked to an excel file on my computer with an RTD file. Right now, the data updates as the market moves, which is exactly what I want. how can I make it so that every day at market close, the data is taken and stored in a new row? I am trying to make a “mini-database.”

Thank you!

Marked as spam
Posted by (Questions: 8, Answers: 5)
Asked on December 7, 2018 8:46 pm
381 views
0
Private answer

Copy then paste special, values only.

Marked as spam
Posted by (Questions: 37, Answers: 4084)
Answered on December 8, 2018 11:07 am
0

I just read about paste special. How do I get excel to copy the value?

( at December 8, 2018 1:58 pm)
0

Select cells, right-click, select copy

( at December 8, 2018 5:22 pm)
0

Can you guys clarify what you mean by mini data base?

How does this excel linking process work?

( at December 9, 2018 7:49 am)
0

Linking data to Excel is explained in this video: https://www.hahn-tech.com/thinkorswim-rtd-excel/

( at December 9, 2018 9:04 am)