I am unable to show exported data of custom studies to Excel.
A call like =RTD("tos.rtd"; ; "VOLUME"; NameOfTheOption) will work.
BUT a call like =RTD("tos.rtd"; ; "CUSTOM1"; NameOfTheOption) will not work. It will give a cell in Loading state.
(Custom1 is a simple custom study for showing, for ex, yesterday open interest. And it works fine inside ToS).
I also tried what the support suggested :
=RTD("tos.rtd"; ; "OpenInterest()"; NameOfTheOption). It won't work. Cell is empty.
FWIW : I tried many fields and all the classic fields update properly in Excel. But those related to custom studies won't. Am I doing something wrong ?
This is a whole different animal.
First Im no programmer, I admire the people that can program and be a trader. I am a trader an economist so my comments might be insightful in trading and analysis perse but not in programming nature.
What you want to do is imposible inside the platform. I Have the same problem more on the side of having a working data base of historical data to analyze inter relation ships of strategies and individual options. For that I did a desing some 10 years ago, but since Im no programmer I havent be able to put it in practice. I have a friend that in theory is working on it, but results could be far into the future.
What you need is to create a webapp. First a database must be built scrapping data from yahoo or google. A usual solution to avoid problems is to get the last bid and ask and plttoing them and the mid price. A more advanced version can use the same system but scrapping several times a day. At same time print you can get the IV from yahoo (to compare with your own), underlying price and different rates (tyx tnx and so on according to your view of rate for the model). With that you can go to step 2 and make all calculation you want according to your model
a nice solution of how to present data for charting was developed by the guys in