AU ETF market data is available now!

Following  alternative to yahoo finance api, now ETF is available.  The usage is exactly the same as ordinary shares.

• get delayed current realtime data for 'VTS':

Http request:



http://www.biglion.com.au/api/v1/asx/snapshot/




Query parameters:




symbol: specify valid ETF code.




e.g.




http://www.biglion.com.au/api/v1/asx/snapshot/?symbol=VTS



Response:



{"code":"VTS","bid_price":192.01,"offer_price":192.2,"open_price":192.86,"last_price":192.18,"change_in_percent":"-0.672%","change_price":-1.3,"day_high_price":193.11,"day_low_price":192.04,"average_daily_volume":10411,"volume":15562,"previous_close_price":193.48,"previous_day_percentage_change":"0.561%","eps":0,"pe":0,"annual_dividend_yield":0,"market_cap":1393366148,"number_of_shares":7201603,"year_change_in_percentage":"79.49%","year_change_price":85.11,"year_high_date":"2018-10-05T00:00:00+1000","year_high_price":210.99,"year_low_date":"2018-02-06T00:00:00+1100","year_low_price":165.5,"year_open_date":"2014-02-25T11:00:00+1100","year_open_price":107.07}







Get historical data of 'VAS', currently we support daily basis:




Http request:




http://www.biglion.com.au/api/v1/asx/history/price/




Query parameters:




symbol: ETF code.

frequency: currently support 'daily'.

datefrom: the start date you want the history data.

dateto: the end date you query.




e.g.






http://www.biglion.com.au/api/v1/asx/history/price/?symbol=VAS&frequency=daily&datefrom=18/09/2018&dateto=19/10/2018









Response:







{"2018-10-19":{"Open":"74.87","High":75.42,"Low":74.68,"Close":75.42,"Adjust Close":75.42,"Volume":73984.0},"2018-10-18":{"Open":"75.40","High":75.41,"Low":75.04,"Close":75.39,"Adjust Close":75.39,"Volume":81261.0},"2018-10-17":{"Open":"75.11","High":75.41,"Low":75.03,"Close":75.38,"Adjust Close":75.38,"Volume":131382.0},"2018-10-16":{"Open":"74.17","High":74.68,"Low":74.17,"Close":74.55,"Adjust Close":74.55,"Volume":175546.0},"2018-10-15":{"Open":"74.09","High":74.29,"Low":73.51,"Close":74.1,"Adjust Close":74.1,"Volume":231292.0},"2018-10-12":{"Open":"74.00","High":74.89,"Low":73.96,"Close":74.74,"Adjust Close":74.74,"Volume":149882.0},"2018-10-11":{"Open":"75.25","High":75.54,"Low":74.7,"Close":74.72,"Adjust Close":74.72,"Volume":192441.0},"2018-10-10":{"Open":"76.75","High":76.87,"Low":76.43,"Close":76.79,"Adjust Close":76.79,"Volume":57014.0},"2018-10-09":{"Open":"77.19","High":77.24,"Low":76.59,"Close":76.7,"Adjust Close":76.7,"Volume":76525.0},"2018-10-08":{"Open":"78.04","High":78.04,"Low":77.43,"Close":77.43,"Adjust Close":77.43,"Volume":68802.0},"2018-10-05":{"Open":"78.19","High":78.78,"Low":78.11,"Close":78.53,"Adjust Close":78.53,"Volume":60031.0},"2018-10-04":{"Open":"78.30","High":78.69,"Low":78.28,"Close":78.43,"Adjust Close":78.43,"Volume":55191.0},"2018-10-03":{"Open":"77.87","High":78.08,"Low":77.79,"Close":78.07,"Adjust Close":78.07,"Volume":37496.0},"2018-10-02":{"Open":"78.47","High":78.5,"Low":77.69,"Close":77.79,"Adjust Close":77.79,"Volume":62484.0},"2018-10-01":{"Open":"78.32","High":78.37,"Low":78.1,"Close":78.31,"Adjust Close":78.31,"Volume":90263.0},"2018-09-28":{"Open":"79.76","High":80.22,"Low":79.72,"Close":80.01,"Adjust Close":78.88,"Volume":166205.0},"2018-09-27":{"Open":"79.48","High":79.76,"Low":79.48,"Close":79.56,"Adjust Close":78.44,"Volume":101172.0},"2018-09-26":{"Open":"79.72","High":79.9,"Low":79.55,"Close":79.69,"Adjust Close":78.57,"Volume":24445.0},"2018-09-25":{"Open":"79.52","High":79.67,"Low":79.34,"Close":79.56,"Adjust Close":78.44,"Volume":67725.0},"2018-09-24":{"Open":"79.49","High":79.76,"Low":79.38,"Close":79.67,"Adjust Close":78.55,"Volume":51464.0},"2018-09-21":{"Open":"79.59","High":79.86,"Low":79.5,"Close":79.61,"Adjust Close":78.49,"Volume":23929.0},"2018-09-20":{"Open":"79.47","High":79.55,"Low":79.26,"Close":79.4,"Adjust Close":78.28,"Volume":41349.0},"2018-09-19":{"Open":"79.48","High":79.74,"Low":79.39,"Close":79.68,"Adjust Close":78.56,"Volume":32284.0}}






These ETF codes are supported:




['DMKT', 'GLIN', 'AOD', 'HBRD', 'BBOZ', 'HVST', 'GGUS', 'FOOD', 'BNKS', 'HACK', 'FUEL', 'MNRS', 'DRUG', 'AUST', 'AUDS', 'BBUS', 'CRED', 'EX20', 'A200', 'FAIR', 'EINC', 'BEAR', 'EEU', 'HEUR', 'HJPN', 'AAA', 'OOO', 'NDQ', 'ETHI', 'GEAR', 'EIGA', 'ILC', 'ISO', 'CORE', 'GOLD', 'ESTX', 'INIF', 'IAF', 'BILL', 'IHWL', 'IWLD', 'AUMF', 'MVOL', 'ISEC', 'IHCB', 'IHHY', 'IHOO', 'ILB', 'IJH', 'IKO', 'ITW', 'IHVV', 'IVV', 'IHD', 'IOZ', 'IJR', 'IGB', 'IHEB', 'IAA', 'IZZ', 'IEU', 'IXJ', 'IOO', 'IXI', 'IVE', 'IEM', 'IJP', 'KSM', 'KII', 'MGE', 'MICH', 'MHG', 'MOGL', 'PAXX', 'GROW', 'OZF', 'OZR', 'BOND', 'DJRE', 'GOVT', 'MONY', 'DIV', 'ETF', 'FLOT', 'MVB', 'CETF', 'EMKT', 'MVW', 'ESGI', 'FDIV', 'GDX', 'IFRA', 'MVE', 'MVA', 'MVR', 'MVS', 'MOAT', 'PIXX', 'PLUS', 'POU', 'QAG', 'QAU', 'QCB', 'QFN', 'QMIX', 'QOZ', 'QPON', 'QRE', 'QUAL', 'QUS', 'RARI', 'RCB', 'RDV', 'RENT', 'RGB', 'RINC', 'ROBO', 'RSM', 'SFY', 'SLF', 'SMLL', 'SPY', 'SSO', 'STW', 'SWTZ', 'SYI', 'TECH', 'UBA', 'UBE', 'UBJ', 'UBP', 'UBU', 'UBW', 'UMAX', 'USD', 'VACF', 'VAE', 'VAF', 'VAP', 'VAS', 'VBND', 'VCF', 'VDBA', 'VDCO', 'VDGR', 'VDHG', 'VEQ', 'VEU', 'VGAD', 'VGB', 'VGE', 'VGS', 'VHY', 'VIF', 'VLC', 'VMIN', 'VSO', 'VTS', 'VVLU', 'WDIV', 'WDMF', 'WEMG', 'WRLD', 'WVOL', 'WXHG', 'WXOZ', 'YANK', 'YMAX', 'ZOZI', 'ZUSD', 'ZYAU', 'ZYUS']



Any questions or need, please leave you message here or email me:

chenlocus@gmail.com, thanks.

An Alternative to Yahoo Finance API in Australian Share Market

I decided to provide this API service in the long run to help people like me used to struggle for financial data when trying to establish their own models. So as an investor and engineer, I will provide more data in the future according to your feedback and my own experience. This is some simple guide how to leverage it.

• Get current market snapshot of a symbol, price in AUD.

HTTP Request
GET http://www.biglion.com.au/api/v1/asx/snapshot/
Query parameters:
symbol: instrument name, such as Z1P, APT, TTT.

e.g.

http://www.biglion.com.au/api/v1/asx/snapshot/?symbol=z1p

{"code":"Z1P","bid_price":1.035,"offer_price":1.04,"open_price":1.01,"last_price":1.035,"change_in_percent":"5.612%","change_price":0.055,"day_high_price":1.057,"day_low_price":1.01,"average_daily_volume":1114071,"volume":811261,"last_price":1.035,"previous_close_price":0.98,"previous_day_percentage_change":"-12.5%","eps":-0.0784,"pe":0,"annual_dividend_yield":0,"market_cap":293956184,"number_of_shares":299955290,"year_change_in_percentage":"4,145.283%","year_change_price":1.01062,"year_high_date":"2018-02-01T00:00:00+1100","year_high_price":1.34,"year_low_date":"2017-10-18T00:00:00+1100","year_low_price":0.555,"year_open_date":"2014-02-28T11:00:00+1100","year_open_price":0.02438}

• Get all weekly price in one year.

HTTP Request
GET http://www.biglion.com.au/api/v1/asx/history/year
Query parameters:
symbol: instrument name.frequency: interval of the share price, currently support: weekly, daily. year: the year you want to get the share price, can go as early as 2015.
e.g.

http://www.biglion.com.au/api/v1/asx/history/year/?symbol=IRE&frequency=weekly&year=2018

{"2018-09-24":{"Open":"12.64","High":12.82,"Low":12.55,"Close":12.76,"Adjust Close":12.76,"Volume":319384.0},"2018-09-17":{"Open":"12.83","High":12.92,"Low":12.38,"Close":12.65,"Adjust Close":12.65,"Volume":1937329.0},"2018-09-10":{"Open":"12.92","High":13.12,"Low":12.81,"Close":12.83,"Adjust Close":12.83,"Volume":1150470.0},"2018-09-03":{"Open":"13.45","High":13.56,"Low":12.72,"Close":12.91,"Adjust Close":12.76,"Volume":1299226.0},"2018-08-27":{"Open":"13.65","High":13.69,"Low":13.28,"Close":13.44,"Adjust Close":13.28,"Volume":2625118.0},"2018-08-20":{"Open":"12.28","High":14.2,"Low":12.03,"Close":13.66,"Adjust Close":13.5,"Volume":2614749.0},"2018-08-13":{"Open":"11.75","High":12.33,"Low":11.75,"Close":12.27,"Adjust Close":12.12,"Volume":1401312.0},"2018-08-06":{"Open":"11.82","High":11.98,"Low":11.77,"Close":11.83,"Adjust Close":11.69,"Volume":1727845.0},"2018-07-30":{"Open":"11.84","High":11.91,"Low":11.54,"Close":11.8,"Adjust Close":11.66,"Volume":1444537.0},"2018-07-23":{"Open":"11.78","High":12.04,"Low":11.66,"Close":11.89,"Adjust Close":11.75,"Volume":1515612.0},"2018-07-16":{"Open":"11.76","High":11.91,"Low":11.6,"Close":11.84,"Adjust Close":11.7,"Volume":1061156.0},"2018-07-09":{"Open":"11.80","High":12.07,"Low":11.74,"Close":11.79,"Adjust Close":11.65,"Volume":1908495.0},"2018-07-02":{"Open":"12.03","High":12.26,"Low":11.58,"Close":11.79,"Adjust Close":11.65,"Volume":2028524.0},"2018-06-25":{"Open":"12.35","High":12.55,"Low":11.97,"Close":12.04,"Adjust Close":11.9,"Volume":1910314.0},"2018-06-18":{"Open":"11.88","High":12.48,"Low":11.85,"Close":12.33,"Adjust Close":12.18,"Volume":2092325.0},"2018-06-11":{"Open":"10.96","High":12.22,"Low":10.96,"Close":11.89,"Adjust Close":11.75,"Volume":3088854.0},"2018-06-04":{"Open":"10.61","High":11.06,"Low":10.56,"Close":10.96,"Adjust Close":10.83,"Volume":2697375.0},"2018-05-28":{"Open":"10.75","High":10.88,"Low":10.26,"Close":10.58,"Adjust Close":10.45,"Volume":2181597.0},"2018-05-21":{"Open":"10.86","High":10.99,"Low":10.55,"Close":10.76,"Adjust Close":10.63,"Volume":1368031.0},"2018-05-14":{"Open":"10.85","High":11.03,"Low":10.75,"Close":10.91,"Adjust Close":10.78,"Volume":1412793.0},"2018-05-07":{"Open":"10.79","High":11.16,"Low":10.73,"Close":10.81,"Adjust Close":10.68,"Volume":3472170.0},"2018-04-30":{"Open":"10.53","High":11.02,"Low":10.43,"Close":10.73,"Adjust Close":10.6,"Volume":2369764.0},"2018-04-23":{"Open":"10.21","High":10.55,"Low":10.05,"Close":10.52,"Adjust Close":10.39,"Volume":1573348.0},"2018-04-16":{"Open":"9.86","High":10.34,"Low":9.67,"Close":10.18,"Adjust Close":10.06,"Volume":1811849.0},"2018-04-09":{"Open":"9.42","High":9.87,"Low":9.37,"Close":9.85,"Adjust Close":9.73,"Volume":1899326.0},"2018-04-02":{"Open":"9.49","High":9.55,"Low":9.17,"Close":9.42,"Adjust Close":9.31,"Volume":2400276.0},"2018-03-25":{"Open":"9.68","High":9.69,"Low":9.32,"Close":9.49,"Adjust Close":9.38,"Volume":1906243.0},"2018-03-18":{"Open":"9.82","High":9.99,"Low":9.6,"Close":9.75,"Adjust Close":9.63,"Volume":1969429.0},"2018-03-11":{"Open":"10.09","High":10.21,"Low":9.81,"Close":9.82,"Adjust Close":9.7,"Volume":4100653.0},"2018-03-04":{"Open":"10.11","High":10.34,"Low":9.98,"Close":10.01,"Adjust Close":9.89,"Volume":2828019.0},"2018-02-25":{"Open":"10.73","High":10.79,"Low":10.01,"Close":10.13,"Adjust Close":9.75,"Volume":2082066.0},"2018-02-18":{"Open":"11.51","High":11.72,"Low":10.49,"Close":10.7,"Adjust Close":10.3,"Volume":3036963.0},"2018-02-11":{"Open":"11.58","High":11.64,"Low":11.39,"Close":11.49,"Adjust Close":11.06,"Volume":1307188.0},"2018-02-04":{"Open":"11.97","High":12.16,"Low":11.16,"Close":11.66,"Adjust Close":11.22,"Volume":2459720.0},"2018-01-28":{"Open":"12.06","High":12.12,"Low":11.91,"Close":11.96,"Adjust Close":11.51,"Volume":1989655.0},"2018-01-21":{"Open":"11.82","High":12.06,"Low":11.79,"Close":12.06,"Adjust Close":11.6,"Volume":578430.0},"2018-01-14":{"Open":"11.62","High":11.84,"Low":11.41,"Close":11.81,"Adjust Close":11.36,"Volume":1108662.0},"2018-01-07":{"Open":"11.85","High":11.85,"Low":11.4,"Close":11.62,"Adjust Close":11.18,"Volume":1520167.0}}

• Get historical price within a range:

HTTP Request
GET http://www.biglion.com.au/api/v1/asx/history/price/
Query parameters:
symbol: instrument name.frequency: currently support weekly, daily.datefrom: specify which date the data from.dateto: specify which date you want the data to.
e.g.

http://www.biglion.com.au/api/v1/asx/history/price/?symbol=IRE&frequency=weekly&datefrom=18/05/2018&dateto=19/09/2018

{"2018-09-17":{"Open":"12.83","High":12.92,"Low":12.38,"Close":12.65,"Adjust Close":12.65,"Volume":1937329.0},"2018-09-10":{"Open":"12.92","High":13.12,"Low":12.81,"Close":12.83,"Adjust Close":12.83,"Volume":1150470.0},"2018-09-05":{"Open":"0.16 Dividend","High":null,"Low":null,"Close":null,"Adjust Close":null,"Volume":null},"2018-09-03":{"Open":"13.45","High":13.56,"Low":12.72,"Close":12.91,"Adjust Close":12.76,"Volume":1299226.0},"2018-08-27":{"Open":"13.65","High":13.69,"Low":13.28,"Close":13.44,"Adjust Close":13.28,"Volume":2625118.0},"2018-08-20":{"Open":"12.28","High":14.2,"Low":12.03,"Close":13.66,"Adjust Close":13.5,"Volume":2614749.0},"2018-08-13":{"Open":"11.75","High":12.33,"Low":11.75,"Close":12.27,"Adjust Close":12.12,"Volume":1401312.0},"2018-08-06":{"Open":"11.82","High":11.98,"Low":11.77,"Close":11.83,"Adjust Close":11.69,"Volume":1727845.0},"2018-07-30":{"Open":"11.84","High":11.91,"Low":11.54,"Close":11.8,"Adjust Close":11.66,"Volume":1444537.0},"2018-07-23":{"Open":"11.78","High":12.04,"Low":11.66,"Close":11.89,"Adjust Close":11.75,"Volume":1515612.0},"2018-07-16":{"Open":"11.76","High":11.91,"Low":11.6,"Close":11.84,"Adjust Close":11.7,"Volume":1061156.0},"2018-07-09":{"Open":"11.80","High":12.07,"Low":11.74,"Close":11.79,"Adjust Close":11.65,"Volume":1908495.0},"2018-07-02":{"Open":"12.03","High":12.26,"Low":11.58,"Close":11.79,"Adjust Close":11.65,"Volume":2028524.0},"2018-06-25":{"Open":"12.35","High":12.55,"Low":11.97,"Close":12.04,"Adjust Close":11.9,"Volume":1910314.0},"2018-06-18":{"Open":"11.88","High":12.48,"Low":11.85,"Close":12.33,"Adjust Close":12.18,"Volume":2092325.0},"2018-06-11":{"Open":"10.96","High":12.22,"Low":10.96,"Close":11.89,"Adjust Close":11.75,"Volume":3088854.0},"2018-06-04":{"Open":"10.61","High":11.06,"Low":10.56,"Close":10.96,"Adjust Close":10.83,"Volume":2697375.0},"2018-05-28":{"Open":"10.75","High":10.88,"Low":10.26,"Close":10.58,"Adjust Close":10.45,"Volume":2181597.0},"2018-05-21":{"Open":"10.86","High":10.99,"Low":10.55,"Close":10.76,"Adjust Close":10.63,"Volume":1368031.0}}

• Get balance sheet for a symbol in a year:

HTTP Request
GET  http://www.biglion.com.au/api/v1/asx/financial/balancesheet/
Query parameters:
symbol: instrument name.year: which year you want the financial report in balance sheet.
e.g.

http://www.biglion.com.au/api/v1/asx/financial/balancesheet/?symbol=APT&year=2016

{"2016-06-30":{"totalasset":38992.195,"totaldebt":931.358,"receivable":7767.586,"payable":675.434,"currentassets":27521.269,"currentdebts":928.413,"totalcash":19723.472,"nettangibleassets":27227.504}}

• Get cash flow for a symbol in a year:

HTTP Request
GET  http://www.biglion.com.au/api/v1/asx/financial/cashflow/
Query parameters:
symbol: instrument name.year: which year you want the financial report in cash flow.
e.g.

http://www.biglion.com.au/api/v1/asx/financial/cashflow/?symbol=IRE&year=2017

{"2017-12-31":{"cashfromoperating":83743,"capitalexpenditure":-18945,"cashfrominvestment":-21606,"cashfromfinancing":-61176,"changeincash":5664}}

• Get revenue for a symbol in a year:

HTTP Request
GET  http://www.biglion.com.au/api/v1/asx/financial/revenue/
Query parameters:
symbol: instrument name.year: which year you want the financial report in income report.
e.g.

http://www.biglion.com.au/api/v1/asx/financial/revenue/?symbol=IRE&year=2017

{"2017-12-31":{"totalrevenue":429952,"costofrevenue":290020.0,"grossprofit":139932.0,"totalopexpense":346096.0,"EBIT":83856.0,"incomebeforetax":77765,"netincome":59755}}

To get valuation of the security in current market:

http://www.biglion.com.au/api/v1/asx/financial/valuation/?symbol=IRE

{"IRE":{"marketcap":"1.96B","enterprisevalue":"2.29B","PE":"31.60","anticipatedPE":"0","PEG":"0","PS":"4.37","PB":"4.85","enterprisevalue2revenue":"5.10","enterprisevalue2EBITDA":"22.23"}}

For those who is keen to use excel to do analysis, this is a guide how to import api data to spread sheet:

https://youtu.be/Hz4HTnQpTBw

ETF is available now!