⭐ yorkfung Posted February 3, 2022 Report Share Posted February 3, 2022 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 Quote Link to comment Share on other sites More sharing options...
orfila Posted February 3, 2022 Report Share Posted February 3, 2022 sometimes line 1 is used for label names, try skipping it ? Quote Link to comment Share on other sites More sharing options...
⭐ yorkfung Posted February 3, 2022 Author Report Share Posted February 3, 2022 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. Quote Link to comment Share on other sites More sharing options...
⭐ FFRT Posted February 3, 2022 Report Share Posted February 3, 2022 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 1 Quote Link to comment Share on other sites More sharing options...
⭐ yorkfung Posted February 3, 2022 Author Report Share Posted February 3, 2022 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! Quote Link to comment Share on other sites More sharing options...
⭐ FFRT Posted February 4, 2022 Report Share Posted February 4, 2022 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. :) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.