CSV Import Data Format - The HA can import CSV data from any source but it must be formatted in an exact layout.   Please follow the following Excel spreadsheet to correctly import the data files.  The data must be saved to the hadata folder.  

Save the following sample Excel file to your hadata folder to test the data import.  

HA CSV Intraday 60-Minute File (aafw20_60.csv)

Date Time Open High Low Close Vol OI
8/30/2013 9:00:00 2355 2356 2349 2352 723 109107
8/30/2013 10:00:00 2353 2357 2327 2334 5931 109376
8/30/2013 11:00:00 2334 2340 2329 2338 2886 109687
8/30/2013 12:00:00 2338 2342 2337 2340 1246 109680

HA CSV Daily File (aaHACSVdaily.csv)

Symbol Date Open High Low Close Vol OI
FW20Z12 20111220 2103 2145 2093 2136 143 186
FW20Z12 20111221 2148 2158 2124 2140 178 222
FW20Z12 20111222 2147 2158 2140 2146 65 225
FW20Z12 20111223 2158 2165 2150 2164 45 226
FW20Z12 20111227 2172 2172 2157 2157 6 226