Excel static provider: only the first day bar can be plotted
Author: lookingbackon
Creation Date: 4/11/2011 11:01 AM
profile picture

lookingbackon

#1
Hello,
I just successfully installed the Excel static provider and created 2 new dataset(2 symbols). But the problem is that only the first day bar can be plotted and no others. Also, when place the mouse on the bar, no "change" and "change%" data available. What could be the cause with that?
Thanks
profile picture

Eugene

#2
I'll definitely need more details like the way the data is being kept in the spreadsheet, Excel file version (XLS/XLSX), WLD and operating system "bitness" (64-bit or 32-bit). Otherwise it's just guesswork. Please open a new ticket, attaching the problematic file and specifying the other bits and pieces of information.
profile picture

Eugene

#3
To anyone interested, here's the cause of the problem:

Only the first data record contained a symbol name, and the Excel provider was able to read it. For other data cells from the spreadsheet containing OHLC data, the symbol name was blank.

For the provider to work, each data record must contain a symbol name.