Thinkorswim RTD Excel and Charting

« Back to Previous Page
Tags:
Category:
▲
0
▼
♥ 0

Hello, Everyone,

I looked at Hahn-Tech’s video on Youtube “Thinkorswim RTD Excel” (https://www.youtube.com/watch?v=TWdOYvN9eIs)  That is great and easy to get real time data from TOS option chain. Then I use Excel SUM() function to easily get total Call or Put volume in real time.

My question is: it is possible to make an Excel line chart to plot the Call or Put volume change vs. time per minute? or use Excel dashboard to plot the real time volume change?

Thanks,

Jim

Marked as spam
Posted by (Questions: 1, Answers: 0)
Asked on July 4, 2019 4:38 pm
573 views
▲
0
▼
✔
Private answer

It seems you are asking how to get historical data to display on a graph in Excel.

...plot the Call or Put volume change vs. time per minute...

If that is your goal, then it would require some advanced custom code in VBA (the programming language the runs custom macros in Excel). VBA stands for "Visual Basic for Applications". This is far beyond the scope of anything I intend to cover in the Q&A forum.

Marked as spam
Posted by (Questions: 37, Answers: 4118)
Answered on July 5, 2019 11:57 am
« Back to Previous Page