PDA

View Full Version : Office 365 Stock Price Automation



dabsman
16-07-2018, 05:24 PM
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/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54

Vagabond47
17-07-2018, 08:39 AM
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/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54

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

dabsman
17-07-2018, 09:13 AM
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.

peat
17-07-2018, 09:30 PM
cool, I just went with Office 365 after considering all the options.

Vagabond47
28-07-2018, 10:51 AM
This has just appeared in Excel for me after an update last night.

RTM
30-07-2018, 08:08 AM
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/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54

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

kiora
30-07-2018, 11:26 AM
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/software-download/office

RTM
30-07-2018, 02:00 PM
I upgraded for free from here using my old product key
https://www.microsoft.com/en-us/software-download/office

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

kiora
30-07-2018, 02:24 PM
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 ???

Jay
30-07-2018, 03:15 PM
kiora[/B] https://www.sharetrader.co.nz/images/buttons/viewpost-right.png (https://www.sharetrader.co.nz/showthread.php?p=722825#post722825) I upgraded for free from here using my old product key
https://www.microsoft.com/en-us/soft...ownload/office (https://www.microsoft.com/en-us/software-download/office)


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"??