Airtable revenue6/2/2023 It's calculated by dividing the company's stock price per share by its book value per share (BVPS).įor each field, you can either import or filter it. Price to book ratio is used to compare a company's current market value to its book value. Gross profit means the profit a company makes after deducting all costs and expenses.ĮBITDA stands for 'Earnings Before Interest, Taxes, Depreciation, and Amortization', It is a formula used as a key indicator of a company's profitability. Gross profit TTM refers to the gross profit of a company over 'Trailing Twelve Months' ie. It is calculated by dividing the company’s net income by its total number of outstanding shares. It is useful for determining a company's top-line growth.ĮPS stands for 'Earnings Per Share' and is the portion of a company’s profit that is allocated to each individual share. Revenue TTM refers to a company's revenue over 'trailing twelve months' ie. In order to import company revenue, EPS and financial ratios, import the following fields: You can search for fields by typing in the 'Find field' search bar. This is where you set how the different revenue fields should map to the fields in the output table. The request will run and the Response field mapping modal will open. You can buy a premium Alpha Vantage plan to increase this limit. Then scroll down to Rate Limit (requests per minute) and enter '5'. Click 'Advanced settings' to open the advanced settings. Select the Output Table & View you want to import stock prices into.Īlpha Vantage's free stocks API has a rate limit of 5 per minute, so we need to make sure we do not exceed this. Stock symbol should now contain a reference to the table. Then, on the modal that opens, select 'Stocks' for Table, 'Symbol' for Field, 'Grid view' for Run for every record in view. 'Import Company Data'.įor Stock symbol, we want to insert a reference to our 'Stock symbol' field. You can sign up for one here.Įnter this key into the API Key input in Data Fetcher.įor Endpoint, select 'Company overview - company info, financial ratios, and other key metrics'.Įnter a Name for your request, e.g. On the create request screen in Data Fetcher, for Application, select 'Alpha Vantage'. Requests in Data Fetcher are how you import data to or send data from your Airtable base. On the home screen of the Data Fetcher extension, click 'Create your first request'. Import Company Revenue, EPS and Financial Ratios in Airtable If you already have a Data Fetcher account, sign in using the 'Have an account?' button at the bottom left of the box. After the extension launches, sign up for a free Data Fetcher account by entering a password and clicking 'Sign up for free'. Install Data Fetcher from the Airtable marketplace. Add the stock symbols/tickers you want to import revenue data for, e.g. If you've already got a table with your stock tickers/ symbols in, you can use that instead.Ĭhange the name of the primary field to 'Symbol'. Create Stocks TableĬreate a table in your base called 'Stocks'. We will use the Data Fetcher Airtable extension to connect to Alpha Vantage without the need for code. In this guide, we'll import company revenue, EPS and financial ratios from the Alpha Vantage API to Airtable.
0 Comments
Leave a Reply. |