ProcessASXHistory Using PowerShell

15 Aug 2017

Recently I have been wanting to gather stock trading information.  I have found a site where ASX trading history is being shared as csv data.  While it is great that someone has been prepared to gather and process the information and share it, it is not quite in the format that I require.  The data comes as a zip file of multiple txt files with the data comma delimited.  Also, the format of the trading date does not work when loaded in to excel or imported to SQL for me as it is interpreted as a large number rather than a date. 

My solution to this is to process the data with a PowerShell script to aggregate all txt files data into one csv file, to convert the date into a format that will work for me, and while I am at it, add in a column to identify the data as coming from the ASX.