I need to export the monthly volume (not daily rate) from Future file. Need your help how to do it? Thanks


 

-----------------------------------------------------------------------------------------------------------------------------------


If you choose the option

Main Menu > Export Data > Export Data resampled at specified dates to Excel

and specify monthly time steps, then you will get rate (per calendar day) and cumulative data for each month.

The monthly volumes (e.g. for Jan 2015) can be calculated in Excel by either of the following formulae
 = (Cumulative at end of month - cumulative at start of month)    - e.g. (Cum at 1 Feb 2015 - Cum at 1 Jan 2015)
 = (Rate per calendar day) x (Calendar days in month)  e.g. (Rate reported for 1 Jan 2015) x 31