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)
With thinkorswim you can, their application includes a DDE server which I use to pull option quotes into OpenOffice Calc. It will also work with Excel. I use Calc because it allows me to reference the symbol from another cell. In Excel the symbol has to be a literal string in the DDE link.
What is the formula we need to put into a cell to get the OHLC of a given instrument with TOS for Excel ? also, do we need to enable the DDE server somewhere or it's always 'ON' ?
It's always on, for 6E you'd use these formulas:
=TOS|LAST!'/6EH1'
=TOS|BID!'/6EH1'
=TOS|ASK!'/6EH1'
=TOS|HIGH!'/6EH1'
=TOS|LOW!'/6EH1'
In Calc you'd use:
=DDE("TOS";"LAST";"/6EH1")
In Calc you can put the /6EH1 in another cell, e.g. A1 and use:
=DDE("TOS";"LAST";A1)
There's no way to acheive this indirection in Excel.