How to link yahoo finance data in excel on mac?

[Haji223]

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]

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.

 

[Haji223]

You mean data cannot update by one click by using this version ?

 

[Haji223]

or can I write some code in VBA to make this possible?

 

[glenthompson]

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.