I would like to use Delta (one of the Greeks) for my calculations in Excel. Does anybody of you guys know, is there any way how to load Delta to Excel? Is there any data source or other solution? It's possible to load Delta from ThinkOrSwim, but the problem is, that I am not allowed to create ThinkOrSwim account (I am citizen of one of the countries which are not allowed to open an ToS account). So I am looking for some other solution, where to get Delta. Any ideas? Thank you
I was thinking about it, but for the calculation I need repo (the level of repurchase agreement) and the volatility, etc. I have IQ Feed data source, but unfortunately, they don't provide Delta or repo, etc. I know several market data providers that can provide me with greeks on options for given underlying but they are quite expensive (Bloomberg, markit etc). I am looking for some retail solution.
S = spot K = strike r = risk-free rate d = div yield vol = volatility T = Time d1 = (LN(S/K)+(((r-d)+(vol^2)/2)*T))/(vol*sqrt(T)) N(d1)=NORM.DIST(d1,0,1,TRUE) Call_delta = N(d1) Put_delta = -N(d1)
I sent you private message. Thank you for your suggestions. I have Hoadley plugin, but for some reason, I stopped using it. I prefer to use my own calculations. I was trying to use IB as data feed, but it's not very reliable. Loading data from IB is not smooth, it's shaky and sometimes I get wrong data. Sometimes the data feed is frozen, etc. I have XLQ Excel plugin, it's very good tool for loading data from different sources.
I believe this maybe what you are looking(?) for http://news.cqg.com/workspaces/main/2015/03/excel-for-options-on-futures-information.html
If you need precision with your Delta value (want it accurate), you need to insure your choice for "vol" is correct (or as precise as you require).