Log In
Register
Home
Topic RSS
Facebook
Twitter
Email this5:46 am
March 30, 2017
Offline
NorthernRaven said
The A-series commission can vary from company to company; some are 15bps, others not (RBC and NBC are 25bps, for example).
ok. I will rephrase, add 15-25bps. A max 10bps diff (talking about $100 on $100k for a full 12 months) is trivial plus most can not access the F series unless you are their direct customer in most cases anyway.
7:46 pm
April 6, 2013
Offline
realtalk said
Norman1, love these tables. Any chance we could convince you to do Series F ones as well, or add them? I'm finding them a great place to temporarily park money in my registered accounts at Qtrade.
The question was raised earlier. I'm not going to expand the table.
The table is intended to raise awareness of the kind of rates available through brokerage ISA's and how those rates right now are higher than the rates from the usual HISA's from online credit unions and online banks. It is not really intended to be a "best rates" table.
Someone else is quite welcome to spend more effort than I'm willing to and produce more comprehensive tables. 
8:48 am
December 20, 2016
Offline
Norman1 said
.......
The table is intended to raise awareness of the kind of rates available through brokerage ISA's and how those rates right now are higher than the rates from the usual HISA's from online credit unions and online banks. ...../>
I, for one, have benefitted from your raising awareness about brokerage ISA's and thank you for sharing your informative insights, Norman! I have gone on to research the subject further and have created my own tracking spreadsheet of the funds that interest me using the online tracking functionality of Excel.
Stephen
9:41 am
October 27, 2013
Offline
+1 to posts #302 and #303. It is not anyone's responsibility here to do the detailed homework for investors. Be happy enough with the energy/contribution already expended.
11:38 am
September 29, 2017
Offline
Nehpets said
I, for one, have benefitted from your raising awareness about brokerage ISA's and thank you for sharing your informative insights, Norman! I have gone on to research the subject further and have created my own tracking spreadsheet of the funds that interest me using the online tracking functionality of Excel.
Stephen
Interesting... could you share some details on how you did this, for those that might try to do the same?
2:59 pm
December 20, 2016
Offline
smayer97 said
Interesting... could you share some details on how you did this, for those that might try to do the same?
An Excel spreadsheet has the ability to download and refresh data from websites that contain tables of data such as interest rate postings, for example.
The websites regularly update their postings, so by creating a spreadsheet that is linked to these sites, a customized spreadsheet that tracks information relevant to one's own interests can be updated / refreshed as needed.
Not all websites will allow their data to be exported, so it may require some trial and error to get the information you need.
This You Tube video describes how to go about setting up data downloads:
Once you download the raw data, you then design your spreadsheet to display the information you need in an informative and attractive way.
By saving and archiving existing spreadsheets and working from current versions of the spreadsheet, you can then develop a history of the information you wish to track.
There may be more sophisticated ways of doing this, but I am self taught in the set up of my own tracking spreadsheet which has worked for me.
Stephen
5:51 pm
September 29, 2017
Offline
Thanks kindly for the guidance. I'll have to investigate and give it a try. 🙂
7:50 pm
April 10, 2013
Offline
BMO mailed me a T5 for the interest earned from the HISA. I was a little surprised because I thought it would be through BMO Investorline. So now I must wait for the others to show up in the mail.
1:02 am
August 4, 2010
Offline
smayer97 said
Thanks kindly for the guidance. I'll have to investigate and give it a try. 🙂
Excel (at least the 365 versions) also has a "Stocks" datatype - you can turn a cell with a ticker symbol into a one of these, and access/refresh various fields like price, for stocks and ETFs from US and Canadian exchanges. There's also a STOCKHISTORY function to retrieve a range of previous stock prices. Unfortunately, these features aren't available for mutual funds (including ISA savings accounts).
https://support.microsoft.com/en-us/office/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54
1:16 am
August 4, 2010
Offline
Bob said
BMO mailed me a T5 for the interest earned from the HISA. I was a little surprised because I thought it would be through BMO Investorline. So now I must wait for the others to show up in the mail.
You can also retrieve many tax slips by logging into the government MyAccount/MyCRA site. Note that some companies (cough, TD brokerage) will wait until right up to the deadline to produce their slips. Some taxprep programs can also retrieve taxslips from there into their setups.
4:34 am
March 30, 2017
Offline
NorthernRaven said
Excel (at least the 365 versions) also has a "Stocks" datatype - you can turn a cell with a ticker symbol into a one of these, and access/refresh various fields like price, for stocks and ETFs from US and Canadian exchanges. There's also a STOCKHISTORY function to retrieve a range of previous stock prices. Unfortunately, these features aren't available for mutual funds (including ISA savings accounts).
https://support.microsoft.com/en-us/office/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54
Think that is only available in the office365 cloud version. I use MS Office Pro 2019 desktop installation and its not there.
For stock dividend purpose, yahoo finance actually does a pretty good job and free. I dont link my spreadsheet to it as it slows it down. I just copy and paste and then reorg the data to my own template within Excel.
8:07 am
August 4, 2010
Offline
savemoresaveoften said
Think that is only available in the office365 cloud version. I use MS Office Pro 2019 desktop installation and its not there.
For stock dividend purpose, yahoo finance actually does a pretty good job and free. I dont link my spreadsheet to it as it slows it down. I just copy and paste and then reorg the data to my own template within Excel.
It's available in the desktop app as well, but only the Office 365 subscription version it seems, not the one-time paid version.
I think you can set update options on data linkages to prevent it loading automatically (or on spreadsheet opening), so you could link and refresh manually if that were preferable to cut-and-paste.
8:20 am
April 6, 2013
Offline
Since last update, B2B Bank increased its rate from 3.85% to 4.05%:
| ISA | Rate |
| BMO High Interest Savings Account (BMT104) CAD | 4.35% |
| Scotiabank Investment Savings Account, Series A (DYN6000) CAD | |
| Manulife Bank Investment Savings Account (MIP510) CAD | 4.25% |
| Equitable High Interest Savings Account, Series A (EQB1000) CAD | 4.20% |
| Home Trust High Interest Savings Account, Class A (HOM100) | |
| B2B Bank HIIA, Series A (BTB100) CAD | 4.05% |
| NBI Altamira CashPerformer Account, Series A (NBC100) CAD | |
| RBC Investment Savings Account, Series A (RBF2010) CAD | |
| Renaissance High Interest Savings Account, Series A (ATL5000) CAD | |
| TD Investment Savings Account, Series A (TDB8150) CAD |
Please write your comments in the forum.