Hello Everyone,
Can you please Help me understand how do i calculate “% Change in Open Interest” in Microsoft Excel.
Have a Look at the screenshot, this is what i want to calculate.
Take yesterday’s OI and todays OI, subtract both and divide by yesterday’s, that should give you change.
Yeah, i know the Formula, but didn’t know how to do it in Microsoft Excel, but no worries i figured the answer out.
Thanks for the Reply.