Is there a way to retrieve stock quotes using Airtable?

[Stan_Z]

Is it possible to enter a stock symbol such as AAPL and get the price update as is offered in other spreadsheet programs?

Thanks

[Michael_Berman]

Hi Stan,
You can achieve this using ifttt.com stocks triggers and airtable recording.
Let me know if you would like help in setting this up.
Michael

[Stan_Z]

Hi Michael,

I have read about ifttt but have not tried using it. I searched on google and could not find anything about Airtable using ifttt to retrieve stock prices. If you could offer some hints as to how to do this I would appreciate it.
I would basically like to enter a list of stock symbols and pull their price from Yahoo or Google.

Thanks,
Stan

[Michael_Berman]

Ok - I tried to get it to work and it appears not to have that functionality at the moment - I have requested it and if I get a response I will let you know.

[Stan_Z]

OK Michael, thanks for trying,

Stan

[Moe]

We made this tool. It allows you to enter a list of stock symbols in Airtable and it will pull their prices. It can be scheduled to run regularly too.

miniExtensions

Import Stock Prices in Bulk into Airtable - miniExtensions

A tool to import stock prices in bulk into Airtable with a single click! Works with all major markets. Supports scheduling & webhooks.

[ScottWorld]

Moe:

We made this tool . It allows you to enter a list of stock symbols in Airtable and it will pull their prices. It can be scheduled to run regularly too.

Hi @Moe, it says in your video that this tool makes an API call to Alpha Vantage once per minute, and that Alpha Vantage only allows a maximum of 500 API requests per day on their free plan. This is true, as I saw on their website here. But if your tool is making an API call once per minute, then after approximately 8.3 hours of running this tool in one day, the free 500 API limit for the day will be reached. So it seems like everyone will need to pay for at least the cheapest pricing plan for Alpha Vantage, which is currently $30 per month. Am I understanding this correctly?

[Moe]

The API limit would only be an issue if you have more than 500 stock and you need to update all stock prices every day. So it depends on how many records (stock symbols) you have. Obviously, this tool is not ideal for updating stock prices in real-time throughout the day (Airtable is not the right platform for this anyway).

[ScottWorld]

Thanks. Can we limit this tool to not update every 1 minute, but perhaps once an hour?

[Moe]

We don’t support that feature currently. Maybe in the future.