Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

the macro calculated value and table value not matching ... need help please?????

hi all,

Please can anyone help on below issue?

hi ,

one complicated task,I tried but not able to fix it,need ur help please.

see if u open the application attached i have obtained an expression in my table present in sheet 10 as option..

I recreated all the variables newly ,

all my new variables are

VD1_NM

VD2_NM

VCND_NM

VCND1_NM

PUTVD1_NM

PUTVD2_NM

PUTVCND_NM

PUTVCND1_NM. with the changes mentioned above.

please can u help ???

Now my doubt is in my table we have last column as option price:I am checking the value if it is right or wrong by checking it in macro and table value.

for PUT its working fine but for CALL it doesnt match the value in the macro.please can u help?????????????????? may be something wrong in the 1st part of my if statement which would give CALL output...i am not sure...

my exp is:its also in the column called option in my table.

if(xoptiontype_='CALL',

(Exp(-.0105 * $(T3)) * ((Avg(strike_price1)) * (if( $(VD1_NM)<0, 1+(($(VCND_NM)) * -1),$(VCND_NM))) - strike_price * (if( $(VD2_NM)<0, 1+(($(VCND1_NM)) * -1),$(VCND1_NM))) )),

EXP(-0.0105 * ($(T3))) * ((strike_price * if($(PUTVD2_NM)<0,1+(($(PUTVCND1_NM)) * -1),($(PUTVCND1_NM)))) - ((Avg(strike_price1)) * if( $(PUTVD1_NM)<0,1+(($(PUTVCND_NM)) * -1),($(PUTVCND_NM))))))

you can check these below statements in edit module  and clik on pasinputest:what ever value it shows should match the corresponding value in my table "option " column.If we substitute in msg box the value obtained here should match the table value.

'black76("c" or "p",market price, strike price, time to expiry,interest rate, volatility)//interest rate is fixed//

msgbox black76("p",65,75,0.008,0.0105,.135)

c or p is put or call

0 Replies