I have this Home Office edition of MS Excel for Mac and I was playing with Google Sheets earlier, chiefly with the GOOGLEFINANCE function, when it occurred to me that Apple Numbers might have a similar function. And indeed it does, but Numbers is kind of clumsy and I’ve never really managed to get used to it.
Then, it occurred to me that Apple Numbers is probably tapping into the Apple Stocks financial information. So, presumably there is an API there in the OS somewhere and they talk to each other and the Numbers spreadsheet simply observes some process behind the scenes.
It stands to reason, therefore, that if my suspicion is correct, one could get MS Excel to observe the same process or use the same API and fetch the same information.
Has anyone tried that yet? Can we use some other means of obtaining data, say, an automator job, or a macro, or something along those lines? Can it be done or did Apple put some obstacles in place to make it non-trivial?
Thanks!
