This page explains how to integrate the CompaniesLogo Starter API into your Excel or Google Sheets applications. The Starter logo API provides a simple way to retrieve stock market logos using ticker symbols and ISINs.
API Endpoints
Endpoint to retrieve a logo using its stock symbol:
https://companieslogo.com/api/starter/stock-symbol/{STOCK_SYMBOL}
Example response with stock symbol "AAPL":
➜ https://companieslogo.com/api/starter/stock-symbol/AAPL
The Apple logo is being returned as a 32x32 transparent PNG image.
Endpoint to retrieve a logo using its ISIN:
https://companieslogo.com/api/starter/isin/{ISIN}
Example response with the Microsoft ISIN "US5949181045":
➜ https://companieslogo.com/api/starter/isin/US5949181045
The Microsoft logo is being returned as a 32x32 transparent PNG image.
Note: If no logo is found for the provided stock symbol or ISIN, the API will return a 404 HTTP status code with an empty response. Your spreadsheet formula should handle this gracefully.
Integration into Excel
Example formula to retrieve a logo using a stock symbol in Google Sheets, assuming the stock symbol is in cell B2:=IMAGE("https://companieslogo.com/api/starter/stock-symbol/" & B2)
Example formula to retrieve a logo using a stock ISIN in Google Sheets, assuming the ISIN is in cell B2:
=IMAGE("https://companieslogo.com/api/starter/isin/" & B2)
Integration into Google Sheets
The Google Sheets integration is similar to Excel. You can use the `IMAGE` function to display logos directly in your spreadsheet.
Example formula to retrieve a logo using a stock symbol in Google Sheets, assuming the stock symbol is in cell B2:=IMAGE("https://companieslogo.com/api/starter/stock-symbol/" & B2)
Example formula to retrieve a logo using a stock ISIN in Google Sheets, assuming the ISIN is in cell B2:
=IMAGE("https://companieslogo.com/api/starter/isin/" & B2)
Pricing
This endpoint is free to use and does not require an attribution.
However its use is limited to spreadsheet applications such as Google Sheets or Excel.
If you wish to integrate the logos into a mobile or web app, please use the V1.0 Stock Market logo API
Specifications
| Specification | Description |
|---|---|
| Logo sizes | All logos are returned as 32x32 transparent PNGs |
| Coverage | All logos on CompaniesLogo.com (10,000+) |
| Attribution | Attribution is not required |
| Usage | Only allowed within spreadsheet software such as Excel or Google Sheets |
| Liability | The API is provided "as is" without any warranties, express or implied. We are not liable for any damages arising from the use of this API. |