stock tracking from numbers

When will live pricing for stocks come to numbers? and when will we be able to also make spreadsheets for EU stocks?

Posted on Mar 30, 2021 2:07 AM

Reply
Question marked as Top-ranking reply

Posted on Mar 30, 2021 7:09 AM

You can already use symbols for EU stocks in Numbers. Just look for what symbols are used on Yahoo! Finance and try those in the 'My Stocks' template at File > New in your menu.


For "nearly realtime" pricing (several minutes delay) you may find it useful to set up a spreadsheet in Google Sheets using its GOOGLEFINANCE function. Then you can copy-paste the data into Numbers if you want.


SG,

4 replies
Question marked as Top-ranking reply

Mar 30, 2021 7:09 AM in response to MaxvandeWeijgaert

You can already use symbols for EU stocks in Numbers. Just look for what symbols are used on Yahoo! Finance and try those in the 'My Stocks' template at File > New in your menu.


For "nearly realtime" pricing (several minutes delay) you may find it useful to set up a spreadsheet in Google Sheets using its GOOGLEFINANCE function. Then you can copy-paste the data into Numbers if you want.


SG,

Apr 29, 2021 5:02 AM in response to MaxvandeWeijgaert

You can use the STOCK-funktion with EU stocks. I am doing this today with stocks listed in Sweden, Germany, France … etc.

But it still just updates once per day. Real-time updates would be very nice,. I agree!


And further more, lately the updating of my stocks has not worked at all. But I assume that is a glitch between YAhoo and Apple that someone is working on.

Mar 30, 2021 5:54 AM in response to Badunit

Additional: I do not know if any live price stock scripts are available and working, getting their live data for free. It is my belief that we could get the data from Yahoo if someone knows how to parse the content of a web page to extract stock prices from the Yahoo Finance web pages. The data is there. I looked up the quote for Microsoft (MSFT) and the data below is in web page (there is more but I had to cut it off to post it here, too many characters). Of course, Yahoo could change their design at any time and break any scripts.


"MSFT": {

"sourceInterval": 15,

"quoteSourceName": "Delayed Quote",

"regularMarketOpen": {

"raw": 236.59,

"fmt": "236.59"

},

"exchange": "NMS",

"regularMarketTime": {

"raw": 1617048003,

"fmt": "4:00PM EDT"

},

"fiftyTwoWeekRange": {

"raw": "150.36 - 246.13",

"fmt": "150.36 - 246.13"

},

"sharesOutstanding": {

"raw": 7560500224,

"fmt": "7.561B",

"longFmt": "7,560,500,224"

},

"regularMarketDayHigh": {

"raw": 236.8,

"fmt": "236.80"

},

"shortName": "Microsoft Corporation",

"longName": "Microsoft Corporation",

"exchangeTimezoneName": "America\u002FNew_York",

"regularMarketChange": {

"raw": -1.2399902,

"fmt": "-1.24"

},

"regularMarketPreviousClose": {

"raw": 236.48,

"fmt": "236.48"

},

"fiftyTwoWeekHighChange": {

"raw": -10.889999,

"fmt": "-10.89"

},

"exchangeTimezoneShortName": "EDT",

"fiftyTwoWeekLowChange": {

"raw": 84.880005,

"fmt": "84.88"

},

"exchangeDataDelayedBy": 0,

"regularMarketDayLow": {

"raw": 231.88,

"fmt": "231.88"

},

"priceHint": 2,

"currency": "USD",

"regularMarketPrice": {

"raw": 235.24,

"fmt": "235.24"

},

etc.

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.

stock tracking from numbers

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