skip to content
  1. Home
  2. >
  3. Investment Q&A
You can view 3 more answers this month. Sign up for a free trial for unlimited access.

Investment Q&A

Not investment advice or solicitation to buy/sell securities. Do your own due diligence and/or consult an advisor.

Q: Today in a question from John he asked about spreadsheets, I too was looking but in fact Action Direct can provide the info he is looking for. Under the My Portfolio tab, click on Analyze and Rebalance, in there you can create a group of all your accounts. Once you have a Group, sector weightings and position size is one click of the mouse. I wouldnt waste my time or yours with this submission except for the fact this knowledge has been a bit of a game changer managing my portfolio - keeping sector weights and position size in line.
Read Answer Asked by Charles on February 08, 2018
Q: I would like to setup a spreadsheet to track our stocks. I would like it to be easy to update and be able to track my sector weighting’s and gains and losses. I use the Royal Bank Direct Investing to keep track of our holdings.
Are there any templates for setting this up?
We have separate accounts for 2 TFSAs, one RIF and one Cash account. Some equities are in several accounts. Should they be consolidated into one account when setting up a spreadsheet so that I can determine our sector allocations?

Your direction and suggestions would be greatly appreciated. I realized that this is more than one question. Thanks.

John
Read Answer Asked by John on February 08, 2018
Q: Hi All,
I have been receiving a pending approval status on my Investorline account, most recently on a buy order for BYL this morning. For the 5i team what is happening and should I have to wait for approval on a do it yourself platform. For 5i readers have you experienced this as well. Given the quick price movements such as this morning it is difficult to buy at the lows when this happens, can anyone recommend a platform where this does not happen.

Thank you,
Mike
Read Answer Asked by Michael on February 07, 2018
Q: I'm interested in taking a position in the forestry sector as this high flying sector is seemingly under the radar. Of the following main stocks in forestry: WEF, CFP, CAS, IFP WFT, OSB, kindly rank them in the order of which ones should have the highest growth potential in the next year or so. Thanks.
Read Answer Asked by Victor on February 05, 2018
Q: I currently hold hold the 3 stocks and would like to combine them into one. Which one of the three has the best outlook longer term (4-5 years).
Read Answer Asked by Scott on February 05, 2018
Q: Just a comment about the site www.dividendhistory.org, members should probably be reminded that any 3rd party source providing information about a particular company should be taken with a a grain of salt and verified against other sources (such as the company's website itself). For instance I noticed that the referenced site showed a whopping dividend decrease for Savaria in 2017 and knew that wasn't right so when I checked further I note that although they supposedly adjust for splits, their system apparently didn't handled the switch to monthly versus quarterly dividends very well!
Read Answer Asked by Stephen R. on January 31, 2018
Q: Hello Peter and 5i team
Would you please explain the pros and cons of converting Cdn dollars to US dollars. I recently had two bonds called and am undecided where to put it. I believe the US dollar will strengthen form here and would just sit on the cash.
Thanks for your help. New site features are great.
Read Answer Asked by Gary on January 30, 2018
Looking for more? Sign up for a FREE 14 day trial! No credit card required

We invite you to sign up for a 14 day free trial of 5i Research!
Experience all the benefits and tools we have to offer; stock research, model portfolios, Q&A with our experts, and so much more. Join a community of like-minded investors today!