Help with exporting data from TS

M

mishee

Newbie

Messages

9

Likes

0

• Jan 15, 2011

• #1

Hi,

Could someone help me with exporting some data from TS to Excel? When I View and then Save a performance report to Excel the entry prices on the trade list seem to be rounded up/down. So if the entry for Cable was 1.5567 in the performance report, once I save it for some reason it appears as 1.56 etc.

Thanks,
mishee

 

Trader333

Moderator

Messages

8,746

Likes

1,025

• Jan 15, 2011

• #2

What version of TS are you using ?


Paul

 

M

mishee

Newbie

Messages

9

Likes

0

• Jan 16, 2011

• #3

Hi Paul - I was using 8.6.

But I downloaded v9 after your post but I still have the same problem when I choose Save Type as Excel from the perf report/trade list?

Thanks

 

Last edited: Jan 16, 2011

M

mishee

Newbie

Messages

9

Likes

0

• Jan 16, 2011

• #4

Actually I managed to sort this out - it was an excel issue of course. Thx

You don't know what 'Floating Points Invalid Numbers in Calculation' means? Using the same strat on v9 and it doesn't run but gives me that message?

 

Trader333

Moderator

Messages

8,746

Likes

1,025

• Jan 16, 2011

• #5

I think (but don't know for sure) that floating point errors are usually to do with a line of code in software where a variable has been incorrectly specified (in terms of type) or there is something trying to divide by 0.


Paul

 

M

mishee

Newbie

Messages

9

Likes

0

• Jan 16, 2011

• #6

Great, thx.