Use 4 digit year, not 2, was: Import Wizard Shortens Data

Data Sources
1

I'm using ver 6.93.0 , 64 bit. I'm attempting to import.csv file to database file under group 255. The .csv file is only 4 columns, date, open, close and full name - a mutual fund downloaded today and have checked its current in excel file. I'm also using Norgate data plugin which is currently working perfectly. Using the import wizard I pick the file, correct the headers, skip the unused ones and skip the first line.

image
image442×440 14.4 KB

Import file and click finish. however plotted file from Group 255 only plots to 31/12/24 not current date. Whilst rest of current norgate data elsewhere plots fully. Data.csv file is 2546 lines long. default # of bars in preferences is 3000, local database quotations save options is Unchecked. Plotted data does have first year dated as 1925 then a vertical gap to continuous data from 2015 to today. Its the same problem of plot ending 2024 across other current downloaded data from the same source. Am I missing a database setting affecting this?
Thanks in advance for your help

2

  1. If your database is PLUGIN-DRIVEN from external database (Norgate?) then PLUGIN controls all data and you can't import to whatever plugin controls, because plugin would overwrite all imports, UNLESS
    you turn "Use only local database for this symbol" option in the Information window that tells AmiBroker NOT to use plugin for particular symbol.

  2. The other thing is that you MUST NOT use two digit year.
    You have to use FOUR DIGIT year because '25' may mean 1925 or 2025 and AmIBroker has no way to know what you mean.

Recommended reading:

3 Likes