Live Stock Quotes on Numbers for PSX Stocks

Question

Level 1

1 points

Live Stock Quotes on Numbers for PSX Stocks

Hi,

I want to import live stock quotes into the Numbers table. I am an investor in Pakistan Stock Exchange (PSX) & its symbols are not available on the Numbers built function which fetches data from Yahoo Finance. Unfortunately, live quotes are not available for PSX on Yahoo Finance. Is there a way to automate this and bring live prices from the official PSX website?

I know I can copy-paste but that's tiresome when you have too many symbols to work with. I would be thankful if someone could explain the process to me with an example of one stock such as the one I am attaching here. All I want to do is to fetch the prices, nothing else.

Thanks.

MacBook Air 13″, macOS 12.1

Posted on Jul 24, 2022 2:18 PM

Reply

Answer 1

SGIII

Level 8

37,684 points

Jul 24, 2022 8:05 PM in response to emyumi

emyumi wrote:

live quotes are not available for PSX on Yahoo Finance. Is there a way to automate this and bring live prices from the official PSX website?

Automated "live" quotes are not a Numbers feature, either for PSX or for other exchanges.

Previous day closing quotes are available if reported by Yahoo! Finance.

Google Sheets and other spreadsheets can retrieve delayed intraday quotes.

You might set up a table there to retrieve quotes, and copy-paste into a Numbers table.

In general it is best not to think of Numbers (or other spreadsheet apps) as a substitute for proper portfolio management software such as your broker might provide.

SG

Reply

Live Stock Quotes on Numbers for PSX Stocks

Similar questions