+- Dividend Growth Forum (http://DividendGrowthForum.com)
+-- Forum: Dividend Growth Investing (http://DividendGrowthForum.com/forumdisplay.php?fid=15)
+--- Forum: Resources for Dividend Growth Investors (http://DividendGrowthForum.com/forumdisplay.php?fid=36)
+--- Thread: Mac Users: Excel (/showthread.php?tid=347)
Mac Users: Excel - Robandcindy2 - 01-10-2014
Quick question:
Anyone successfully using Excel on a Mac and the web query function to update/download financial data?
Thanks!!
Rob
RE: Mac Users: Excel - Kerim - 01-11-2014
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.
RE: Mac Users: Excel - Robandcindy2 - 01-14-2014
Excel 2011 on our iMac (10.9) working just fine-web query and all. Using the Office 365 version.
RE: Mac Users: Excel - Kerim - 01-15-2014
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!
RE: Mac Users: Excel - Robandcindy2 - 01-15-2014
(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-stuff/Excel/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
RE: Mac Users: Excel - Dividend Watcher - 01-16-2014
Interesting spreadsheet. I'm going to have to play with it.