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: In response to a question on how to download market data directly into Excel, this is what I use:

=NUMBERVALUE(WEBSERVICE("finance.yahoo.com/d/quotes.csv?s=" & A2 & "&f=l1"))

In this case cell A2 contains the symbol I would like the information for (ie ALA.TO for AltaGas). The l1 looks up the last trade price. The website below shows other codes to use to lookup other information.

http://www.jarloo.com/yahoo_finance/

For example =NUMBERVALUE(WEBSERVICE("finance.yahoo.com/d/quotes.csv?s=" & A2 & "&f=j1")) will get the Market cap.

Unfortunately WEBSERVICE is a non-volatile function, meaning it doesn’t re-download the information from the web automatically. To refresh, you need to either

- Hit CTRL+ ALT + F9
- If that doesn’t work for some reason on your computer you must use VBA to refresh at opening (Application.CalculateFull) .

It is a little complicated for some, but is the only good way I have found if you want to stick with Excel and not move to Google Sheets.
Read Answer Asked by Craig on February 06, 2015
Q: just wondering if you have put a call out to those guys yet as promised?
Read Answer Asked by Josh on February 06, 2015
Q: I have already been reducing my financial weighting and doing some rebalancing - and not just because TD decided to take their own sweet time with the dividend! My current Energy sector weighting is 7.7% with the banks...well you know I'm your typical Canadian. I'm thinking on increasing the Energy weighting to roughly 10% by adding to existing positions in PEY, VET and a good oil reserve modelling company. Lately when I read the questions I get the sense you are advising against the purchase of energy companies yet rebalancing (selling the overweight to buy the underweight) seems to be a good strategy. I guess I am a little confused - should I delay rebalancing until the Energy sector is less volatile?
Thanks
Read Answer Asked by James on February 06, 2015
Q: Peter I have held this stock since I joined your group and has served me well I was however disappointed how far it in rating last year the leadership seems more focused on tv ratigs than the core buissness .I have about a 20% gain in capital on it .My question is would you sell and pick up AW ?
Kind Regards
Stan
Read Answer Asked by Stan on February 06, 2015
Q: Could please advise if you have any insight on Imperus technologies.(lab.v).There are in the hot internet gambling space and the president and board of directors just took part in of financing putting in $500,000.00 and $250,000.00 each.The people they have brought on board have an impressive track record.They also just completed a takeover of a larger private company called Diwip.They seem to be ramping up to get into the mobile space.Looks very promising.
Thank you,
Read Answer Asked by Harv on February 06, 2015
Q: Hello Peter. holding this stock for quite some time (before launch of 5i) and has done very well for me. As such it is now a 9% portfolio weight. As much as I still like it, but getting bit worried from portfolio management point. Do you think it would be prudent to reduce weight say to 5% . Your opinion, please. If you recommend selling some then please advise some 2-3 other choices with a similar characteristics - safety, income and growth. Thanks.
Read Answer Asked by RUPINDER on February 06, 2015
Q: Hi Peter,
I would like to download market data on stocks from a source for analysis. Could you please give me a source for this data preferably in excel format.
Regards
Simon
Read Answer Asked by SIMON on February 06, 2015
Q: Hello

What is the dividend yield on DOL? It pays an 8c dividend quarterly and current market price is about $60.

As per TMX money the yield is around 1.05% http://web.tmxmoney.com/quote.php?qm_symbol=DOL:TSX

I come up with a different number when I calculate it:
($0.08x4)/$60 = 0.53% dividend yield.

What am I missing?

Thank you
Read Answer Asked by Vee on February 06, 2015
Q: Hello 5i team,
In North America, a large number of companies release their quarterly earnings report after the close of the stock markets (TSX, S&P 500, Dow Jones, etc.). How is it that, immediately after the numbers are released, the shares of these companies start trading up or down depending on whether or not they beat expectations? Who is buying/selling these shares and on which stock markets? Is there any way that I, as a retail investor, can buy some at that time in order to get in before the opening of the North American markets the following morning?
Robert
Read Answer Asked by Robert on February 06, 2015
Q: Prem launched a new India fund. What do you think?

http://www.theglobeandmail.com/report-on-business/economy/prem-watsa-embraces-his-roots-with-fairfax-india-fund/article21804445/

https://finance.yahoo.com/q?s=fih-u.to

Read Answer Asked by Jeremy on February 06, 2015
Q: Thanks for your reply to my question on Elkwater. Did you mean Elkwater is (not) planning much spending in the first quarter?
Thanks.
Read Answer Asked by Steven on February 06, 2015
Q: I have been waiting patiently for the carfinco deal to close and I am wondering if it is worth waiting or if I should move on to another holding that may offer more than the approximately 5.5% upside to the closing price of $11.25? What about the special dividend that has been mentioned? I have been considering a position in CXI as an alternative. Any thoughts would be appreciated. Thanks
John
Read Answer Asked by John on February 05, 2015
Q: You answered a question a couple of weeks ago stating that this was a good defensive stock. Is there still growth in it? I am kicking myself as I lost patience with it a year ago and sold - missing out on a 25% or so gain. Lesson learned. good entry point?

Paul F.
Read Answer Asked by Paul on February 05, 2015
Q: Boston Pizza has done okay during the year that I have owned it, largely because of the dividend but I am wondering if a switch to MTY is in order. I like dividends and Boston's is certainly higher but MTY seems to be growing theirs and at the end of the day, I am looking for one that will achieve the higher overall return over the next few years. Is a switch in order?

I also own A & W and am very happy to keep it if you think that is a good combination with one of the others.

Thanks. Invaluable service.

Paul F
Read Answer Asked by Paul on February 05, 2015
Q: Hi Peter, I own CSH.UN and RLC, I would like to add to RLC , it seem the yield is higher 7.8% and the payout ratio is below 90%. could RLC be undervalued compare to CSH,LW. thanks.
Read Answer Asked by samuel on February 05, 2015
Q: I’ve held MBT for many years. The income has more than offset any paper loss, so for me it’s a hold. Based on yesterday’s results, I was wondering what you saw that resulted in all the downgrading? Seems to me that they did OK. What am I missing or is this just another case of analysts/fund managers chasing each other’s tails?

Maybe a contrarian play? Allstream sale? Foreign takeover (Verizon)?
Read Answer Asked by Dean on February 05, 2015
Q: Hi 5i Read an article in the paper today. Russ Guirling of TansCanada said that trp is looking at getting into the oil by rail business in some form or another. I was wondering if you think trp might be interested the rail portion of Canexus (cus) Thx Gerry
Read Answer Asked by Gerry on February 05, 2015
Q: May I please have your opinion on Proctor & Gamble for income with a 2-3 year timeframe. Thank-you.
Read Answer Asked by Deborah on February 05, 2015
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!