# Google Sheets Portfolio Tracker

**URL:** <https://community.trading212.com/t/google-sheets-portfolio-tracker/38009>\
**Category:** 💡 Feature suggestions & ideas\
**Created:** [January 18, 2021, 1:51pm UTC](https://community.trading212.com/t/google-sheets-portfolio-tracker/38009 "2021-01-18T13:51:25Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![trader787](https://avatars.discourse-cdn.com/v4/letter/t/e68b1a/32.png) [@trader787](https://community.trading212.com/u/trader787)\
**Post date:** [January 22, 2021, 10:59pm UTC](https://community.trading212.com/t/google-sheets-portfolio-tracker/38009/7 "2021-01-22T22:59:34Z")

</div>

regarding issue 1, a list of all stocks on T212 is here with the values you need (ticker, ISIN, exchange)

> **[t212](https://docs.google.com/spreadsheets/d/1IsZPQDBflkighVGpIQB619d1Xyos10dP0fTbbRdN1Ug/edit#gid=0)**
>
> Sheet1
> 
> ISIN,TICKER,NAME,£$,MIN QTY,EXCHANGE,TYPE
> GB0031348658,BARC,Barclays PLC,GBX,0.1,London Stock Exchange,STOCK
> GB00BH4HKS39,VOD,Vodafone Group PLC,GBX,0.1,London Stock Exchange,STOCK
> DE0005190003,BMW,Bayerische Motoren Werke...

note: this was produced by finki, about a month ago in this thread…

> [@Can I get the instrument list in an excel sheet?](https://community.trading212.com/t/can-i-get-the-instrument-list-in-an-excel-sheet/33758/3):
>
> I’ll build you a list… give me 5 minutes

you should be able to just concatenate the exchange with the ticker to get the google finance input, (eg: Map London Stock Exchange to LON, then concatenate to :NG to get LON:NG) This spreadsheet mapping will get outdated however and how to keep this up to date would be another issue…

---

_[View the full topic](https://community.trading212.com/t/google-sheets-portfolio-tracker/38009)._