Heres some pretty pictures....
hi
how do you get this charts?
thx
OK, follow these rough steps :
In Excel, make a tab to pull the raw data.
Use Get External Data/FromText (on the Data tab), point it at the current gains log file. Note you can set this to auto refresh/reload every x mins.
Import using space as delimiter. Its a bit messy but it does work.
Insert column labels. You need to do this for ALL columns, even the ones with bits of text in them (for pivot chart to work).
Unfortunately this splits the date and the time to separate columns so insert a new column (call it DateTime or something), make it of custom format dd/mm/yyyy hh:mm. Copy a formula down this column with DateCell + TimeCell, and it should give you the full date and time stamp.
You should get something like this : (sorry columns labels aren't aligned)
DateTime Date Time Market Start Trade Start Amount t1 End Trade End Amount t2 Gain t3 Fee1 Fee2 t4 t5 t6 Tot Mkt Gain t7 t8 t9 Tot Cum Gain
17/01/2014 08:00 17/01/2014 08:00:20 ASC/LTC Sell 2168.47142300@0.00005237 -> Buy 2183.48106133@0.00005201 Gain 0.00021587 Fee 0.00057017 (0.00034304+0.00022713) Total Market Gain 0.00021587 Global Market Gain 0.00021587
17/01/2014 08:09 17/01/2014 08:09:58 TIX/LTC Buy 700000.00000000@0.00000158 -> Sell 653136.75483768@0.00000159 Gain 0.00135199 Fee 0.00517937 (0.00206391+0.00311546) Total Market Gain 0.00135199 Global Market Gain 0.00156787
17/01/2014 08:10 17/01/2014 08:10:38 TIX/LTC Buy 700000.00000000@0.00000158 -> Sell 46863.24516232@0.00000159 Gain 0.000097 Fee 0.00037162 (0.00014808+0.00022354) Total Market Gain 0.001449 Global Market Gain 0.00166487
17/01/2014 08:19 17/01/2014 08:19:36 WDC/LTC Sell 1.00000000@0.01519998 -> Buy 1.00657119@0.01510075 Gain 0.00002358 Fee 0.00007629 (0.00004589+0.00003040) Total Market Gain 0.00002358 Global Market Gain 0.00168845
17/01/2014 08:19 17/01/2014 08:19:36 WDC/LTC Sell 4.01581348@0.01519998 -> Buy 4.04220186@0.01510075 Gain 0.0000947 Fee 0.0003064 (0.00018432+0.00012208) Total Market Gain 0.00011828 Global Market Gain 0.00178316
Now do Insert/PivotChart, select all data columns and place it on a new worksheet.
Drag DateTime to Axis Fields
Drag Market to Legend Fields
Drag Total Mkt Gain to Values
Left click on Total Mkt Gain in values (shown as Count of Total Mkt Gain) and select Value Field Settings.
On the Summarize By tab change from Count to Sum.
(And the clever bit) On the Show Values As tab set to Running Total in and select the base field DateTime.
You should now have a pivot table of data and a chart. You can change to the chart type to whatever you want - I used Stacked Area and Line.
Pivot table should look something like this : (again formatting is a bit screwed)
Sum of Gain Column Labels
Row Labels ASC/LTC DOGE/LTC DVC/LTC EZC/LTC FLO/LTC GME/LTC IFC/LTC JKC/LTC MEC/LTC MEM/LTC NET/LTC QRK/LTC SXC/LTC TIX/LTC WDC/LTC XNC/LTC ZET/LTC (blank) Grand Total
17/01/2014 08:00 0.00021587 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00021587
17/01/2014 08:09 0.00021587 0 0 0 0 0 0 0 0 0 0 0 0 0.00135199 0 0 0 0 0.00156786
17/01/2014 08:10 0.00021587 0 0 0 0 0 0 0 0 0 0 0 0 0.00144899 0 0 0 0 0.00166486
17/01/2014 08:19 0.00021587 0 0 0 0 0 0 0 0 0 0 0 0 0.00144899 0.00011828 0 0 0 0.00178314
17/01/2014 08:31 0.00021587 0 0 0 0 0 0 0 0 0 0 0 0 0.00144899 0.00039053 0 0 0 0.00205539
17/01/2014 08:33 0.00021587 0 0 0 0 0 0 0 0 0 0 0 0 0.00144899 0.00216363 0 0 0 0.00382849
17/01/2014 08:43 0.00021676 0 0 0 0 0 0 0 0 0 0 0 0 0.00144899 0.00216363 0 0 0 0.00382938
17/01/2014 08:43 0.00024282 0 0 0 0 0 0 0 0 0 0 0 0 0.00144899 0.00216363 0 0 0 0.00385544
17/01/2014 08:50 0.00024282 0 0 0 0 0 0 0 0 0 0 0 0.00109534 0.00144899 0.00216363 0 0 0 0.00495078
17/01/2014 08:57 0.00024282 0 0 0 0 0 0 0 0 0 0.00001103 0 0.00109534 0.00144899 0.00216363 0 0 0 0.00496181
17/01/2014 09:02 0.00024282 0 0 0 0 0 0 0 0 0 0.00001103 0 0.00109534 0.00144899 0.0022114 0 0 0 0.00500958
17/01/2014 09:03 0.00024282 0 0 0 0 0.00000645 0 0 0 0 0.00001103 0 0.00109534 0.00144899 0.0022114 0 0 0 0.00501603
17/01/2014 09:04 0.00024282 0 0 0 0 0.00000645 0 0 0 0 0.00001103 0 0.00109534 0.00144899 0.0022114 0.00001259 0 0 0.00502862
17/01/2014 09:06 0.00024282 0 0 0 0 0.00000645 0 0 0 0 0.00001103 0 0.00109534 0.00144899 0.0022114 0.00003358 0 0 0.00504961
17/01/2014 09:07 0.00024282 0 0 0 0 0.00000645 0 0 0 0 0.00001103 0 0.00109534 0.00145934 0.0022114 0.00003358 0 0 0.00505996