Data source for stock exchange information.

There is an opportunity to get data on prices of securities - shares in spreadsheets. I have a problem with determining the prices of some securities from the Moscow stock exchange. I cannot find the correct ticker. Please tell me who is the provider of spreadsheet data. Maybe I can find the correct ticker from the data provider?

Posted on Dec 14, 2020 12:32 AM

Similar questions

SPB Exchange prices for shares in Numbers How to enter the company's ticker into the function arguments to see prices for shares from the St. Petersburg stock exchange? For example, for the Moscow Exchange I enter "SBER.ME" "TCS.SPBE" - error
487 2
Can I request London Stock Market stocks attributes in Numbers? (or it is only working with US stocks?) I just want to know if I can get stock market info into Numbers from UK or Canada for example
490 1
How to look up which ticker symbol Numbers uses for a preferred stock? I use the live stock quote feature in Numbers to track a portfolio of stock holdings. But sometimes a stock trades under different ticker symbols on different services. For instance, preferred shares and shares on foreign exchanges are listed under different tickers depending on whether you're looking at Yahoo Finance or TDAmeritrade....or Numbers. Most of the time in these cases I keep guessing until I get the ticker symbol correct and Numbers recognizes it. Is there a way to do a symbol lookup in Numbers? Or, does anyone know what service Apple uses to provide the stock quotes, i.e. Yahoo or Google or Bloomberg etc? Specifically, right now I cannot figure out how to make Numbers recognize EQC preferred shares, which trade under EQC-D on TDAmeritrade and EQC-PD on Yahoo. Neither of those are recognized by Numbers.
1437 2

1 reply

SGIII

Level 8

37,920 points

Dec 14, 2020 2:16 AM in response to inGENEer83

The data comes from Yahoo! Finance. So go to their site and see what symbol they use for a security on the Moscow exchange. That should work in the STOCK and STOCKH functions.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Data source for stock exchange information.

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up