Page 1 of 1
Canadian Long Bonds: import quotes into excel?
Posted: Sun Mar 09, 2014 5:55 pm
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?
Re: Canadian Long Bonds: import quotes into excel?
Posted: Mon Mar 10, 2014 7:31 am
by Gosso
Re: Canadian Long Bonds: import quotes into excel?
Posted: Mon Mar 10, 2014 12:35 pm
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.