How to calculate profit by years, months of each year - General

Vladimir Pastushak 2016.06.17 10:37 #16021

Vasiliy Sokolov:

You are very wrong about parsing.

You need to parse the date through your own date parsing function that understands the Excel format.

First you read it,

then parse,

then fill in the array structure.

OR

Read directly into the structure array ?

My task is to calculate profit by years, by months of each year, for different orders and take into account all types of orders and swap commissions.

So, I have something like

Year[].Month[].Day[].BuyProf.

Taking the date from the excel and buying it in year and month turned out to be nonsense....

The error was that there was a line break in some of the cells...

[ARCHIVE!] Any rookie question, Any questions from newcomers Server version in Opener

Vasiliy Sokolov 2016.06.17 10:51 #16022

Vladimir Pastushak:

Read first,

then parse,

then fill in the array structure

OR

Read directly into the structure array ?

My task is to calculate profit by years, by months of each year, for different orders and take into account all types of orders and swap commissions.

So, I have something like

Year[].Month[].Day[].BuyProf.

Taking the date from the excel and buying it in year and month turned out to be nonsense....

The error was that there was a line break in some of the cells...

   int h = FileOpen(file_name, FILE_BIN|FILE_READ|FILE_SHARE_READ|common);
   uchar array[];
   FileReadArray(h, array, 0, WHOLE_ARRAY);
   FileClose(h);
   string text = CharArrayToString(array, 0, WHOLE_ARRAY, CP_ACP);
   string lines[];
   StringSplit(text, '\n', lines);
   for(int i = 1, k=0; i < count_lines; i++)
   {
      string columns[];
      StringSplit(lines[i], ';', columns);
      datetime date = ParseData(columns[0]);
      ///
   }

ParseData is your function. Next, parse the rest of the rows.

A100 2016.06.18 16:21 #16023

Abstraction error internal error #112 when compiling

#property library
void f() {}
void g() export { f; }

A100 2016.06.18 16:29 #16024

Compilation error

class A {};
class B : public A {};
void f( const A *a )
{
        const B *b1 =             (const B *)( a ); //error: 'const' - unexpected token
        const B *b2 = dynamic_cast<const B *>( a ); //нормально
}