How to link yahoo finance data in excel on mac?

Haji223

macrumors newbie
Original poster
Jun 18, 2015
3
1
Hong Kong
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.
 

glenthompson

macrumors 68000
Apr 27, 2011
1,929
128
Florida
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.
 

glenthompson

macrumors 68000
Apr 27, 2011
1,929
128
Florida
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.