LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 18th 15, 07:13 PM
Junior Member
First recorded activity by ExcelBanter: Jun 2015
Posts: 1
Default % of OI and % of vol

find %-of-change-in-oi
compared to OI of that strikeprice
to total OI(sum b4: b16 for calls and h4:h16 for puts)
( should be for that strike-price only)
---in n18-n19-n20 and r18-r19-r20

finds %of vol of
that strike compared to total volume(sum d4:d16 for calls and
sum(f4:f16 for puts) ,
---in o18-o19-o20 and s18-s19-s20

Am attaching an excel file where I have mentioned as to what is the
problem. Please help me to solve. Also this is one table but
originally this has to be copied in such 200+ tables , so please if
possible , find the solution using relative referencing.

here xlsx file is not allowed to be uploaded .
dropbox link of that is


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

All times are GMT +1. The time now is 05:03 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017