Canadian Long Bonds: import quotes into excel?
Moderator: Global Moderator
Canadian Long Bonds: import quotes into excel?
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?
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.
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.