Canadian Money Forum banner

1 - 6 of 6 Posts

·
Registered
Joined
·
75 Posts
Discussion Starter #1
I used Excel for a long time but then screwed up something in my computer and it is dead. Even worse is I cannot find my disc to repair it.

So it's a new day and I'm using OpenOffice and the only thing I miss is the ability to automatically get quotes for Canadian Mutual Funds and ETFs. Does anybody know a work around or add-on?
 

·
Registered
Joined
·
3,061 Posts
You need to be online to get your automated quotes, so you might as well use Google Docs for this purpose -- Canadian Capitalist ran a very useful article on how to do this:

http://www.canadiancapitalist.com/portfolio-snapshot-with-google-docs/

You get automatic updated quotes on everything in your portfolio plus you can view a pie chart of your asset allocation.

Note that the Yahoo script for converting from USD to CAD seems to be broken now; use the Google Finance formula instead.

I've been using this for about six months now and it's brilliant.

Edited to add that I spotted this comment under CC's post:

Your post triggered my search for the equivalent extension for OpenOffice Calc. I found it and implemented it! The extension is called Get Stock Price and the function is ”=getprice(xiu.to)” for example with the xiu ticker. It takes the data from yahoo finance so write the tickers like you would find them in yahoo finance. Here is the link: http://extensions.services.openoffice.org/fr/project/getStockPrice.
Works flawlessly for now. Thanks.
 

·
Registered
Joined
·
3,061 Posts
I'll try and find out why. But as you mention, the Google Finance formula =GoogleFinance("CURRENCY:USDCAD") works, so I'll put this as a low-priority item on my plate.
I noticed the Yahoo issue when my pie chart stopped working, and in fact if you look at your original blog post I think yours isn't working anymore either; I suspect it's due to the broken Yahoo link, which causes the percentages to come up with error messages and thus the pie chart has but one slice.
 

·
Registered
Joined
·
75 Posts
Discussion Starter #5
You need to be online to get your automated quotes, so you might as well use Google Docs for this purpose -- Canadian Capitalist ran a very useful article on how to do this:

http://www.canadiancapitalist.com/portfolio-snapshot-with-google-docs/

You get automatic updated quotes on everything in your portfolio plus you can view a pie chart of your asset allocation.

Note that the Yahoo script for converting from USD to CAD seems to be broken now; use the Google Finance formula instead.

I've been using this for about six months now and it's brilliant.

Edited to add that I spotted this comment under CC's post:

Your post triggered my search for the equivalent extension for OpenOffice Calc. I found it and implemented it! The extension is called Get Stock Price and the function is ”=getprice(xiu.to)” for example with the xiu ticker. It takes the data from yahoo finance so write the tickers like you would find them in yahoo finance. Here is the link: http://extensions.services.openoffice.org/fr/project/getStockPrice.
Works flawlessly for now. Thanks.
Thanks for your responses. The "GetQuote" OpenOffice extension is the latest version of the GetStockPrice and it works well for stocks but does not work with Canadian mutual funds. I think it is because Yahoo! Finance dropped their coverage of them.

I'll look at the Google Docs version.
 
1 - 6 of 6 Posts
Top