SONJOE JOSEPH
Member
Dear All Excel Experts,
In the working file there are two sheets named "LIVE PRICE" and "BSM". In the "Live Price" sheet as soon as i click the combo box and select any of the items say NIFTY17MAY9200PE it will have to extract the Delta, Gamma, Theta,Vega & Rho values of this particular NIFTY17MAY9200PE from the "BSM" sheet to the "Live Price" sheet were i have entered 4 columns named Delta, Gamma, Theta, Vega & Rho. In this particular case the values are: Delta =-0.07, Gamma = 0.001, Theta = -1.09, Vega = 0.58 & Rho = -0.15.
Please help me how this can be achived. The working file is attached along with this message.
Regards,
Sonjoe Joseph
In the working file there are two sheets named "LIVE PRICE" and "BSM". In the "Live Price" sheet as soon as i click the combo box and select any of the items say NIFTY17MAY9200PE it will have to extract the Delta, Gamma, Theta,Vega & Rho values of this particular NIFTY17MAY9200PE from the "BSM" sheet to the "Live Price" sheet were i have entered 4 columns named Delta, Gamma, Theta, Vega & Rho. In this particular case the values are: Delta =-0.07, Gamma = 0.001, Theta = -1.09, Vega = 0.58 & Rho = -0.15.
Please help me how this can be achived. The working file is attached along with this message.
Regards,
Sonjoe Joseph