Format error in line 1: Input string was not in a correct format

[⭐ yorkfung]

Could anyone help me import these three lines of data (CSV file) into NT7?

 

What's reason for "Format error in line 1: Input string was not in a correct format"?

 

 

20100806;63.00;70.15;63.00;69.91;122961.80

20100809;75.08;76.90;74.66;75.00;71491.76

20100810;73.88;82.40;73.88;80.00;49458.44

[orfila]

sometimes line 1 is used for label names, try skipping it ?

[⭐ yorkfung]

no lable line needed in fact.

 

The following lines can be imported correctly:

20180516;2040;2071;2008.5;2031.5;61

20180517;2074;2074;2011;2029;31

20180518;2048;2056;2002;2008;63

20180521;2000;2018;1980;1980;31

 

so I am very perplexed.

[⭐ FFRT]

Could anyone help me import these three lines of data (CSV file) into NT7?

 

What's reason for "Format error in line 1: Input string was not in a correct format"?

 

 

20100806;63.00;70.15;63.00;69.91;122961.80

20100809;75.08;76.90;74.66;75.00;71491.76

20100810;73.88;82.40;73.88;80.00;49458.44

 

If last column data represents VOlume or Open Interest, why is it in Decimal? Please check as in your other example in #3 last column/field has no such decimal . Just observation from limited stuff you shared.

[⭐ yorkfung]

the last column is volume. The original data is decimal. I change it to whole number and then it works now.

 

Thank you very much for your tips @ FFRT!

 

 

[⭐ FFRT]

the last column is volume. The original data is decimal. I change it to whole number and then it works now.

 

Thank you very much for your tips @ FFRT!

 

 

Glad to help you. You can press like button also, alternatively, but not necessarily. :)