Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: Live stock data feed 2017

Hello Apple,

Taking the first step to develop a live or delayed USA stock data feed to power a Numbers spreadsheet analysis. Since Yahoo and Google appear un-responsive that way is now blocked. And 3rd party businesses of subscription fees frankly is bad and invasive.


Does any one have a solution or freelancer wish to bid a solution?


All the best,

MacBook Pro (Retina, 13-inch,Early 2015), iOS 11.0.3, Numbers Stock Data Analysis

Posted on

Reply

Page content loaded

Nov 18, 2017 4:13 AM in response to SeeMeRow In response to SeeMeRow

"Live" or intraday quotes are no longer available via the STOCK() and CURRENCY() functions. However previous day closing prices still work. I find these adequate for most spreadsheet analysis. If you don't find that sufficient, then you can give feedback to Apple via Numbers > Provide Numbers Feedback in your menu. (We're fellow users here in this forum).


SG

Nov 18, 2017 4:13 AM

Reply Helpful

Nov 21, 2017 4:14 AM in response to SGIII In response to SGIII

Hello Apple, Do not really need your help SG. Sorry for the confusion. I was notifying you of a Work In Progress to get Real Time Data for Apple Numbers! The correspondence thus far includes two data suppliers:


TDA only offers RTD for spreadsheets: RTD thinkorswim supports the RealTimeData (RTD) functions in Excel in order to allow you to do your own custom... (COM) Automation server to retrieve data from thinkorswim in real time. To use RTD, bring up a watchlist on the Quotes sub-tab under the... click on the Printer icon in the top right, and choose "Export to Excel". Because RTD is a function in Excel, you can take full advantage of the power ...


http://tlc.thinkorswim.com/center/release/rel-04-26-2014.html



MY REPLY:

RTD is not compatible with OS X; but OS X is a

major operating system. What are your plans to

write an API which will interface with tens of

millions of users of OS X? OS X has capacity

via the functions STOCK() and CURRENCY().


Cheers.

Nov 21, 2017 4:14 AM

Reply Helpful

Nov 21, 2017 4:18 AM in response to SeeMeRow In response to SeeMeRow

Hello Apple, Well one reply doesn't look promising however another was much more friendly:


Thank you for the reply. I can understand your frustrations but I'm just sharing the facts.

When thinkorswim was developed the coding was based off of Oracle database and not OS X. Unfortunately, this limits some of the capabilities of thinkorswim on a Mac.

We currently have no plans to implement the feature on OS X that I'm aware of.

You may reach out to tech support, they may be able to provide you with additional information?

Technical support is available at 866-839-1100 option 3.

Nov 21, 2017 4:18 AM

Reply Helpful

Nov 21, 2017 6:44 AM in response to SeeMeRow In response to SeeMeRow

SeeMeRow wrote:


Hello Apple, Do not really need your help SG. Sorry for the confusion.


I'm confused now too. This is a user-to-user forum.


Anyway, since you "don't really need my help" I'll just wish you luck with your project.🙂


SG

Nov 21, 2017 6:44 AM

Reply Helpful
User profile for user: SeeMeRow

Question: Live stock data feed 2017