update on 'Get current market snapshot of a symbol, price in AUD.'

Now we can get snapshot of more than one symbol on one request ( update to 6 symbols on this free version ).

This will take effect after 10:00 PM 5/11/2018 at Melbourne, Sydney time zone.

HTTP Request
GET http://www.biglion.com.au/api/v1/asx/snapshot/
Query parameters:
symbol: instrument names with commas to separate, such as 'Z1P, APT, TTT'.
e.g.

http://www.biglion.com.au/api/v1/asx/snapshot/?symbol=Z1P,APT,IRE,A3D,TTT

{"Z1P":{"bid_price":0.96,"offer_price":0.97,"open_price":0.99,"last_price":0.96,"change_in_percent":"-0.518%","change_price":-0.005,"day_high_price":0.99,"day_low_price":0.96,"average_daily_volume":1119015,"volume":263655,"previous_close_price":0.965,"previous_day_percentage_change":"0.521%","eps":-0.0784,"pe":0,"annual_dividend_yield":0,"market_cap":290060670,"number_of_shares":300581005,"year_change_in_percentage":"3,837.654%","year_change_price":0.93562,"year_high_date":"2018-02-01T00:00:00+1100","year_high_price":1.34,"year_low_date":"2017-12-21T00:00:00+1100","year_low_price":0.635,"year_open_date":"2014-02-28T11:00:00+1100","year_open_price":0.02438},"APT":{"bid_price":12.89,"offer_price":12.91,"open_price":13.1,"last_price":12.89,"change_in_percent":"-1.453%","change_price":-0.19,"day_high_price":13.49,"day_low_price":12.75,"average_daily_volume":2368708,"volume":911291,"previous_close_price":13.08,"previous_day_percentage_change":"0.926%","eps":-0.04,"pe":0,"annual_dividend_yield":0,"market_cap":3008019660,"number_of_shares":229970922,"year_change_in_percentage":null,"year_change_price":null,"year_high_date":"2018-08-24T00:00:00+1000","year_high_price":23,"year_low_date":"2017-11-27T00:00:00+1100","year_low_price":4.7,"year_open_date":null,"year_open_price":null},"IRE":{"bid_price":10.96,"offer_price":10.97,"open_price":10.98,"last_price":10.97,"change_in_percent":"-0.993%","change_price":-0.11,"day_high_price":11.19,"day_low_price":10.94,"average_daily_volume":348995,"volume":399127,"previous_close_price":11.08,"previous_day_percentage_change":"0.911%","eps":0.3664,"pe":30.24,"annual_dividend_yield":3.97,"market_cap":1918697296,"number_of_shares":173167626,"year_change_in_percentage":"13.093%","year_change_price":1.27,"year_high_date":"2018-08-23T00:00:00+1000","year_high_price":14.2,"year_low_date":"2018-04-04T00:00:00+1000","year_low_price":9.17,"year_open_date":"2014-02-25T11:00:00+1100","year_open_price":9.7},"A3D":{"bid_price":0.68,"offer_price":0.715,"open_price":0.72,"last_price":0.72,"change_in_percent":"1.408%","change_price":0.01,"day_high_price":0.73,"day_low_price":0.68,"average_daily_volume":331884,"volume":73619,"previous_close_price":0.71,"previous_day_percentage_change":"1.429%","eps":-0.0913,"pe":0,"annual_dividend_yield":0,"market_cap":48125767,"number_of_shares":67782771,"year_change_in_percentage":null,"year_change_price":null,"year_high_date":"2017-11-09T00:00:00+1100","year_high_price":1.48,"year_low_date":"2018-09-04T00:00:00+1000","year_low_price":0.335,"year_open_date":null,"year_open_price":null},"TTT":{"bid_price":1.94,"offer_price":1.945,"open_price":1.97,"last_price":1.94,"change_in_percent":"-2.267%","change_price":-0.045,"day_high_price":1.975,"day_low_price":1.925,"average_daily_volume":328169,"volume":80130,"previous_close_price":1.985,"previous_day_percentage_change":"-0.75%","eps":-0.0355,"pe":0,"annual_dividend_yield":0,"market_cap":243952961,"number_of_shares":122898217,"year_change_in_percentage":null,"year_change_price":null,"year_high_date":"2018-05-28T00:00:00+1000","year_high_price":3.12,"year_low_date":"2017-11-01T00:00:00+1100","year_low_price":0.62,"year_open_date":null,"year_open_price":null}}

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!

Data accumulation/cleaning is like foundation and reinforcement in home building for data analysis

Yahoo finance API used to do everything for us, however it has been closed off, so somebody like me have to find another way out to get access to those financial data before doing analysis.


I did some work to accumulate data myself to have a data source for analysis:
https://github.com/chenlocus/aushare

However, I found this is far from enough.  ASX has a lot of codes which were delisted but still in their website for people to download:
https://www.asx.com.au/asx/research/ASXListedCompanies.csv


First of all, I need to sort out those delisted symbols from the list above, then I need to remove those invalid data such as 'null', 'n/a', '-' in the data I crawled, thanks to pandas, doing a lot of work and make the job much easier.


I need to amass those balance sheet, income report, cash flow, as well as such information as market capitals, P/E, Dividend from websites and store them in various files. These data are to be cleaned thus provide a strong foundation and stump for my data analysis work.


I feel so excited that I can use these data analysis tools and techniques to re-play and prove my opinions and philosophies  in stock market investment from year 1997 since I was a university student.


These are something I figure out when Yahoo finance API was available, now I have to do these by building an API by myself.  I think a real investor can understand the importance of price you buy in. Charts like these can provide benchmark for evaluation of share price in different period.