View Full Version : Office 365 Stock Price Automation
dabsman
16-07-2018, 06: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, 09: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, 10: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.
cool, I just went with Office 365 after considering all the options.
Vagabond47
28-07-2018, 11:51 AM
This has just appeared in Excel for me after an update last night.
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, 12:26 PM
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
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, 03: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 ???
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"??
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.