# ETFs & Shares

<details>

<summary><strong>Manual User Cells</strong></summary>

• ETF & Share Details in the Watch table at the top\
• Purchase History in the Purchase History table at the bottom

</details>

## Introduction

The ETFs & Shares tab lets you monitor your investments and gain insights into their performance. At the top of the tab, you'll find the **Watch table**, which displays details of both owned and watched assets.

![The Watch Table](https://1515266990-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MSuatx32f5nztfqTHft%2F-MbzIj4Am9Q6TrZ-ddRe%2F-MbzQZRcbJ5-uFy7g4ev%2FWatchTable.png?alt=media\&token=d6c5efc0-ce61-4e8a-b7f2-63535cb71f19)

Below that is the **Purchase History table**, which lists all your buy/sell transactions. The sheet uses this data to automatically calculate your investment performance.

![Purchase History Table](https://1515266990-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MSuatx32f5nztfqTHft%2F-MbzIj4Am9Q6TrZ-ddRe%2F-MbzQaxFfqixE3Fbq6-L%2FPurchaseTable.png?alt=media\&token=f490a600-87fd-44b8-99fe-d6de9738d2f8)

## Adding a new ETF/Share to the Watch list

To track a new ETF or share (owned or just watched), fill in a new row in the Watch table from left to right. Assets priced in foreign currencies are supported.

<table><thead><tr><th width="211">Column</th><th>Explanation</th></tr></thead><tbody><tr><td>Ticker</td><td>Stock market code, including the exchange and the asset symbol (e.g., "ASX:VGS").<a href="how-to-find-an-asset-ticker">Learn how to find your asset ticker.</a></td></tr><tr><td>Fund Name (ETFs only)</td><td>Your custom label or nickname for the fund.</td></tr><tr><td>Currency</td><td>The currency in which the asset is priced.<br>For example, if you own Apple shares on a AUD-based sheet, enter "NASDAQ:AAPL" and use "USD" as the currency.<br>The Live Price will be automatically converted to AUD.</td></tr><tr><td>Target Allocation</td><td>Used to maintain your portfolio balance by assigning a percentage allocation for each asset.</td></tr><tr><td>MGT Fee (ETFs only)</td><td>Optional. Add the fund’s management fee for your own reference.</td></tr><tr><td>Location (ETFs only)</td><td>Optional. Helps visualize regional diversification in the graphs.</td></tr><tr><td>Region % (ETFs only)</td><td>Optional. Contributes to regional diversification graphs.</td></tr><tr><td>Sector</td><td>Optional. Helps show sector diversification and can isolate assets used in retirement balances.<a href="https://guide.cspersonalfinance.io/summary-tabs/retirement#using-managed-funds-and-investments-in-your-retirement-balance">Learn more here.</a></td></tr></tbody></table>

{% hint style="info" %}
Not sure about the Ticker code? Google the asset name and look for the ticker and market code.
{% endhint %}

![Finding the Ticker "NASDAQ:AAPL" via a Google Search](https://1515266990-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MSuatx32f5nztfqTHft%2F-MSvDVV7PHSNr77SxMMC%2F-MSvDzraONh652EHFAEK%2FTickerCode.png?alt=media\&token=7779cacb-6a11-462b-9aa0-ab59a94fbf92)

## Buying and Selling

Each time you buy or sell, record the transaction in the Purchase History table.

<table><thead><tr><th width="242">Column</th><th>Explanation</th></tr></thead><tbody><tr><td>Ticker</td><td>Must match the ticker used in the Watch table.</td></tr><tr><td>Purchase Date</td><td>Date of the transaction.</td></tr><tr><td>Volume</td><td>Number of units bought (positive) or sold (negative).</td></tr><tr><td>Bought Price</td><td>Price per unit at the time of transaction.</td></tr><tr><td>Brokerage</td><td>Brokerage fee. This auto-fills, but you can adjust it.</td></tr><tr><td>Sold Units (if needed)</td><td>Tracks how many units from a purchase have been sold (FIFO method). You can change this if preferred.</td></tr></tbody></table>

{% hint style="danger" %}
**Important:** Any asset you still own (positive balance) must also be listed in the Watch table so the current price can be fetched.
{% endhint %}

#### Automatic Price Lookups

<figure><img src="https://1515266990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MSuatx32f5nztfqTHft%2Fuploads%2FMfUtsKHmpyF72XYeP4nH%2FAutomaticPriceLookup.gif?alt=media&#x26;token=5427251c-85c0-412f-be30-84db89852061" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Auto price lookup is now supported for local and international holdings. A few things to note:

* The asset must be listed in the Watch table with a currency defined.
* Lookups are limited to 50 transactions at a time. After a value is fetched, it's automatically converted to a static number to free up quota.
* These are average daily prices, so they won’t match your actual order price exactly.
* Currency conversion is also averaged.
* For accurate performance or CGT estimates, it’s best to manually enter your order price if known.
* Only tickers supported by Google Finance are eligible.
  {% endhint %}

## Returning the price with 3–4 Decimal Places

[See the FAQ here.](https://guide.cspersonalfinance.io/getting-started/faqs#increase-decimal-places)

## International ETF & Share Support

Version 2 adds support for international assets, converting them to your base currency in real time. These values are included in your net worth with the latest exchange rate.

### Step 1 – Add the asset to the Watch table

![Example ETF/Share Watch Table in the UK Sheet](https://1515266990-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MSuatx32f5nztfqTHft%2F-MfRw11DyIJIvD5xuDiv%2F-MfRx9McT5FyoGPkHyax%2FETFIntWatch.png?alt=media\&token=eb89dee1-0e26-45aa-906a-ca62d9155db2)

Enter the asset’s ticker (Column A), name (Column B), and the currency it's priced in (Column C).

![Example of finding the ticker and currency for NASDAQ:TSLA](https://1515266990-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MSuatx32f5nztfqTHft%2F-MfRw11DyIJIvD5xuDiv%2F-MfRxvnyhGMe-t7_f8N0%2FTelsaExample.png?alt=media\&token=2f094039-4b35-406b-b5e1-75a212142e95)

In the example above, the Live Price column shows the local currency equivalent (e.g., $643.38 USD becomes £467.96 GBP).

### Step 2 – Record purchases for international assets

![Example ETF/Share Purchase History Table in the UK Sheet](https://1515266990-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MSuatx32f5nztfqTHft%2F-MfRw11DyIJIvD5xuDiv%2F-MfRxCLqaCim99lXGeTu%2FETFIntPurchase.png?alt=media\&token=2ec24f42-5638-4696-90b8-744371ae5723)

Record international purchases as you would local ones, except:

* The **Order Price must be entered in your local currency** at the time of purchase.

For example:\
If you bought 10 NASDAQ:TSLA shares for $250 USD and your sheet uses GBP, convert and enter £181.84 as the Order Price.

{% hint style="info" %}
Automatic price lookup support includes currency conversion (v2.14+). Same limitations as above apply:

* Must be listed in the Watch table with currency set
* 50 transaction limit (replaced with static values automatically)
* Values are estimates, based on daily averages
* Manually enter exact prices for accuracy
* Works only with tickers supported by Google Finance
  {% endhint %}

#### Backdated Currency Rates

To find historical exchange rates, use:

* [XE Currency Tables](https://www.xe.com/currencytables/)
* [X-Rates Historical](https://www.x-rates.com/historical/)
* [OFX Exchange Rates](https://www.ofx.com/en-au/forex-news/historical-exchange-rates/)

Future versions of the Sheet will support automatic conversion of past transactions.

## Adding new rows to the Watch table

Need more rows in the Watch table? Here's how:

**Step 1 –** Right-click on a row containing an existing yellow holding.

**Step 2 –** Select *Insert 1 above.*

![](https://1515266990-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MSuatx32f5nztfqTHft%2F-MSvH_z87WdOFJ7xl2D5%2F-MSvI4UJQX5fIcXeaToA%2FInsertAbove.png?alt=media\&token=37fab38d-44ec-4449-b10d-96407f1d5374)

**Step 3 –** Right-click the same row again and select **Copy**.

![](https://1515266990-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MSuatx32f5nztfqTHft%2F-MSvH_z87WdOFJ7xl2D5%2F-MSvINKCmVnnGlt7Crhw%2FCopyRow.png?alt=media\&token=726f4426-db51-45b7-8145-04533799a5e6)

**Step 4 –** Right-click the new empty row and select **Paste**.

![](https://1515266990-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MSuatx32f5nztfqTHft%2F-MSvH_z87WdOFJ7xl2D5%2F-MSvI_dToMHlpvj74OVD%2FPasteRow.png?alt=media\&token=c72cecd8-29af-4aa9-8472-8bb15fca427d)

Repeat this process to add more rows as needed. The copied formulas will carry over.