using googlefinance to get stock exchanges

[merlin777]

Can googlefinance() return the stock exchange for a given ticker symbol?

I track a porfolio of shares in excel and until last week I was getting share data from the yahoo API. They just pulled the plug with no warning so I'm now getting it from google finance by importing a google sheet which is populated with a table created using the googlefinance() function and published on the web.

The only item I can't get is the stock exchange for a given ticker symbol. The published info on the attributes is a bit sketchy. Does any one know if its possible?

 

[=ODIN=]

These peeps are still getting yahoo API to work: www.xlautomation.com.au/free-spreadsheets/yahoo-historical-price-extract

 

[merlin777]

I'm happy for people if they are still able to get what they need from yahoo but speaking personally, they have shown so much contempt for their users that using yahoo - for anything - will be an absolute last resort.

Also, this solution seems very complicated to me and I think i'd struggle with it. My curent Google finance solution is delightfully easy to use and I'm happier with this than I was with yahoo.