How to link yahoo finance data in excel on mac?

Discussion in 'Mac Apps and Mac App Store' started by Haji223, Jun 18, 2015.

  1. Haji223 macrumors newbie

    Haji223

    Joined:
    Jun 18, 2015
    Location:
    Hong Kong
    #1
    I am using MS Office 2011 Home and Business version.
    I called MS hotline that they asked me to purchase Filemaker Server to do that.
    Can we have a cheaper way to make that automatically update its data?

    Thanks a lot.
     
  2. glenthompson macrumors 68000

    glenthompson

    Joined:
    Apr 27, 2011
    Location:
    Virginia
    #2
    There used to be a way to get Yahoo finance to produce a CSV file of the desired stocks. That can be imported into Excel. Can't be more specific as it's been over 5 years since I dealt with it.
     
  3. Haji223 thread starter macrumors newbie

    Haji223

    Joined:
    Jun 18, 2015
    Location:
    Hong Kong
    #3
    You mean data cannot update by one click by using this version ?
     
  4. Haji223 thread starter macrumors newbie

    Haji223

    Joined:
    Jun 18, 2015
    Location:
    Hong Kong
    #4
    or can I write some code in VBA to make this possible?
     
  5. glenthompson macrumors 68000

    glenthompson

    Joined:
    Apr 27, 2011
    Location:
    Virginia
    #5
    No one-click method that I know of. Our use of it was to grab the file and put the data into a database on the server for a web app to use.

    You will have to write some code to get it to work. I can't help you there as I haven't worked with VBA in many years.
     

Share This Page