logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Pawelpipi  
#1 Posted : Sunday, May 19, 2024 10:16:28 AM(UTC)
Pawelpipi

Rank: Newbie

Groups: Registered, Registered Users
Joined: 1/7/2008(UTC)
Posts: 4

Was thanked: 1 time(s) in 1 post(s)

Hello all,

I am trying to download from text file multiple security data for multiple days using Downloader (EOD data). I have a problem with that. There is a message "Multiple source securities are mapped to the same destination location..." and I can't proceed with this download.

When I download a file for multiple securities for only one day there is no problem.

How can I fix txt file format or make it possible by other means to download security data for more than one day?

Thank You for Supprt,

Pawel

​​​​​​​ 

MS Support  
#2 Posted : Tuesday, May 21, 2024 2:32:16 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,945

Thanks: 88 times
Was thanked: 155 time(s) in 150 post(s)
Originally Posted by: Pawelpipi Go to Quoted Post

Hello all,

I am trying to download from text file multiple security data for multiple days using Downloader (EOD data). I have a problem with that. There is a message "Multiple source securities are mapped to the same destination location..." and I can't proceed with this download.

When I download a file for multiple securities for only one day there is no problem.

How can I fix txt file format or make it possible by other means to download security data for more than one day?

Thank You for Supprt,

Pawel

​​​​​​​ 

Hello,

Which version of Downloader are you using? (You can see this inside the Downloader via Help > About). Also to clarify, are you trying to Convert data from a TXT/CSV into one of the MetaStock data formats? If so, are you converting 1 file that contains multiple securities, or multiple files that contain one security?

Pawelpipi  
#3 Posted : Wednesday, May 22, 2024 8:31:40 PM(UTC)
Pawelpipi

Rank: Newbie

Groups: Registered, Registered Users
Joined: 1/7/2008(UTC)
Posts: 4

Was thanked: 1 time(s) in 1 post(s)

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.

MS Support  
#4 Posted : Thursday, May 23, 2024 2:42:59 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,945

Thanks: 88 times
Was thanked: 155 time(s) in 150 post(s)
Originally Posted by: Pawelpipi Go to Quoted Post

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.

Pawelpipi  
#5 Posted : Friday, May 24, 2024 5:35:40 AM(UTC)
Pawelpipi

Rank: Newbie

Groups: Registered, Registered Users
Joined: 1/7/2008(UTC)
Posts: 4

Was thanked: 1 time(s) in 1 post(s)

Hi, 

Data downloaded looks like below (small sample). 

<TICKER>,<PER>,<DATE>,<TIME>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>,<OPENINT> AG.US,D,20240521,000000,7.87,7.9,7.54,7.64,10496076,0 AI.US,D,20240521,000000,26.24,26.36,25.78,26.15,3576863,0 BHP.US,D,20240521,000000,61.69,62.28,61.435,61.63,1787981,0 CCJ.US,D,20240521,000000,53.56,54.9299,53.3,53.73,3581119,0 AG.US,D,20240522,000000,7.53,7.55,7.17,7.21,9185651,0 AI.US,D,20240522,000000,26.04,26.2,24.815,24.88,4622180,0 BHP.US,D,20240522,000000,61.29,61.29,58.665,58.73,3621354,0 CCJ.US,D,20240522,000000,53.46,53.58,51.85,52.14,3540216,0

To me there seems no difference then example that you have provided, maybe in the  DATE hedder. 

I tried also grupping the data in the file per ticker but there was the same problem.

Sincerely,

Pawel.

I will contact support team directly then.

thanks 1 user thanked Pawelpipi for this useful post.
MS Support on 5/24/2024(UTC)
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.