# Model Syncing

<figure><img src="/files/6sRMbVneH4A5XUgyuDDu" alt=""><figcaption><p>Countercyclical · Search (Sync to Spreadsheet)</p></figcaption></figure>

{% hint style="info" %}
Microsoft Excel support for this feature is currently in progress!
{% endhint %}

## What is Model Syncing?

**Model Syncing** allows users to seamlessly sync fundamental financial data from Countercyclical to [Google Sheets](https://workspace.google.com/products/sheets/) for extensive financial modeling capabilities.&#x20;

This feature is designed for institutional investors, analysts, and researchers who need to work with historical financial data across multiple companies in a spreadsheet environment they're already familiar with.

With **Model Syncing**, you can:

* Select multiple **companies** at once to sync with your spreadsheet provider.
* Select from a variety of financial insights & statements to sync, including:
  * **Balance Sheet**
  * **Income Statement**
  * **Cash Flows**
  * **Revenue Segments** (Product Line and Geography)
  * **Key Performance Metrics**
  * And more.
* Choose a **date range** of up to **30 years** of historical data.
* Simultaneously create models in Google Sheets.

{% hint style="info" %}
Each new sync will create a separate spreadsheet for each company that's synced, even if you've made a sync in the past.

Users can sync up to **3** companies at once.

This is to establish data boundaries in the event you want to update your modify your sheet after the sync.
{% endhint %}

### Requirements

{% hint style="info" %}
You can link your Google Drive account (for Google Sheets) under the Connected Accounts tab in your Account Settings ([Settings > Account > General > Connected Accounts](https://dashboard.countercyclical.io/settings/account/general/connections))
{% endhint %}

* **Google Sheets** requires a Google account with **Google Drive access**.

### Using Model Syncing

**Model Syncing** is available on **Search** after you've queried for companies and selected, at least, one result:

<figure><img src="/files/aAqaCnx7rupoHjEHvUPw" alt=""><figcaption></figcaption></figure>

### Steps to Sync Data

After selecting at least one company in the Search result list, click on the "Sync to..." button to show the Model Syncing feature:

* **Choose Tabs**
  * Select which financial statements & insights you’d like to include in your model.
* **Pick a Date Range**
  * Select a start and end date for the historical data (up to 30 years).
* **Choose Spreadsheet Services**
  * Select **Google Sheets**
  * If selecting Google Sheets, make sure you've connected your Google Drive account to Countercyclical.

{% hint style="info" %}
Syncing to Google Sheets requires that you have a Connected Account in your settings.&#x20;

You can connect your [Google Drive](https://workspace.google.com/products/drive/) in your Account Settings ([Settings > Account > General > Connected Accounts](https://dashboard.countercyclical.io/settings/account/general/connections))
{% endhint %}

* **Start Syncing**
  * Click **"Sync"** to begin syncing.
  * Countercyclical will create a new spreadsheet in the provider(s) you selected.
* **Review and Use Data**
  * Once synced, your spreadsheet will include separate **tabs** for each report you selected iin Countercyclical.

{% hint style="warning" %}
If you notice any data inaccuracies, please reach out to us immediately at <support@countercyclical.io>&#x20;
{% endhint %}

***

## FAQ

<details>

<summary>What type of companies do you support for this feature?</summary>

We support all of the companies you can search for & find on Countercyclical for fundamental model syncing!

</details>

<details>

<summary>What if a company's financials update after I have initiated a sync?</summary>

We capture the data as-is when you initiate the sync between Countercyclical and your spreadsheet provider of choice.&#x20;

In the event a company updates their financials, you may need to create a new sync (with a new model) to capture theses changes effectively.

</details>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.countercyclical.io/fundamentals/search/model-syncing.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
