User Manual - Volume by Price Indicator - 5.6 Preparing Custom Data, 5.6.1 Spreadsheet

15 April 2019, 12:14
Brian Collard
0
20


5.6   Preparing Custom Data


5.6.1 Spreadsheet

Example of preparing custom data of future contract real volume or open interest with spreadsheet.


Preparing Custom Data, Spreadsheet - Volume by Price


Delete unused columns. For file format #2 additionally retain Last and Open.

Choose Real Volume or Open Interest.

Preparing Custom Data, Spreadsheet - Volume by Price


Cut and paste columns in the right file format order.

File format #1: VOLUME DATETIME

File format #2: VOLUME DATETIME CLOSE OPEN

Preparing Custom Data, Spreadsheet - Volume by Price


Convert datetime to a unix timestamp.

Formula: =( %CELL% - DATEVALUE("1/1/1970"))*86400

Preparing Custom Data, Spreadsheet - Volume by Price


Copy and paste formula to all fields of datetime column

Preparing Custom Data, Spreadsheet - Volume by Price

Preparing Custom Data, Spreadsheet - Volume by Price


Copy formula column as static timestamp column

Preparing Custom Data, Spreadsheet - Volume by Price

Preparing Custom Data, Spreadsheet - Volume by Price


Delete formula column, original datetime column and any header and footer.

Preparing Custom Data, Spreadsheet - Volume by Price



Back To Index




Share it with friends: