5.6 Preparing Custom Data
Example of preparing custom data of future contract real volume or open interest with spreadsheet.
Delete unused columns. For file format #2 additionally retain Last and Open.
Choose Real Volume or Open Interest.
Cut and paste columns in the right file format order.
File format #1: VOLUME DATETIME
File format #2: VOLUME DATETIME CLOSE OPEN
Convert datetime to a unix timestamp.
Formula: =( %CELL% - DATEVALUE("1/1/1970"))*86400
Copy and paste formula to all fields of datetime column
Copy formula column as static timestamp column
Delete formula column, original datetime column and any header and footer.