I am posting data to NJ through a VBA macro of excel file. As a result, the values for OPEN, HIGH, LOW, CLOSE and VOLUME gets saved in Historical Data of NJ and also the generated chart gets refreshed or show the bars for new row. Now I am facing the below issue, which occurs randomly and not every time.
I have attached 2 images to illustrate this issue.
In image C-1 The number of rows in Excel are 30 and the number of rows in the .txt file are 29 which is correct as per my implementation.But if you look at the chart in image C-2 the number of rows are only 26 meaning that it's missing 3 bars or 3 rows of data.
The first and third and forth white vertical lines(counting from the left) are the areas at which two bars are consolidated into one bar i.e. row 3 & 4 make one bar , rows 22 & 23 make one bar and rows 27 & 28 make one bar for a total of 3 bars while there should be 6 bars.
I am unable to understand this inconsistent behaviour. Kindly let me know if this is a feature or bug or limitation of NJ.
Regards,
S.M.Yaseen.
Comment