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?
When will live pricing for stocks come to numbers? and when will we be able to also make spreadsheets for EU stocks?
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,
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,
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.
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.
Could be tomorrow, could be never. You'll know when we know.
stock tracking from numbers