Jump to content
Sign in to follow this  
EdInvestor

Google Sheets share value

Recommended Posts

Just started using Google Sheets. Is there a way to use the formula [ GOOGLEFINANCE(ʺJSE:MRPʺ,ʺpriceʺ) /100 ] without including "JSE" in the formula? I assume it looks at the Dow Jones for the Ticker and hence does not find MRP unless I include "JSE".

Share this post


Link to post
Share on other sites

Google finance uses their own "exchange code". On Google "JSE" means the Johannesburg Stock Exchange. The same thing nn Bloomberg, for example, would be SJ.

 

https://www.google.com/search?q=jse:+mrp

https://www.bloomberg.com/quote/MRP:SJ

 

To get a share prices you need to know 1) where it is trading (JSE, Dow Jones, Nasdaq) and 2) the ticker on that exchange for it. Example: if I ask you Naspers' share price how would you know if I am talking about the JSE or A2X price? Or Lonmin who is trading on the JSE and the LSE:

 

https://www.google.com/search?q=jse:+lon

https://www.google.com/search?q=lse:+lmi

 

 

  • Like 1

IQ Test

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...