Free Option pricing tool posted

kcgoogler

kcgoogler

Hello Folks,

I've recently posted a fly pricing spreadsheet on my site (a glorified blog of sort). It can be modified to trade other similar structures (verticals, condors etc). Thought it would benefit you folk as well.

I am attaching the spreadsheet here to the post so you dont need to go to my website (but if you happen to.. do let me know if you have any comments ).

___

The left side of the spreadsheet is setup to show direct fly pricing across strikes and widths, and the right side shows the delta in price between various flies at different strikes – for a given width fly.

It uses data from ToS using Excel RTD link (so you will need your tos client open for data to flow through). Only cell that might need updating based on when you download the file is cell “C1”, where it needs any opra-code for the series you are interested in (it can be copy/pasted from tos).

screenshot for reference:
upload_2021-6-29_18-31-44.png



happy trading!
-gariki
 

Attachments

Did you forget to provide the macro for _xlfn?
Anyways, it is not needed. A global search replace for s/=_xlfn.CONCAT/=CONCATENATE/ does the job
 
@W-M-A, @ffs1001: Yes; it can be made to work with other broker APIs. Particularly i do want to make it work with IB's api - its been on my radar for quite a while. Not just for this spreadsheet.. but for other dashboard kind of spreadsheets i use for my trading.

For anyone wanting to venture into it, it seems possible based on this webpage:
https://www.interactivebrokers.com/en/index.php?f=1062

@DarthSidious: Did not think CONCAT was a macro. Have always used it as a direct excel function.

Cheers
-gariki
 
You must log in or register to reply here.
Back
Top