Portfolio Sheet


Symbols

When using Source 1 in sheet use the following formats which can be found through Google Finance.

United States

New York Stock Exchange: Add NYSE: to start of symbol. (Optional)
Nasdaq Stock Exchange: Add NASDAQ: to start of symbol. (Optional)
NYSE Markets: Add NYSEMKT: to start of symbol.
Nasdaq OTC BB: Add OTCBB: to start of symbol.
Arca Stock Exchange: Add NYSEARCA: to start of symbol.
OTC Markets: Add OTCMKTS: to start of symbol.

Amsterdam

Euronet Amsterdam: Add AMS: to start of symbol.

Australia

Australian Stock Exchange: Add ASX: to start of symbol.

Belgium

Brussels Stock Exchange: Add EBR: to start of symbol.

Brazil

BM&F Bovespa: Add BVMV: to start of symbol.

Canada

Canadian Securities Exchange: Add CNSX: to start of symbol.
Toronto Stock Exchange: Add TSE: to start of symbol.
TSX Venture Exchange: Add TSE: to start of symbol.

China

Hong Kong Stock Exchange: Add HKG: to start of symbol.
Shanghai Stock Exchange: Add SHA: to start of symbol.
Shenzhen Stock Exchange: Add SHE: to start of symbol.

Denmark

Copenhagen Stock Exchange: Add CPH: to start of symbol.

Finland

Helsinki Stock Exchange: Add HEL: to start of symbol.

France

Paris Stock Exchange: Add EPA: to start of symbol.

Germany

Börse Frankfurt: Add FRA: to start of symbol.

Iceland

Iceland Stock Exchange: Add ICE: to start of symbol.

India

Bombay Stock Exchange: Add BOM: to start of symbol.
National Stock Exchange of India: Add NSE: to start of symbol.

Ireland

Irish Stock Exchange: Add IRE: to start of symbol.

Israel

Tel Aviv Stock Exchange: Add TLV: to start of symbol.

Italy

Borsa Italiana: Add BIT: to start of symbol.

Japan

Tokyo Stock Exchange: Add TYO: to start of symbol.

Mexico

Mexican Bolsa: Add BMV: to start of symbol.

Portugal

Euronet Libson: Add ELI: to start of symbol.

Russia

Moscow Exchange: Add MCX: to start of symbol.

Singapore

Singapore Exchange Limited: Add SGX: to start of symbol.

Spain

Madrid Stock Exchange: Add BME: to start of symbol.

Sweden

Stockholm Stock Exchange: Add STO: to start of symbol.

Switzerland

SIX Swiss Exchange: Add VTX: to start of symbol.

Taiwan

Taiwan Stock Exchange: Add TPE: to start of symbol.

United Kingdom

London Stock Exchange: Add LON: to start of symbol.
X
We use cookies to understand how you use our site and to improve your experience. By continuing to use our site, you accept our cookie policy, privacy policy and terms of service. Learn More.
Ok, got it!