MLD comes with inbuilt symbol lists for all markets and will download historical data for all symbols from Yahoo!.
Matthew
January 11th, 2013 at 3:38pm
Hi Peter,
I wish to download a lot of historical data from yahoo! - around 5,000 different stocks across different countries, and for about 2 years worth of data for each stock.
I wish to do it in a format similar to what you have done with your historical data i.e. a separate text file for each different stock.
Can you recommend a time efficient way / method to do this?
Due to the sheer number of stocks that I am downloading, doing them one by one is a method I would prefer to avoid!
Kind Regards Matthew
Nitish
December 27th, 2012 at 8:54am
I am new here. what does BTO and STO mean and what is the definition of a short call? Can you give an example?
Peter
September 5th, 2012 at 6:31pm
Hi Eli,
Are you running a non-English version of Windows/Excel? This was the problem Oswald had - he was on a Chinese version. For some reason the symbol sent when using the Macros appends or changes the data and characters sent. We didn't get to the bottom of it as Oswald switched to an English version and it worked.
I'm not sure what it could be at this point. I'd need to re-write the Macro to enable logging and have a user on a non-English version run it in order to investigate. Unless there is a setting somewhere that you know of that could be causing data to be amended before sending?
Eli
September 5th, 2012 at 10:01am
Good day: seem to be having a similar issue to Peter - extracting data, error message comes back saying cannot find symbol.
AAPL, HAL, XOM
Thanks Eli
Peter
August 31st, 2012 at 10:49pm
Hi Oswald,
Does the symbol have historical data on the Yahoo site or only latest quotes? What is the symbol?
Oswald
August 31st, 2012 at 4:58am
I am having trouble trying out your volatility calculator. It returns a warning saying "symbol invalid". Kindly help, thanks!
Peter
April 9th, 2012 at 5:55pm
Hi DoSSlar$,
1. To roll your long position to the next expiration you would need to sell to close your front month position and buy to open the back month. The cost will be brokerage on both sides.
2. Sell to close only. You will no longer have a position and cannot profit from any future market movements.
3. If you exercise you will need enough capital to handle the assignment of the stock, which will be quite high given APPL's current share price!
DoSSlar$
April 4th, 2012 at 9:58pm
Peter, Thank you for your education, i had mentioned in my earlier post that i have few more options like Carole, for May and June and feel that AAPL will have a very good reporting season and probability yo potential to upside out weighs the down side. As you mentioned to Carole, we have three options. 1.Rollover the say May Call to next month (ie expiring in June), can you please explain in simple terms what are my cost of doing that and what happens from to the existing option I hold for May.? 2. Close out. 3. Exercise the Option (Buy the underlying).
I am more interested in understanding the Option-1.
58 Comments
RB February 11th, 2013 at 8:03am
Do you recommend any brokers and whether it is better to trade European v American options
Peter January 11th, 2013 at 3:47pm
Hi Matthew,
;
I use ML Downloader
MLD comes with inbuilt symbol lists for all markets and will download historical data for all symbols from Yahoo!.
Matthew January 11th, 2013 at 3:38pm
Hi Peter,
I wish to download a lot of historical data from yahoo! - around 5,000 different stocks across different countries, and for about 2 years worth of data for each stock.
I wish to do it in a format similar to what you have done with your historical data i.e. a separate text file for each different stock.
Can you recommend a time efficient way / method to do this?
Due to the sheer number of stocks that I am downloading, doing them one by one is a method I would prefer to avoid!
Kind Regards
Matthew
Nitish December 27th, 2012 at 8:54am
I am new here. what does BTO and STO mean and what is the definition of a short call? Can you give an example?
Peter September 5th, 2012 at 6:31pm
Hi Eli,
Are you running a non-English version of Windows/Excel? This was the problem Oswald had - he was on a Chinese version. For some reason the symbol sent when using the Macros appends or changes the data and characters sent. We didn't get to the bottom of it as Oswald switched to an English version and it worked.
I'm not sure what it could be at this point. I'd need to re-write the Macro to enable logging and have a user on a non-English version run it in order to investigate. Unless there is a setting somewhere that you know of that could be causing data to be amended before sending?
Eli September 5th, 2012 at 10:01am
Good day: seem to be having a similar issue to Peter - extracting data, error message comes back saying cannot find symbol.
AAPL, HAL, XOM
Thanks
Eli
Peter August 31st, 2012 at 10:49pm
Hi Oswald,
Does the symbol have historical data on the Yahoo site or only latest quotes? What is the symbol?
Oswald August 31st, 2012 at 4:58am
I am having trouble trying out your volatility calculator. It returns a warning saying "symbol invalid". Kindly help, thanks!
Peter April 9th, 2012 at 5:55pm
Hi DoSSlar$,
1. To roll your long position to the next expiration you would need to sell to close your front month position and buy to open the back month. The cost will be brokerage on both sides.
2. Sell to close only. You will no longer have a position and cannot profit from any future market movements.
3. If you exercise you will need enough capital to handle the assignment of the stock, which will be quite high given APPL's current share price!
DoSSlar$ April 4th, 2012 at 9:58pm
Peter, Thank you for your education, i had mentioned in my earlier post that i have few more options like Carole, for May and June and feel that AAPL will have a very good reporting season and probability yo potential to upside out weighs the down side. As you mentioned to Carole, we have three options.
1.Rollover the say May Call to next month (ie expiring in June), can you please explain in simple terms what are my cost of doing that and what happens from to the existing option I hold for May.?
2. Close out.
3. Exercise the Option (Buy the underlying).
I am more interested in understanding the Option-1.
Add a Comment