I’m trying to get a stock quote script to work for me. I’m not someone that understands scripts, but I think I have it right. Although something is wrong and not sure what.
The API is from financialmodelingprep.com/developer/docs/, which I found mentioned in this forum.
When I run it I get this result:
Blockquote Updating stock prices
Updating price of aapl…
Can’t update the price of stock with no name
Can’t update the price of stock with no name
aapl’s price right now is: $undefined
Done!
Here is the script I have, with the field names changed to my field names (Symbol, Price, Price Date)
(Sorry for the way the code looks below, not sure how to paste in code)
output.markdown ("# Updating stock prices");
let table = base.getTable (“Holdings”),
records = await table.selectRecordsAsync ();
await Promise.all (
records.records.map (async record => {
let stock = record.getCellValue ("Symbol");
if (! stock) {
output.text ("Can't update the price of stock with no name");
return;
}
output.text (`Updating price of ${stock}...`);
// make request
var requestResult = await fetch (
`https://financialmodelingprep.com/api/v3/stock/real-time-price/${stock}`
).then (r => r.json ());
// print fetched data
output.markdown (`${stock}'s price right now is: **$${requestResult.price}**`)
// update record in table
return await table.updateRecordAsync (record, {
"Price": requestResult.price,
"Price Date": new Date ()
});
})
);
output.markdown ("# Done!");
