Exporting Charts with Dates

[dilmun99]

How can I export chart data into Excel with dates? If I check the Point Index box I just get a number series. It's hard to go from that to numbers and be certain that every day the market was closed is omitted (e.g. the week or so after 9/11).

Thanks
Andrew

[David Samborsky]

When exporting data directly from the charts click on the "Export" tool button, don't include "Point Index" and select the relevant series from the dropdown menu. Click on Save and type in the file name.

The following was exported from the Equity Chart.


Text Equity
16/06/1999 0
25/02/2000 986.700081825256
27/06/2001 222.040109872818
19/07/2001 777.240242242813
23/10/2001 837.43989777565
19/11/2001 1524.94013619423
18/12/2001 1646.89001989365
21/12/2001 2361.14019018412
20/02/2002 4655.12010604143
25/02/2002 2532.78024822474
21/03/2002 3088.31545758247
13/06/2002 3368.63519024849
12/09/2002 3590.83497834206
28/10/2002 24452.4449509382
21/11/2002 24583.995139122
03/01/2003 25274.2076516151
11/02/2003 29043.2877249718
20/05/2003 25603.0377603769
22/05/2003 25603.0377603769
14/07/2003 26539.0674120188
22/07/2003 27612.9372707605
31/07/2003 29732.6168972254
07/08/2003 30663.15657866
25/08/2003 31663.0764471292
05/09/2003 30468.9665927887
11/09/2003 31293.0661343336
10/10/2003 28938.1162207127
23/10/2003 29226.9163756371
06/11/2003 33149.8363022804
10/11/2003 33375.556286335
11/11/2003 33559.0361113548

[dilmun99]

After experimentation it looks like my problem is with the open trade equity chart. It exports the open trade equity and the closed trade equity but not the date. Or do I have some setting wrong somewhere?

[dilmun99]

After experimentation it looks like my problem is with the open trade equity chart. It exports the open trade equity and the closed trade equity but not the date. Or do I have some setting wrong somewhere?

[David Samborsky]

Make sure you select "Open Trade Equity" from the series menu.