Brokerage investment savings accounts | Page 16 | General comparisons | Discussion forum

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
Brokerage investment savings accounts
March 7, 2023
7:46 pm
Norman1
Member
Members
Forum Posts: 6729
Member Since:
April 6, 2013
sp_UserOfflineSmall 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. sf-smile

March 8, 2023
8:48 am
Nehpets
Ontario
Member
Members
Forum Posts: 975
Member Since:
December 20, 2016
sp_UserOfflineSmall Offline
302sp_Permalink sp_Print

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

March 8, 2023
9:41 am
AltaRed
BC Interior
Member
Members
Forum Posts: 2852
Member Since:
October 27, 2013
sp_UserOnlineSmall Online
303sp_Permalink sp_Print

+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.

March 8, 2023
11:38 am
smayer97
Member
Members
Forum Posts: 774
Member Since:
September 29, 2017
sp_UserOfflineSmall Offline
304sp_Permalink sp_Print

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?

March 8, 2023
2:59 pm
Nehpets
Ontario
Member
Members
Forum Posts: 975
Member Since:
December 20, 2016
sp_UserOfflineSmall Offline
305sp_Permalink sp_Print

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

March 8, 2023
5:51 pm
smayer97
Member
Members
Forum Posts: 774
Member Since:
September 29, 2017
sp_UserOfflineSmall Offline
306sp_Permalink sp_Print

Thanks kindly for the guidance. I'll have to investigate and give it a try. 🙂

March 8, 2023
7:50 pm
Bob
Member
Members
Forum Posts: 19
Member Since:
April 10, 2013
sp_UserOfflineSmall Offline
307sp_Permalink sp_Print

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.

March 9, 2023
1:02 am
NorthernRaven
Moderator
Moderators
Forum Posts: 606
Member Since:
August 4, 2010
sp_UserOfflineSmall Offline
308sp_Permalink sp_Print

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

March 9, 2023
1:16 am
NorthernRaven
Moderator
Moderators
Forum Posts: 606
Member Since:
August 4, 2010
sp_UserOfflineSmall 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.

March 9, 2023
4:34 am
savemoresaveoften
Member
Members
Forum Posts: 2829
Member Since:
March 30, 2017
sp_UserOfflineSmall Offline
310sp_Permalink sp_Print

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.

March 9, 2023
8:07 am
NorthernRaven
Moderator
Moderators
Forum Posts: 606
Member Since:
August 4, 2010
sp_UserOfflineSmall Offline
311sp_Permalink sp_Print

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.

March 18, 2023
8:20 am
Norman1
Member
Members
Forum Posts: 6729
Member Since:
April 6, 2013
sp_UserOfflineSmall Offline
312sp_Permalink sp_Print

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
April 4, 2023
7:24 pm
canada888
Member
Members
Forum Posts: 12
Member Since:
February 6, 2023
sp_UserOfflineSmall Offline
313sp_Permalink sp_Print

why there is no table for Brokerage investment savings accounts in USD ?

April 5, 2023
5:42 am
Doug
British Columbia, Canada
Member
Members
Forum Posts: 4211
Member Since:
December 12, 2009
sp_UserOfflineSmall Offline
314sp_Permalink sp_Print

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

April 7, 2023
8:16 am
smayer97
Member
Members
Forum Posts: 774
Member Since:
September 29, 2017
sp_UserOfflineSmall Offline
315sp_Permalink sp_Print

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.

April 7, 2023
8:47 am
AltaRed
BC Interior
Member
Members
Forum Posts: 2852
Member Since:
October 27, 2013
sp_UserOnlineSmall Online
April 15, 2023
5:31 am
Norman1
Member
Members
Forum Posts: 6729
Member Since:
April 6, 2013
sp_UserOfflineSmall Offline
317sp_Permalink sp_Print

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
April 18, 2023
5:55 am
kesa
Member
Members
Forum Posts: 195
Member Since:
February 14, 2023
sp_UserOfflineSmall Offline
318sp_Permalink sp_Print

TDDI very annoying in that ISA purchase limited to TD product?

April 18, 2023
6:46 am
AltaRed
BC Interior
Member
Members
Forum Posts: 2852
Member Since:
October 27, 2013
sp_UserOnlineSmall Online
319sp_Permalink sp_Print

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.

April 18, 2023
12:06 pm
svg1234
Member
Members
Forum Posts: 6
Member Since:
February 8, 2023
sp_UserOfflineSmall 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.