Hi there
I have a Spreadsheet that can pull basic data of Yahoo and do some calculations.
I would now like to add a link to pull the WEEKLY Option at the selected "Strike" price from YAHOO.
The Weekly options expire on Fridays and the symbol for lookup is
PCX110506C00024000 PCX is the symbol, 11 = year 05 =MM 06 = DD the Friday expiry date of the option C = CALL or PUT the rest is the strike price in this case 24 USD
Doesn't matter if you don't understand the Stock market -- its manipulating this string is the problem.
Now by a "Hyperlink" to this option I get the details
For example http://finance.yahoo.com/q?s=PCX110506C00024000
I can dynamically insert the symbol, C or P as required and the price but what I need to do is find a way of generating the YYMMDD piece for the Next Friday from the current date
Any ideas anyone
Thanks
jimbo
Bookmarks