> ## Documentation Index
> Fetch the complete documentation index at: https://artemis.ai/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Token Unlocks

> Pulling data programmatically from TokenUnlocks directly to Excel/GSheets

Artemis Sheets allow you to pull token unlock data programmatically from [TokenUnlocks](https://token.unlocks.app/) directly into Excel / GSheets.

<img src="https://mintcdn.com/artemis-db73460d/u2ylj6ovlda4p-qx/images/Screenshot%202024-08-11%20at%204.27.19%E2%80%AFPM.png?fit=max&auto=format&n=u2ylj6ovlda4p-qx&q=85&s=d2bb0ef1b04960232fe41829ff9098e1" alt="Example TokenUnlocks Chart - Sui Unlocks" width="2092" height="1462" data-path="images/Screenshot 2024-08-11 at 4.27.19 PM.png" />

<img src="https://mintcdn.com/artemis-db73460d/u2ylj6ovlda4p-qx/images/Screenshot%202024-08-11%20at%204.31.00%E2%80%AFPM.png?fit=max&auto=format&n=u2ylj6ovlda4p-qx&q=85&s=918587d8c69b53322bd5cf6b6498ce28" alt="Sui unlocks data pulled in Excel" width="563" data-path="images/Screenshot 2024-08-11 at 4.31.00 PM.png" />

**Note:** The data is provided to us by the TokenUnlocks API and aggregated weekly. We smooth it out to daily granularity to better meet the expectations of Artemis Sheets users.

## 1. Setup

## Google Sheets

1. If you haven't already, sign up for a [TokenUnlocks API plan](https://token.unlocks.app/profile) to receive an API key
2. Once you have an API plan you can view your API key in [your profile page](https://token.unlocks.app/profile#my-api-key)

<img src="https://mintcdn.com/artemis-db73460d/u2ylj6ovlda4p-qx/images/Screenshot%202024-08-11%20at%204.39.42%E2%80%AFPM.png?fit=max&auto=format&n=u2ylj6ovlda4p-qx&q=85&s=4d3da768a01a8185e3ceaad78cf3cf14" alt="" width="3024" height="1820" data-path="images/Screenshot 2024-08-11 at 4.39.42 PM.png" />

3. Copy the key and head over to your Google Sheets application with Artemis Sheets installed - installation instructions [here](/artemis-sheets/installation-and-usage). Then:

<img src="https://mintcdn.com/artemis-db73460d/u2ylj6ovlda4p-qx/images/Screenshot%202024-08-11%20at%204.56.17%E2%80%AFPM.png?fit=max&auto=format&n=u2ylj6ovlda4p-qx&q=85&s=edeb170a872f864371313bb731a468d7" alt="" width="3024" height="1882" data-path="images/Screenshot 2024-08-11 at 4.56.17 PM.png" />

<img src="https://mintcdn.com/artemis-db73460d/u2ylj6ovlda4p-qx/images/Screenshot%202024-08-11%20at%204.58.41%E2%80%AFPM%20(1).png?fit=max&auto=format&n=u2ylj6ovlda4p-qx&q=85&s=f718c63e9cf4b2eee42b33e87eeba878" alt="" width="3012" height="1882" data-path="images/Screenshot 2024-08-11 at 4.58.41 PM (1).png" />

4. Done! You should now see your masked TokenUnlocks API key listed under your email address.

## Excel (Windows)

1. If you haven't already, sign up for a [TokenUnlocks API plan](https://token.unlocks.app/profile) to receive an API key
2. Once you have an API plan you can view your API key in [your profile page](https://token.unlocks.app/profile#my-api-key)

<img src="https://mintcdn.com/artemis-db73460d/u2ylj6ovlda4p-qx/images/Screenshot%202024-08-11%20at%204.39.42%E2%80%AFPM.png?fit=max&auto=format&n=u2ylj6ovlda4p-qx&q=85&s=4d3da768a01a8185e3ceaad78cf3cf14" alt="" width="3024" height="1820" data-path="images/Screenshot 2024-08-11 at 4.39.42 PM.png" />

3. Copy the key and head over to your Excel application with Artemis Sheets installed - installation instructions [here](/artemis-sheets/installation-and-usage) - and click on the "Artemis Sheets" menu bar item. Then:

<img src="https://mintcdn.com/artemis-db73460d/u2ylj6ovlda4p-qx/images/Screenshot%202024-08-11%20at%204.44.00%E2%80%AFPM.png?fit=max&auto=format&n=u2ylj6ovlda4p-qx&q=85&s=c554b4a5adf2bec0c3adf0fc7195ddd2" alt="" width="3020" height="1886" data-path="images/Screenshot 2024-08-11 at 4.44.00 PM.png" />

<img src="https://mintcdn.com/artemis-db73460d/u2ylj6ovlda4p-qx/images/Screenshot%202024-08-11%20at%204.46.48%E2%80%AFPM.png?fit=max&auto=format&n=u2ylj6ovlda4p-qx&q=85&s=0d108b741938481c465c4add62109903" alt="" width="3022" height="1886" data-path="images/Screenshot 2024-08-11 at 4.46.48 PM.png" />

4. Done! You should now see your masked TokenUnlocks API key listed under your email address.

## 2. Usage

Sample formula to retrieve SUI unlocks data from Aug 8th 2024, to Dec 31st, 2025:

`=ART("SUI", "TU_UNLOCKS_NATIVE", "2024-08-11", "2025-12-31", "Asc", "True")`

Follows the structure:

`=ART(Symbol, Metric,  StartDate, EndDate, OrderDirection, ShowDates)`

**Metrics Available:**

* `TU_UNLOCKS_NATIVE`: Unlocked amount expressed in the token's native units.
* `TU_UNLOCKS_USD`: Unlocked amount expressed in US dollars.
  * Forward looking USD unlock values use the token's price at token genesis.

Note: TokenUnlocks supports 1 year of historical data and 2 years forward looking data. Reach out to the TokenUnlocks team if you need additional data/support.

You may also use the token's Coingecko ID instead of its symbol.