Login Page - Create Account

Support Board


Date/Time: Sat, 04 May 2024 04:19:00 +0000



Post From: SpreedSheet Study - Save regular - sometimes the rows add´s column

[2021-10-12 19:10:39]
User230940 - Posts: 121
Hello,

I use the spreedsheet Study System/Alert with save regular option.

The saved file I use in excel which works fine to me.

But in some lines a addition column will be add to a date and/or time value.
This column only exists in these lines with the result, that excel can`t handle this column correcty. All column behind will be moved by one or N column.

For example the Problem exist on the following on a 15 Min Chart which every 1 Minute save intervall.

Date    Time    [ID0.SG1] Open  [ID0.SG2] High  [ID0.SG3] Low  [ID0.SG4] Last  [ID0.SG5] Volume  [ID0.SG6] # of Trades  [ID0.SG6] # of Trades        Buy Entry  Buy Exitt
2021-10-12  10:00:00  4334,75    4339,50    4332,25    4333,50    5772      4547    Last Bar End DateTime (read-only):  2021-10-12   19:39:09


The columns of the of the Date and the Time at end does not exist on a normal line. Two column will be add the line. The column will be start at "J".

Because of that the whole Save File can not be used in Excel, or does not provide correct entries.

Is it possible to remove the lines like "Last Bar" or "Chart End Time" or "Chart Start Time".
I think there are more line with dynamic input.

Or can save file include from the beginning all correct columns?

Or did I make any mistake?

Thanks for help
regards
carsten