Stock /investment auto imports

[matt coxon]

Hi everyone , is there a way to import stock and fund prices directly into tapforms. I currently do this with google sheets mostly using the importhtml function. But would really like to transfer to tap fit for it .I’ve had a look through the forums but can’t find similar
Thanks
All
Matt

[Daniel Leu]

You mean to get the current stock price? There are many APIs out there. Here is a free one for low volume requests:

const APIKEY = "your-api-key";
let symbol = 'ibm';
let url = 'https://www.alphavantage.co/query?function=GLOBAL_QUOTE&symbol='+symbol+'&apikey='+APIKEY;
var d = Utils.getJsonFromUrl(url)
console.log(JSON.stringify(d, null, 3));

You can get your own API key from https://www.alphavantage.co/support/#api-key

[matt coxon]

hi Daniel, great, thank you I’ll try it out later

much appreciated
Matt

[matt coxon]

Thanks again , it worked

[Daniel Leu]

Great! Just watch out for the limits that the free API imposes: max 500 requests per day, 5 per minute!

[Steve Romano]

How does one enter the results into a record with files of the same name?

[Brendan]

Hi Steve,

Are you referring to the topic of this thread about fetching stock quotes from a web service?

Could you please elaborate a bit more about what you mean and what you’re trying to achieve with regards to this?

Thanks,

Brendan

[Steve Romano]

I’d like to populate a record with the results of the API.

Running the API provides this via console.log

{

         “Global Quote”: {

                  “09. change”: “0.6400”,

                  “10. change percent”: “0.3491%”,

                  “01. symbol”: “AAPL”,

                  “05. price”: “183.9500”,

                  “06. volume”: “56522724”,

                  “04. low”: “182.0200”,

                  “02. open”: “183.3700”,

                  “07. latest trading day”: “2023-06-14”,

                  “03. high”: “184.3900”,

                  “08. previous close”: “183.3100”

         }

}

[Daniel Leu]

The result is stored in the variable d. So you can take this and store the values in their respective fields.

record.setFieldValue(symbol_field_id, d["Global Quote"]["01. symbol"]);
...
document.saveAllChanges();

Most likely you want to create a new record where you save all these information so you can do some analysis over time.

The JavaScript API documentation is here: https://www.tapforms.com/help-mac/5.3/en/topic/javascript-api

 

 

[Steve Romano]

Brilliant!. Thank you it works…But the form doesn’t update.  I have to close the database/document and reopen to see the results.  I am executing the operation with form level script and I am using the “document.saveAllChange();” command but it doesn’t show results until I close and reopen.

Thoughts?

Thanks again!

[Daniel Leu]

Great! Sometimes you have to click on the Recalculate formulas button for changes to become visible ☹️

[Author]

Posts