How to Import Company Revenue, EPS and Financial Ratios in Airtable

Mar 22, 2022Rosie Threlfall

In this guide, we'll import company revenue, EPS and financial ratios from the Alpha Vantage API to Airtable. We will use the Data Fetcher Airtable extension to connect to Alpha Vantage without the need for code.

Create Stocks Table

Create a table in your base called 'Stocks'. If you've already got a table with your stock tickers/ symbols in, you can use that instead.

Change the name of the primary field to 'Symbol'. Add the stock symbols/tickers you want to import revenue data for, e.g. 'IBM', as records in this table.

stocks-output-table.png

Install Data Fetcher

Install Data Fetcher from the Airtable marketplace. After the extension launches, sign up for a free Data Fetcher account by entering a password and clicking 'Sign up for free'. If you already have a Data Fetcher account, sign in using the 'Have an account?' button at the bottom left of the box.

Group 1Data Fetcher Sign Up .png

Import Company Revenue, EPS and Financial Ratios in Airtable

On the home screen of the Data Fetcher extension, click 'Create your first request'. Requests in Data Fetcher are how you import data to or send data from your Airtable base.

click-create-your-first-request.png

On the create request screen in Data Fetcher, for Application, select 'Alpha Vantage'.

alpha-vantage-application.png

Next, you need an Alpha Vantage API key. You can sign up for one here.

get-alpha-vantage-api-key.png

Enter this key into the API Key input in Data Fetcher.

For Endpoint, select 'Company overview - company info, financial ratios, and other key metrics'.

Enter a Name for your request, e.g. 'Import Company Data'.

Import Company data from Alpha to Airtable

For Stock symbol, we want to insert a reference to our 'Stock symbol' field. First click the + button.

stock-symbol-add-button.png

Then, on the modal that opens, select 'Stocks' for Table, 'Symbol' for Field, 'Grid view' for Run for every record in view. Then click 'Confirm'.

How to Import Company data from Alpha to Airtable

Stock symbol should now contain a reference to the table.

Alpha-Stock-Symbol-close-up.png

Select the Output Table & View you want to import stock prices into.

How to Import from Alpha Vantage to Airtable

Unfortunately, Alpha Vantage's free stocks API has a rate limit of 25 requests per day. You can buy a premium Alpha Vantage plan to increase this limit.

Import Data from Alpha Vantage to Airtable

Click 'Save & Run'.

Import Company Revenue data from Alpha Vantage to Airtable

The request will run and the Response field mapping modal will open. This is where you set how the different revenue fields should map to the fields in the output table. You can search for fields by typing in the 'Find field' search bar.

In order to import company revenue, EPS and financial ratios, import the following fields:

'Revenue ttm'
Revenue TTM refers to a company's revenue over 'trailing twelve months' ie. the past twelve-month period. It is useful for determining a company's top-line growth. 

'Eps'
EPS stands for 'Earnings Per Share' and is the portion of a company’s profit that is allocated to each individual share. It is calculated by dividing the company’s net income by its total number of outstanding shares.

'Gross profit ttm'
Gross profit TTM refers to the gross profit of a company over 'Trailing Twelve Months' ie. the past twelve month period.  Gross profit means the profit a company makes after deducting all costs and expenses.

'Ebitda'
EBITDA stands for 'Earnings Before Interest, Taxes, Depreciation, and Amortization', It is a formula used as a key indicator of a company's profitability.

'Price to book ratio'
Price to book ratio is used to compare a company's current market value to its book value. It's calculated by dividing the company's stock price per share by its book value per share (BVPS).

For each field, you can either import or filter it. For an imported field, you can set whether to map it to an existing field or create a new field, as well as set the Airtable field type using the dropdown.

Click 'Save & Run'.

Alpha Vantage to Airtable Response Field Mapping

Data Fetcher will create any fields that need to be created in the output table, then run the request again for each symbol and import the company revenue, EPS and financial ratios into Airtable. You can now view your output table.

Alpha Vantage Data In Airtable

Import Company Revenue, EPS and Financial Ratios Automatically

At the moment, we have to manually run the request to import the financial data from Alpha Vantage. We can use Data Fetcher's scheduled requests feature to automatically import them every 15 minutes/ hour/ day etc.

In Data Fetcher, scroll to Schedule and click 'Upgrade'.

table-1-schedule-upgrade-button.png

A new tab will open where you can select a plan and enter your payment details to upgrade.

data fetcher upgrade pricing plans.png

Return to the Data Fetcher extension and click 'I've done this'.

table-1-schedule-ive-done-this-button.png

Under Schedule click '+ Authorize'.

Schedule Data Fetcher

The next window will prompt you to authorize which Airtable bases you want Data Fetcher to have access to.

We recommended selecting 'All current and future bases in all current and future workspaces' to save having to unauthorize bases for future use.

Click 'Grant access'.

schedule-authorize-bases.png

Schedule this request is now toggled on back in Data Fetcher.

Select how often you want the request to run, e.g. 'Every 15 mins'. Click 'Save' The request will now run on the schedule and import the financial data into Airtable automatically.

Group 11(2).png

Related Posts

Import Historical Exchange Rates in Airtable

Import Historical Exchange Rates in Airtable

Feb 20, 2022

Andy Cloke

FinanceCurrency Conversion
Import Time Series Data for Stocks in Airtable

Import Time Series Data for Stocks in Airtable

Feb 14, 2022

Andy Cloke

FinanceAlpha Vantage
How to Convert Currency in Airtable

How to Convert Currency in Airtable

Jul 29, 2021

Andy Cloke

FinanceCurrency Conversion