Create list in new worksheet with current info after multiple filtering
Hi all, I have been trying to deal with this issue by myself during the last 2 weeks, but I am giving up...
For each of the following rows, I need to create a new worksheet based on the following info (see below) and the following filters:
Symbol CallPut Strike Price
A130420P00042000 P 42 0.83
A130420P00041000 P 41 0.55
A130420P00040000 P 40 0.37
A130420P00039000 P 39 0.25
A130420P00038000 P 38 0.16
A130420P00035000 P 35 0.04
Starting from the first one, A130420P00042000, I need to calculate 10% of the strike and copy in the following rows the next symbols smaller values (only consider integers, for 4.2 only 4 will be considered and for 3.8 only 3...). As an example:
- A130420P00042000 (row being evaluated, and copy the next 4 smaller rows -resulting from calculating 10% of 42 and taking only the integer).
This is how the new table should look, filtering the first 3 rows (the idea is to do it for all the rows available)
A130420P00042000 (42, 1st row evaluated and next4 )
A130420P00041000 (41, 2nd row evaluated, and next 4)
A130420P00040000 (40, 3rd row evaluated, and next 4)
A130420P00039000 (39, 4th row evaluated and next 3 -this is because 10% of 39 is 3.9 but we only take the integer into consideration. Anyhow... only 2 rows are still available, so I need to copy only those)
I will REAAAALLLY appreciate your help, as I am totally lost about how to do this filter!!
Thank you in advance and look forward to reading you!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1