Why is the Stock Data Type not pulling correct prices?

  • Thread starter Thread starter David B-R.BC
  • Start date Start date
D

David B-R.BC

Guest
I'm online using the free Excel. I converted some tickers into Stock Data Types in col B. Over in Col J, I inserted "=B2.Price" using the dropdown from the data card. I copied that celll down my column.My first ticker was SHOPIFY INC. (XNYS:SHOP) and ties in with Yahoo Finance at $86.82. My second was Cineplex Inc. (XTSE:CGX.DB.B) for the Toronto Stock Exchange which returned $103.59 when Yahoo Finance give $9.85 (the latter I am sure is correct). Can you please tell me what is happening? Thanks

Continue reading...
 
Back
Top