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
[email protected] ->
Buy
[email protected] 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
[email protected] ->
Sell
[email protected] 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
[email protected] ->
Sell
[email protected] 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
[email protected] ->
Buy
[email protected] 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
[email protected] ->
Buy
[email protected] 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