Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
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()[1]"; 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 ?
-- W.
-- The rest is silence
Can you help answer these questions from other members on NexusFi?
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
What rtd codes are you using to get Implied Volatility and Open Interest on the excel charts you are showing?
In my experience, those fields come up blank when exporting to excel (rtd or direct export from Marketwatch).