Office 365 Stock Price Automation

Hi all I just spotted this - thought I'd let everyone know as it seems it will be damn helpful once rolled out totally!

https://support.office.com/en-us/art...0-623cf07fbc54

Quote:

Originally Posted by dabsman

Hi all I just spotted this - thought I'd let everyone know as it seems it will be damn helpful once rolled out totally!

https://support.office.com/en-us/art...0-623cf07fbc54

Thanks, thats going to be super useful.. at least it will if the ASX and NZX will be covered

Supported Exchanges and Delay Times

Short Form Exchange Time Zone Time Zone Delta with GMT Delay (in Minutes)

Australia Australian Securities Exchange Limited AUS Eastern Standard Time AEST 10 20

Vienna Wiener Boerse AG Central European Time CET 1 15

Brussels Euronext Brussels Central European Time CET 1 15

Canada Canadian National Stock Exchange Eastern Standard Time EST -5 15

Toronto Toronto Stock Exchange Eastern Standard Time EST -5 15

Chile Santiago Stock Exchange Chile Standard Time CLT -4 20

Shenzhen Shenzhen Stock Exchange China Standard Time CST 8 15

Copenhagen OMX Nordic Exchange Copenhagen A/S Central European Time CET 1 15

Helsinki OMX Nordic Exchange Helsinki OY Eastern European Time EET 2 15

Paris Euronext Paris Central European Time CET 1 15

Germany Deutsche Boerse AG Central European Time CET 1 15

Xetra Xetra Central European Time CET 1 15

Athens Athens Exchange S.A. Cash Market Eastern European Time EET 2 15

Hong Kong Stock Exchange of Hong Kong Ltd Hong Kong Time HKT 8 15

Bombay Bombay Stock Exchange India Standard Time IST 5.5 15

NSE National Stock Exchange of India India Standard Time IST 5.5 15

Ireland Irish Stock Exchange - Main Securities Market Greenwich Mean Time GMT 15

Milan Borsa Italiana Central European Time CET 1 15

OTC Markets Group OTCM Eastern Standard Time EST -5 15

Kuala Lumpur Bursa Malaysia Malaysia Time MYT 8 15

Mexico Mexico Stock Exchange Central Standard Time (North America) CST -6 20

Amsterdam Euronext Amsterdam Central European Time CET 1 15

New Zealand New Zealand Stock Exchange New Zealand Standard Time NZST 12 20

Oslo Oslo Bors Asa Central Europe Time CET 1 15

Philippines Philippines Stock Exchange Philippine Standard Time PST 8 15

Lisbon Euronext Lisbon Greenwich Mean Time GMT 15

Bucharest Bucharest Stock Exchange Eastern European Time EET 2 15

MICEX MICEX Moscow Time MSK 4 15

Johannesburg JSE Securities Exchange South African Standard Time SAST 2 30

Madrid Bolsas y Mercados Españoles Central European Time CET 1 15

Stockholm OMX Stockholm Central European Time CET 1 15

Swiss Swiss Exchange Central European Time CET 1 15

Taiwan Taiwan Stock Exchange China Standard Time TST 8 20

London London Stock Exchange Greenwich Mean Time GMT 15

Amex AMEX Eastern Standard Time EST -5 15

NASDAQ NASDAQ Eastern Standard Time EST -5 15

NYSE New York Stock Exchange Eastern Standard Time EST -5 15

Moscow Moscow Exchange Moscow Time MSK 4 15

TSX Venture TSX Venture Exchange Eastern Standard Time EST -5 15

NYSE ARCA NYSE ARCA Eastern Standard Time EST -5 15

Sao Paulo BOVESPA Brasilia Time BRT -3 15

OTCBB OTCBB Eastern Standard Time EST -5 15

BATS Cboe BZX Exchange Eastern Standard Time EST -5 Real-time

NASDAQ Indices NASDAQ OMX Global Index Data Service Eastern Standard Time EST -5 Real-time

Dow Jones Indices Dow Jones Indices Eastern Standard Time EST -5 Real-time

S&P Indices S&P Indices Eastern Standard Time EST -5 15

Warsaw Warsaw Stock Exchange Central European Time CET 1 15

Istanbul Istanbul Stock Exchange Eastern European Time EET 2 End of Day

Jakarta Indonesia Stock Exchange Western Indonesian Time WIB 7 End of Day

Argentina Merval (Buenos Aires Stock Exchange) Argentina Time ART -3 15

Ho Chi Minh Ho Chi Minh Securities Vietnam Stock Exchange Indochina Time ICT 7 End of Day

Lithuania Nasdaq OMX Vilnius Eastern European Time EET 2 End of Day

Latvia Nasdaq OMX Riga Eastern European Time EET 2 End of Day

Estonia Nasdaq OMX Tallinn Eastern European Time EET 2 End of Day

United Arab Emirates Abu Dhabi Securities Market Arabian Standard Time GST 4 End of Day

United Arab Emirates Dubai Financial Market Arabian Standard Time GST 4 End of Day

Egypt Cairo & Alexandria Stock Exchange Egypt Standard Time EET 2 End of Day

Columbia Bolsa de Valores de Colombia Colombia Time COT -5 End of Day

Venezuela Bolsa de Valores de Caracas Venezuela Time VET -4.5 End of Day

Peru Bolsa de Valores de Lima Peru Time PET -5 End of Day

Comprehensive/Combined Disclaimer
Equities, market indexes, and mutual funds
© [2018] Morningstar, Inc. All Rights Reserved. The information contained herein: is (1) proprietary to Morningstar and/or its content providers; (2) may not be copied for distribution; and (3) is not warranted to be accurate, complete or timely. Neither Morningstar nor its content providers are responsible for any damages or losses arising from any use of this information. Past performance is no guarantee of future results.
Real-Time & Delayed data (includes prices and currencies)
Prices are real-time for all trades executed on Cboe BZX exchange. Prices are delayed for all trades executed on other exchanges as per the above table. 52-week high and low values are calculated from close price data.

Short Form	Exchange	Time Zone	Time Zone	Delta with GMT	Delay (in Minutes)
Australia	Australian Securities Exchange Limited	AUS Eastern Standard Time	AEST	10	20
Vienna	Wiener Boerse AG	Central European Time	CET	1	15
Brussels	Euronext Brussels	Central European Time	CET	1	15
Canada	Canadian National Stock Exchange	Eastern Standard Time	EST	-5	15
Toronto	Toronto Stock Exchange	Eastern Standard Time	EST	-5	15
Chile	Santiago Stock Exchange	Chile Standard Time	CLT	-4	20
Shenzhen	Shenzhen Stock Exchange	China Standard Time	CST	8	15
Copenhagen	OMX Nordic Exchange Copenhagen A/S	Central European Time	CET	1	15
Helsinki	OMX Nordic Exchange Helsinki OY	Eastern European Time	EET	2	15
Paris	Euronext Paris	Central European Time	CET	1	15
Germany	Deutsche Boerse AG	Central European Time	CET	1	15
Xetra	Xetra	Central European Time	CET	1	15
Athens	Athens Exchange S.A. Cash Market	Eastern European Time	EET	2	15
Hong Kong	Stock Exchange of Hong Kong Ltd	Hong Kong Time	HKT	8	15
Bombay	Bombay Stock Exchange	India Standard Time	IST	5.5	15
NSE	National Stock Exchange of India	India Standard Time	IST	5.5	15
Ireland	Irish Stock Exchange - Main Securities Market	Greenwich Mean Time	GMT		15
Milan	Borsa Italiana	Central European Time	CET	1	15
OTC Markets Group	OTCM	Eastern Standard Time	EST	-5	15
Kuala Lumpur	Bursa Malaysia	Malaysia Time	MYT	8	15
Mexico	Mexico Stock Exchange	Central Standard Time (North America)	CST	-6	20
Amsterdam	Euronext Amsterdam	Central European Time	CET	1	15
New Zealand	New Zealand Stock Exchange	New Zealand Standard Time	NZST	12	20
Oslo	Oslo Bors Asa	Central Europe Time	CET	1	15
Philippines	Philippines Stock Exchange	Philippine Standard Time	PST	8	15
Lisbon	Euronext Lisbon	Greenwich Mean Time	GMT		15
Bucharest	Bucharest Stock Exchange	Eastern European Time	EET	2	15
MICEX	MICEX	Moscow Time	MSK	4	15
Johannesburg	JSE Securities Exchange	South African Standard Time	SAST	2	30
Madrid	Bolsas y Mercados Españoles	Central European Time	CET	1	15
Stockholm	OMX Stockholm	Central European Time	CET	1	15
Swiss	Swiss Exchange	Central European Time	CET	1	15
Taiwan	Taiwan Stock Exchange	China Standard Time	TST	8	20
London	London Stock Exchange	Greenwich Mean Time	GMT		15
Amex	AMEX	Eastern Standard Time	EST	-5	15
NASDAQ	NASDAQ	Eastern Standard Time	EST	-5	15
NYSE	New York Stock Exchange	Eastern Standard Time	EST	-5	15
Moscow	Moscow Exchange	Moscow Time	MSK	4	15
TSX Venture	TSX Venture Exchange	Eastern Standard Time	EST	-5	15
NYSE ARCA	NYSE ARCA	Eastern Standard Time	EST	-5	15
Sao Paulo	BOVESPA	Brasilia Time	BRT	-3	15
OTCBB	OTCBB	Eastern Standard Time	EST	-5	15
BATS	Cboe BZX Exchange	Eastern Standard Time	EST	-5	Real-time
NASDAQ Indices	NASDAQ OMX Global Index Data Service	Eastern Standard Time	EST	-5	Real-time
Dow Jones Indices	Dow Jones Indices	Eastern Standard Time	EST	-5	Real-time
S&P Indices	S&P Indices	Eastern Standard Time	EST	-5	15
Warsaw	Warsaw Stock Exchange	Central European Time	CET	1	15
Istanbul	Istanbul Stock Exchange	Eastern European Time	EET	2	End of Day
Jakarta	Indonesia Stock Exchange	Western Indonesian Time	WIB	7	End of Day
Argentina	Merval (Buenos Aires Stock Exchange)	Argentina Time	ART	-3	15
Ho Chi Minh	Ho Chi Minh Securities Vietnam Stock Exchange	Indochina Time	ICT	7	End of Day
Lithuania	Nasdaq OMX Vilnius	Eastern European Time	EET	2	End of Day
Latvia	Nasdaq OMX Riga	Eastern European Time	EET	2	End of Day
Estonia	Nasdaq OMX Tallinn	Eastern European Time	EET	2	End of Day
United Arab Emirates	Abu Dhabi Securities Market	Arabian Standard Time	GST	4	End of Day
United Arab Emirates	Dubai Financial Market	Arabian Standard Time	GST	4	End of Day
Egypt	Cairo & Alexandria Stock Exchange	Egypt Standard Time	EET	2	End of Day
Columbia	Bolsa de Valores de Colombia	Colombia Time	COT	-5	End of Day
Venezuela	Bolsa de Valores de Caracas	Venezuela Time	VET	-4.5	End of Day
Peru	Bolsa de Valores de Lima	Peru Time	PET	-5	End of Day

cool, I just went with Office 365 after considering all the options.

This has just appeared in Excel for me after an update last night.

Quote:

Originally Posted by dabsman

Hi all I just spotted this - thought I'd let everyone know as it seems it will be damn helpful once rolled out totally!

https://support.office.com/en-us/art...0-623cf07fbc54

Hmmmm….might finally drive me to upgrade from Office 2007
Thanks.

Quote:

Originally Posted by RTM

Hmmmm….might finally drive me to upgrade from Office 2007
Thanks.

I upgraded for free from here using my old product key
https://www.microsoft.com/en-us/soft...ownload/office

Quote:

Originally Posted by kiora

I upgraded for free from here using my old product key
https://www.microsoft.com/en-us/soft...ownload/office

Thanks. How long ago did you do this ? I’ll give it a go.

Quote:

Originally Posted by RTM

Thanks. How long ago did you do this ? I’ll give it a go.

1 hr uploading but can't get data feed to work!!!
Sorry just me or don't know ???

[QUOTE Originally Posted by kiora https://www.sharetrader.co.nz/images...post-right.png I upgraded for free from here using my old product key
https://www.microsoft.com/en-us/soft...ownload/office [/QUOTE]

Quote:

Originally Posted by RTM

Thanks. How long ago did you do this ? I’ll give it a go.

I would presume you will have to pay for it in a years time when it is "renewed"??