Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers Joined: 10/8/2010(UTC) Posts: 1,960
Thanks: 91 times Was thanked: 155 time(s) in 150 post(s)
|
Originally Posted by: Pawelpipi Hi, I am using Downloader for version 18.4.23079.2 from May 2024 In one txt file I have multiple securities for multiple days usually a week - daily data - I get the above mentioned problem. When I convert the data for multiple securities for only one day in txt file it is complately fine and data is being stored in Metastock database. I am converting/downloading the data to MSLocal Metastock format/file type. Pawel.
Thank you for the clarification. One additional item I forgot to ask, is the data for each particular instrument within the text file sequential, or is it sorted by date instead? i.e. is it sorted like: Code:1/2/1980,IBM,4,5,2,3
1/2/1980,AAPL,4,5,2,3
1/3/1980,IBM,4,5,2,3
1/3/1980,AAPL,4,5,2,3
or is it sorted like: Code:1/2/1980,IBM,4,5,2,3
1/3/1980,IBM,4,5,2,3
1/2/1980,AAPL,4,5,2,3
1/3/1980,AAPL,4,5,2,3
It is also possible that the name of the TXT/CSV file could be interfering with the process. Does the name of the TXT/CSV file contain a # sign or is it simply letters/numbers? It might be helpful to contact our support team directly to see if we can look at the specifics of your source file to see where it might be failing. You can see our contact information at https://www.metastock.com/company/contact.aspx Here is some sample text of a multi-instrument text file that I know works for conversion. Sometimes having a <PER> (periodicity) field can help if there for example gaps in the data. Code:<TICKER>,<PER>,<DTYYYYMMDD>,<TIME>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>,<OPENINT>
AAPL,D,20160503,000000,94.2000,95.7400,93.6800,95.1800,568312,0
AAPL,D,20160504,000000,95.2000,95.9000,93.8200,94.1900,410254,0
AAPL,D,20160505,000000,94.0000,94.0700,92.6800,93.2400,358905,0
AAPL,D,20160506,000000,93.3700,93.4500,91.8500,92.7200,436998,0
AAPL,D,20160509,000000,93.0000,93.7700,92.5900,92.7900,329364,0
AAPL,D,20160510,000000,93.3300,93.5700,92.1100,93.4200,336868,0
AAPL,D,20160511,000000,93.4800,93.5700,92.4600,92.5100,287191,0
AAPL,D,20160512,000000,92.7200,92.7800,89.4700,90.3400,763146,0
AAPL,D,20160513,000000,90.0000,91.6700,90.0000,90.5200,443927,0
AAPL,D,20160516,000000,92.3900,94.3900,91.6500,93.8800,612597,0
AAPL,D,20160517,000000,94.5500,94.7000,93.0100,93.4900,469169,0
AAPL,D,20160518,000000,94.1600,95.2100,93.8900,94.5600,420623,0
AAPL,D,20160519,000000,94.6400,94.6400,93.5700,94.2000,304421,0
AAPL,D,20160520,000000,94.6400,95.4300,94.5200,95.2200,320259,0
AAPL,D,20160523,000000,95.8700,97.1900,95.6700,96.4300,380186,0
AAPL,D,20160524,000000,97.2200,98.0900,96.8400,97.9000,351401,0
AAPL,D,20160525,000000,98.6700,99.7400,98.1100,99.6200,386421,0
AAPL,D,20160526,000000,99.6800,100.7300,98.6400,100.4100,563311,0
AAPL,D,20160527,000000,99.4400,100.4700,99.2450,100.3500,363412,0
AAPL,D,20160531,000000,99.6000,100.4000,98.8200,99.8600,423072,0
AAPL,D,20160601,000000,99.0200,99.5400,98.3300,98.4600,291732,0
AAPL,D,20160602,000000,97.6000,97.8400,96.6300,97.7200,401916,0
AAPL,D,20160603,000000,97.7900,98.2700,97.4500,97.9200,285048,0
AAPL,D,20160606,000000,97.9900,101.8900,97.5500,98.6300,232925,0
AAPL,D,20160607,000000,99.2500,99.8700,98.9600,99.0300,224094,0
AAPL,D,20160608,000000,99.0200,99.5600,98.6800,98.9400,208481,0
AAPL,D,20160609,000000,98.5000,99.9900,98.4600,99.6500,266013,0
AAPL,D,20160610,000000,98.5300,99.3457,98.4800,98.8300,317129,0
AAPL,D,20160613,000000,98.6900,99.1200,97.1000,97.3400,380204,0
ABBV.K,D,20160503,000000,60.9900,62.0900,60.7200,61.7700,93165,0
ABBV.K,D,20160504,000000,61.3000,61.6500,61.0100,61.4600,86913,0
ABBV.K,D,20160505,000000,61.4100,62.3950,61.0900,62.3400,86461,0
ABBV.K,D,20160506,000000,62.0000,62.7450,61.6500,62.5100,108807,0
ABBV.K,D,20160509,000000,62.3600,63.8700,62.2802,63.7000,99174,0
ABBV.K,D,20160510,000000,63.5100,63.7600,63.3225,63.7400,121033,0
ABBV.K,D,20160511,000000,63.7700,63.8250,62.6400,62.7000,93751,0
ABBV.K,D,20160512,000000,62.8600,63.0700,62.3890,62.4900,95894,0
ABBV.K,D,20160513,000000,62.1500,62.8600,61.8215,62.0000,73395,0
ABBV.K,D,20160516,000000,61.9100,62.6200,61.5000,62.4500,67074,0
ABBV.K,D,20160517,000000,62.4400,62.7899,58.5000,60.2500,315289,0
ABBV.K,D,20160518,000000,59.8700,60.8000,59.5600,60.4600,106220,0
ABBV.K,D,20160519,000000,60.0600,60.3500,58.9000,59.2800,99179,0
ABBV.K,D,20160520,000000,59.6300,60.0500,59.0300,59.6900,112593,0
ABBV.K,D,20160523,000000,59.7500,59.8400,59.1300,59.3000,64689,0
I am happy to try and help troubleshoot the issue here, but it might be quicker to contact our support team directly. You can even email an attached sample of the file you are converting and we can then more easily test this to see where the problem is.
|