| Author |
Message |
     jademan
Member
Username: jademan
Post Number: 1
Registered: 01-2008Rating: N/A
Votes: 0
|
| | Tuesday, January 29, 2008 - 09:26 am: |  
|
I'm a newbie, and I'm cannot figure out how to upload chart data from an Excel file that can be read as a chart. What am I missing? As an example, my Excel data is formatted like this:
Date , Open , High , Low , Close , Volume
10/25/1999 , 4.6029 , 4.6029 , 4.6029 , 4.6029 , 12349
10/26/1999 , 4.6029 , 4.6029 , 4.6029 , 4.6029 , 12346
10/27/1999 , 4.6029 , 4.6029 , 4.6029 , 4.6029 , 13556
10/28/1999 , 4.6029 , 4.6029 , 4.6029 , 4.6029 , 14556
etc...
The file is named abc.csv or abc.txt
but I cannot load either of them into Incredible Charts.
|
colin_twiggs
Member
Username: colin_twiggs
Post Number: 3100
Registered: 09-2002Rating: N/A
Votes: 0
|
| | Tuesday, January 29, 2008 - 04:54 pm: |
|
Jademan,
- Remove all blank spaces -- including in the heading,
- Alter the date format to 25-Oct-99,
- Use Data >> Sort to reverse the date order
Example:
Date,Open,High,Low,Close,Volume
28-Oct-99,4.6029,4.6029,4.6029,4.6029,14556
27-Oct-99,4.6029,4.6029,4.6029,4.6029,13556
26-Oct-99,4.6029,4.6029,4.6029,4.6029,12346
25-Oct-99,4.6029,4.6029,4.6029,4.6029,12349
Regards,
Colin
|
jademan
Member
Username: jademan
Post Number: 2
Registered: 01-2008Rating: N/A
Votes: 0
|
| | Tuesday, January 29, 2008 - 07:02 pm: |
|
Colin,
Thank you, it now works.
|
|
