ASCII Mapping - Cannot Map DJI Index  [SOLVED]

Questions about MultiCharts and user contributed studies.
petermcphee
Posts: 19
Joined: 06 Jun 2010
Location: Sydney, Australia
Has thanked: 2 times
Been thanked: 1 time

ASCII Mapping - Cannot Map DJI Index

Postby petermcphee » 26 Sep 2021

Hello,

I've successfully mapped a full US equities and US indices database into Quote Manager using the mapping feature. However, 3 DJ symbols refuse to be mapped.

The data is daily values and has the same fields as the rest of the database. But the default Resolution fields shown in QM these symbols are n/a and blank. If I try to change those fields to 1 day I receive this error "The file $DJI.csv can't be recognized as 1 bars."

I noticed that the 3 affected files are much larger than most, perhaps that is why; that there is a limit on how many daily bars can be read?

Any ideas what this could mean and how I can resolved? I've attached the csv file here if that helps.

Many thanks!

Peter.
Attachments
$DJI.zip
(366.38 KiB) Downloaded 70 times

User avatar
rrams
Posts: 128
Joined: 10 Feb 2011
Location: USA
Has thanked: 7 times
Been thanked: 70 times
Contact:

Re: ASCII Mapping - Cannot Map DJI Index

Postby rrams » 27 Sep 2021

When you import the ascii data, try changing the first field from "Unchanged Ticks" to "Date" using the yyyymmdd format and then set the resolution to 1 Day.

petermcphee
Posts: 19
Joined: 06 Jun 2010
Location: Sydney, Australia
Has thanked: 2 times
Been thanked: 1 time

Re: ASCII Mapping - Cannot Map DJI Index

Postby petermcphee » 27 Sep 2021

Hi Rrams, thanks for jumping in!

What do you mean by "Unchanged Ticks" as I don't see that option anywhere. This is what I see:
map-ascii-snip.png
(21.99 KiB) Not downloaded yet
Note, that I am mapping ASCII not importing static ASCII.

Thanks!

User avatar
Tammy MultiCharts
Posts: 200
Joined: 06 Aug 2020
Has thanked: 6 times
Been thanked: 65 times

Re: ASCII Mapping - Cannot Map DJI Index

Postby Tammy MultiCharts » 27 Sep 2021

Hello petermcphee,

MultiCharts has a limitation on the amount of data that can be imported / plotted.
Daily bars can be read since January 2, 1900. Your file, on the other hand, has data starting from 1896.
To be able to map your ASCII file, please remove the data before January 2, 1900.

petermcphee
Posts: 19
Joined: 06 Jun 2010
Location: Sydney, Australia
Has thanked: 2 times
Been thanked: 1 time

Re: ASCII Mapping - Cannot Map DJI Index  [SOLVED]

Postby petermcphee » 27 Sep 2021

Ah yep, that's what it was, thanks Tammy. Removing the old data fixed it, thanks for clarifying the date limitation.

Peter.


Return to “MultiCharts”