Is it true that you can write custom functions in Excel with JavaScript?
Discussion
If that happens, we're all doomed.
On the flipside, when we talk about awaiting and Promises, it might sound fancy to our boss.
Yep, I fetch btc price live with custom function
You can also use the GoogleFinance function
Please share the code.
I do this in google sheets using their “app script” extension.
‘’’
function BTCPrice() {
const url = 'https://api.kraken.com/0/public/Ticker?pair=xbtusd'
const response = UrlFetchApp.fetch(url);
const json = JSON.parse(response.getContentText());
return json.result.XXBTZUSD.c[0]
}
‘’’
and then from inside the spreadsheet you can use ‘=BTCPrice()’
This is Google Apps Script, not Excel!
They also just added Python
On Google sheets, I believe yes.
Yes, and now Python for collab, comments, etc, just join Microsoft 365 Insider Program, auto integrated with Outlook and all M365 products, and runs on Cloud of course
Not sure, but you can do the opposite using `console.table()`
Yep, using https://github.com/OfficeDev/office-js
Where I work we built such complex functions, that we also had to build a “Formula builder” :) https://app.vestberry.com/documentation/excel-addin/functions/