Sir....Can you give me VBA COde of data download through Yahoo ???
Peter
March 26th, 2012 at 7:45pm
Hi Carole,
It all depends on your opinion of AAPL - if you're view is that there a lot more upside, then rolling your long call into a higher strike seems a fair play. However, if you're happy with the gains so far and unsure of future price direction then best to exit completely and look for the next trading opportunity.
Peter
March 26th, 2012 at 7:40pm
Hi Matt,
I'm not 100% sure on that one, but seems sensible to use the floating price as the basis for your hedge.
carole
March 16th, 2012 at 12:34am
Hi Peter I have a few Apple options that are well in the money expire April and May. Assuming Apple goes extremely high in the next few days, woudl you suggest holding them on selling on the spike and rebuying at a higher strike?
Matt
March 15th, 2012 at 9:06am
Hi Peter,
I'm buying monthly fuel oil contracts based on a floating index. Unless i hedge through purchasing swaps for the monthly index (which price basis average of the month) i will only know the settlement price of my contract at the end of the month.
I would like to work with options on my contrats. When taking into account some of your strategies e.g. long synthetic, do i consider my floating price contracts as being long an "underlying" or will the options i trade in be purely independent paper trasnactions? Im particularly interested in a zero-cost collar which i can not see listed here.
Thank you.
Peter
February 14th, 2012 at 4:07pm
No worries. Just to note though that I do get the data from Yahoo! except I back adjust all prices (open, high, low and close) by the dividends/splits and don't limit the rounding to two decimal places.
For longer data this makes a big difference.
Bill
February 13th, 2012 at 5:32am
Thanks for the historical data on the US exchanges. Your data is "cleaner" than Google or Yahoo, which helps me to test my ideas rather than spending most of my time chasing anomalies in the the data.
Peter
February 2nd, 2012 at 5:35pm
I don't know of any standalone software that does this on a Mac - but you're welcome to use my spreadsheet for graphing option positions;
58 Comments
Peter March 27th, 2012 at 5:01pm
Hi Vivek,
See Willow Solutions for the VBA code to do this.
Vivek March 27th, 2012 at 4:00am
Sir....Can you give me VBA COde of data download through Yahoo ???
Peter March 26th, 2012 at 7:45pm
Hi Carole,
It all depends on your opinion of AAPL - if you're view is that there a lot more upside, then rolling your long call into a higher strike seems a fair play. However, if you're happy with the gains so far and unsure of future price direction then best to exit completely and look for the next trading opportunity.
Peter March 26th, 2012 at 7:40pm
Hi Matt,
I'm not 100% sure on that one, but seems sensible to use the floating price as the basis for your hedge.
carole March 16th, 2012 at 12:34am
Hi Peter
I have a few Apple options that are well in the money expire April and May. Assuming Apple goes extremely high in the next few days, woudl you suggest holding them on selling on the spike and rebuying at a higher strike?
Matt March 15th, 2012 at 9:06am
Hi Peter,
I'm buying monthly fuel oil contracts based on a floating index. Unless i hedge through purchasing swaps for the monthly index (which price basis average of the month) i will only know the settlement price of my contract at the end of the month.
I would like to work with options on my contrats. When taking into account some of your strategies e.g. long synthetic, do i consider my floating price contracts as being long an "underlying" or will the options i trade in be purely independent paper trasnactions? Im particularly interested in a zero-cost collar which i can not see listed here.
Thank you.
Peter February 14th, 2012 at 4:07pm
No worries. Just to note though that I do get the data from Yahoo! except I back adjust all prices (open, high, low and close) by the dividends/splits and don't limit the rounding to two decimal places.
For longer data this makes a big difference.
Bill February 13th, 2012 at 5:32am
Thanks for the historical data on the US exchanges. Your data is "cleaner" than Google or Yahoo, which helps me to test my ideas rather than spending most of my time chasing anomalies in the the data.
Peter February 2nd, 2012 at 5:35pm
I don't know of any standalone software that does this on a Mac - but you're welcome to use my spreadsheet for graphing option positions;
Option Trading Workbook
Alternatively, you can view an online version here;
Online Option Calculator
Joe February 2nd, 2012 at 9:30am
Hi from Germany,
thank you for this great site!!!!
Does anyone of you know a bout a software which can show the option trade in graphics? If it is a Mac Software even better.
I would not mind to enter the values, but if it works with actual quotes even better
Joe
Add a Comment