Mac Users: Excel

[Robandcindy2]

Quick question:

Anyone successfully using Excel on a Mac and the web query function to update/download financial data?

Thanks!!

Rob

[Kerim]

I've NEVER been able to get that to work. I just thought it was tough to implement and never considered that it was because I use a Mac.

I've been meaning to look into it further -- there has to be a way. But it never gets near the top of the to-do list.

Let me know if you learn how to do it.

I think I read it is easy in Google docs, but I don't want to switch from my excel sheets that I've been using and developing for years.

[Robandcindy2]

Excel 2011 on our iMac (10.9) working just fine-web query and all. Using the Office 365 version.

[Kerim]

Would you be so kind as to copy the function as you're using it?

I would be bitter if it works in 365 but not 2011!

[Robandcindy2]

(01-15-2014, 01:28 AM)Kerim Wrote: Would you be so kind as to copy the function as you're using it?

I would be bitter if it works in 365 but not 2011!

Kerim,

I had inserted this as a sheet with in my spreadsheet:

http://www.financialwebring.org/gummy-st.../Yahoo.xls

Very straight forward. Seems to work fine. The chart on the right of the sheet are all the different Yahoo Finance attributes you can grab. Won't work for Mutual Funds, only price will show up.

Rob

[Dividend Watcher]

Interesting spreadsheet. I'm going to have to play with it.