Log In
Register
Home
Topic RSS
Facebook
Twitter
Email this7:46 pm
April 6, 2013
Online
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
Online
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 |
7:24 pm
February 6, 2023
Offline
why there is no table for Brokerage investment savings accounts in USD ?
5:42 am
December 12, 2009
Offline
canada888 said
why there is no table for Brokerage investment savings accounts in USD ?
There could be, if there's enough demand for it. If one is started, I'd recommend starting a separate USD Brokerage Investment Savings Accounts thread, to keep it separate from this thread and prevent things from getting too messy.
There's certainly a lot less demand for USD HISAs and ISAs generally because, well, we're in Canada and it is most advantageous to hold most of one's currency in the currency of the primary residence as that's where it'd be most used.
Likewise, I assume there's a lot less demand for CAD deposit accounts in the U.S. on predominantly U.S.-focused HISA forums. 😉
Cheers,
Doug
8:16 am
September 29, 2017
Offline
What happened to many the posts re: USD ISA and the CRA? Did they get moved or just deleted? I cannot find them. Links in my email only take me to this thread but not the original posts.
8:47 am
October 27, 2013
Offline5:31 am
April 6, 2013
Online
C$ brokerage ISA rates stable since last update four weeks ago:
| 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 |
5:55 am
February 14, 2023
Offline
TDDI very annoying in that ISA purchase limited to TD product?
6:46 am
October 27, 2013
Offline
kesa said
TDDI very annoying in that ISA purchase limited to TD product?
Some brokerages, including RBC DI and I think BMOIL, limit selection to their in-house ISA products. Annoying perhaps, but it is their call in the case of these kinds of products. The bigger travesty (which may not be of interest to members here anyway) is they also limit what Cash ETFs (none) can purchased on the TSX which Rob Carrick (I think) has raged about in the G&M.
12:06 pm
February 8, 2023
Offline
kesa said
TDDI very annoying in that ISA purchase limited to TD product?
Alternatives to TDB ISA that I use.
These are *NOT* CDIC covered.
Check out the holdings and do your own DD to see if these are suitable for you.
TD Money Market Fund Class D TDB2914. Current yield is 4.60%.
CIBC CIB238 Money Market Fund F-class Premium (over 100k). Current yield 4.95%.
CIBC Canadian T-Bill Fund CIB127. Current yield 4.25%.
No commissions charged by TDDI and no minimum holding period.
T+1 settlement.
*Not a recommendation to invest and I am not liable or responsible for your investment decisions.
Please write your comments in the forum.