Canadian Long Bonds: import quotes into excel?

Discussion of the Bond portion of the Permanent Portfolio

Moderator: Global Moderator

Post Reply
User avatar
mgtow
Junior Member
Junior Member
Posts: 24
Joined: Mon Feb 10, 2014 11:35 am
Location: CANADA

Canadian Long Bonds: import quotes into excel?

Post by mgtow »

I have spreadsheets that can pull stock quotes from MSN, and Yahoo, but I haven't been able to find a symbol (or a way) to get quotes on Canadian Federal Long bonds.  Has anyone here had success with doing this?
User avatar
Gosso
Executive Member
Executive Member
Posts: 1052
Joined: Fri Jan 06, 2012 8:22 am
Location: Canada

Re: Canadian Long Bonds: import quotes into excel?

Post by Gosso »

User avatar
mgtow
Junior Member
Junior Member
Posts: 24
Joined: Mon Feb 10, 2014 11:35 am
Location: CANADA

Re: Canadian Long Bonds: import quotes into excel?

Post by mgtow »

Thanks. I figured it out.

For those that use google docs, you can import this Canadian Federal Bond quote table
using this formula

=ImportHtml("http://www.globeinvestor.com/servlet/Pa ... gov&page=1", "table",1)

It appears to be updated daily.  I still need to figure out how to import the date, but's that's minor.
Post Reply