Quantcast
I have 23 consecutive profitable trades of 15% or better. How is this possible? Every day there are hundreds of stocks setting new highs, no matter what happens in the overall market. Many of these stocks are still at very reasonable valuations. Afraid of buying stocks at their highs? Think of it this way: a new high is really a future floor for companies with solid financial underpinnings. Quantitative momentum modeling makes it easy to identify stocks that can continue this upward momentum trend. Why does this happen? It's really very simple..ask me about what investors and cows have in common. I am $$$ MR. MARKET $$$. I AM HUGE!!! Bring me your finest meats and cheeses. You can join in on the fun. Register for free and you'll be able to post messages on this forum and also receive emails when $$$ MR. MARKET $$$ makes his own trades. ($$$MR. MARKET$$$ is a proprietary investor and does not provide individual financial advice. The stocks mentioned on this forum do not represent individual buy or sell recommendations and should not be viewed as such. Individual investors should consider speaking with a professional investment adviser before making any investment decisions.)
Page 1 of 2 12 LastLast
Results 1 to 10 of 17
  1. #1
    Join Date
    Jan 2004
    Location
    South Dakota
    Posts
    801

    Default Yahoo Historical Quotes Downloader.xls

    Just thought I'd put this up here for anyone who needs or wants to download historical data from Yahoo Finance.

    End Date is automatically set to the current date.
    Start Date is set to 140 days in the past. Feel free to change either of these
    Put in the tickers you want in column B under 'Symbol' and push the 'Get Prices' button. Excel will save a .csv file for each ticker in the same directory as the workbook.

    I also have one that creates a new sheet in the workbook for each symbol if you don't want all the seperate files, but it is 10x slower.

    Edit: I guess I can't upload it to the forum. PM me if you are interested and I can email it to ya. It's pretty slick.
    Buy Low
    Sell High
    STAY FROSTY!

  2. #2
    tulsatom Guest

    Default

    I'm newbie in this in Feb 06 you posted a spreadsheet data downloader - can you send Yahoo Historical Quotes Downloader.xls to me?
    tom_tulsa@yahoo.com
    Last edited by tulsatom; 03-06-2006 at 01:54 PM. Reason: typo error

  3. #3
    Mien Guest

    Default Yahoo Historical Quotes Downloader.xls

    Please send it to me as well.

    My email is investor2011@hotmail.com.

    Thanks a bunch.

  4. #4
    Join Date
    Mar 2006
    Posts
    2

    Default

    Hello Scifos.......Do you think it would be possible to send me the historical quotes downloader also?
    My e-mail is:cshep11@hotmail.com
    Thanks alot.

  5. #5
    slouie39 Guest

    Thumbs up Yahoo Historical Quotes Downloader

    I'm new to this site. I've seem messages indicating you can email a spreadsheet data downloader - can you send Yahoo Historical Quotes Downloader.xls to me?

    Thanks
    Bob

  6. #6
    Join Date
    Jan 2004
    Location
    South Dakota
    Posts
    801

    Default

    Quote Originally Posted by slouie39
    I'm new to this site. I've seem messages indicating you can email a spreadsheet data downloader - can you send Yahoo Historical Quotes Downloader.xls to me?

    Thanks
    Bob
    I'll need an email address
    Buy Low
    Sell High
    STAY FROSTY!

  7. #7
    Join Date
    Sep 2003
    Location
    Nijmegen, NL
    Posts
    2,198

    Default

    OK, here is the downloader. I finally succeeded in uploading it, after some fiddling. There seemed to be something wrong with the upload permissions. Anyway. I zipped the file together with the (necessary!) Data folder.

    Regards,

    Karel
    Attached Files Attached Files
    My Investopedia portfolio
    (You need to have a (free) Investopedia or Facebook login, sorry!)

  8. #8
    Join Date
    Jan 2004
    Location
    South Dakota
    Posts
    801

    Default

    Props to Karel!
    Buy Low
    Sell High
    STAY FROSTY!

  9. #9
    Join Date
    Sep 2003
    Location
    Akron, OH
    Posts
    1,714

    Question

    Quote Originally Posted by Karel
    OK, here is the downloader. I finally succeeded in uploading it, after some fiddling. There seemed to be something wrong with the upload permissions. Anyway. I zipped the file together with the (necessary!) Data folder.

    Regards,

    Karel
    Karel,

    When I click on "Get Prices", I get a disabled macros message. What is the magic word to get this thing running?

    Thanks.

    Tim
    Tim - Retired Problem Solver

  10. #10
    Join Date
    Jan 2004
    Location
    South Dakota
    Posts
    801

    Default

    Quote Originally Posted by mimo_100
    Karel,

    When I click on "Get Prices", I get a disabled macros message. What is the magic word to get this thing running?

    Thanks.

    Tim
    In excel, click on "Tools" then "Macros" then "Security" and set to "Medium". Close excel and re-open the file. It will say macros can be dangerous and ask if you want to enable them for this file. Click yes and you're set.
    Buy Low
    Sell High
    STAY FROSTY!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. IIC's Winners Watchlists
    By IIC in forum Discussion
    Replies: 8994
    Last Post: 03-30-2017, 07:55 AM
  2. Historical Data Needed
    By diogenes in forum Discussion
    Replies: 5
    Last Post: 11-09-2005, 10:13 PM
  3. yahoo groups is at it again
    By jonnieocean in forum Discussion
    Replies: 4
    Last Post: 10-21-2003, 07:05 AM
  4. Why we left Yahoo Groups
    By mrmarket in forum Discussion
    Replies: 3
    Last Post: 10-12-2003, 11:04 PM
  5. R.I.P. Yahoo Groups
    By mrmarket in forum Discussion
    Replies: 1
    Last Post: 09-29-2003, 03:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  




Do you like this site?

Go to the homepage of
$$$ MR. MARKET $$$