Export Options Statistics

December 12th, 2015, 08:00 AM

Hi

I am trying to discover ToS.
Is there a way to export the options statistics ? (Excel/Csv..)

-- W

December 12th, 2015, 09:04 AM

if you want to export greeks, iv and so on, go to trading tab, put the ticker and make sure anything you want to see is showing. go to the wheel icon, select export to excel. Then open excel and paste control+v and not only should you have exported but it will update in real time

December 12th, 2015, 11:46 AM

jeremymag

if you want to export greeks, iv and so on, go to trading tab, put the ticker and make sure anything you want to see is showing. go to the wheel icon, select export to excel. Then open excel and paste control+v and not only should you have exported but it will update in real time

Thx. I can export my options chain correctly, but the options statistics is not exported.

-- W.

December 14th, 2015, 01:10 PM

They must be shown to be exported. Some are not available. But first be sure that you actually see them before the export

December 14th, 2015, 01:42 PM

jeremymag

They must be shown to be exported. Some are not available. But first be sure that you actually see them before the export

@jeremymag I see the options statistics component. But it is not exported. The only thing that is expored is the options chain. FWIW, the options chain is exported even if I don't see it.

-- W.

December 15th, 2015, 10:58 AM

wwwingman

@jeremymag I see the options statistics component. But it is not exported. The only thing that is expored is the options chain. FWIW, the options chain is exported even if I don't see it.

-- W.

there is an alternative, when you export and see prices you do it from the trade tab, when you do it from the analyze tab, I think you cant export prices but you can export parameters

December 15th, 2015, 11:20 AM

jeremymag

there is an alternative, when you export and see prices you do it from the trade tab, when you do it from the analyze tab, I think you cant export prices but you can export parameters

@jeremymag

Again thank you. I really liked your idea and thought it would work but.. when I do that, ToS says there is no page to print.

I asked the ToS support about this. The answer was clear :

Quoting

Unfortunately, the options statistics section will not export to a spreadsheet. I apologize for any inconvenience.

-- W

December 27th, 2015, 06:25 PM

sorry for the late reply, didnt saw there was an answer

the only other way then is to pick up prices and make a spreadsheet that will calculate your own parameters. If its a good enough sheet the information will be flawless and youll have the parameters, I use to do it when I trade heavely using the greeks, since no services carries calculation for higher order greeks

December 28th, 2015, 02:45 AM

jeremymag

the only other way then is to pick up prices and make a spreadsheet that will calculate your own parameters. If its a good enough sheet the information will be flawless and youll have the parameters, I use to do it when I trade heavely using the greeks, since no services carries calculation for higher order greeks

Hi @jeremymag

Thx, and I agree. But ...
This does not cover all cases I need.

For example, looking for past data.
If I want the volume of yesterday and make a custom study, I can't get the custom study data, and cannot generate that under Excel.
if I have a custom study named custom1 that get yesterday volume then :
A call like =RTD("tos.rtd"; ; "VOLUME"; NameOfTheOption) WILL WORK.
But =RTD("tos.rtd"; ; "CUSTOM1"; NameOfTheOption) WILL NOT WORK.

More info here in another thread I made.

-- W.

Export Options Statistics

Discussion in ThinkOrSwim

Export Options Statistics