Despite the limitations stated in this article
https://help.appsheet.com/en/articles/2926968-issues-with-google-sheets-formulas
https://help.appsheet.com/en/articles/961393-spreadsheet-formulas
GOOGLEFINANCE seems to work just fine as a spreadsheet formula.
I actually had a similar experience with IMPORTRANGE in another Q&A.
So it maybe not officially supported but seems to work just fine.
(Use it at your own peril, I suppose, because it may stop working all of a sudden someday..)
The cell containing the formula is treated as read only but you can edit parameter cells from within an AppSheet form.
Another option is to use OData services if you can find the right one
https://help.appsheet.com/en/articles/3552810-using-data-from-an-odata-feed
Perhaps others with more experience have better suggestions..
LinkedIn
Twitter
