Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Bank of Canada rate symbol and quote server

General questions about using Fund Manager that do not fit into any other forum.

Postby gbenn » Fri Jan 19, 2024 3:30 pm

Just wondering if anyone knows how I can retrieve the Bank of Canada rate so I can create an investment to track this value. The Bank of Canada (https://www.bankofcanada.ca/rates/inter ... est-rates/) has this information. The symbol is V39078. Can the Bank of Canada be added as a quote server so I can retrieve this information? Is there any other way to get this info?
Thx
gbenn
 
Posts: 14
Joined: Thu Sep 22, 2011 1:24 pm

Postby Mark » Fri Jan 19, 2024 3:49 pm

Hi gbenn,

I'm not sure if this quote is available on any of the quote servers, you'd just have to search. Maybe someone else knows, and can comment...

I did look at this site, and yes, it would be possible to add as a quote server. They also have downloadable prices, so if you did download daily prices to a CSV file you can use the generic price import with the options:

Specify Date: OFF
Specify Symbol: ON (and enter the symbol)
Input Format: YY-MM-DD,NAV
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11354
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby gbenn » Sun Jan 21, 2024 12:56 pm

I downloaded the information as you suggested and this solves my immediate concern. I'll do a manual update of the interest rate as it changes, which is not very often.
Thx Mark
gbenn
 
Posts: 14
Joined: Thu Sep 22, 2011 1:24 pm


Return to General

Who is online

Users browsing this forum: No registered users and 5 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.