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

Notification

Icon
Error
MSDOWNLOADER DATA COPYING PROBLEM - EXCEL TO MSDOWNLOADER
Options
Go to last post Go to first unread
Previous Topic Next Topic
JONESTOCK  
#1 Posted : Thursday, January 15, 2015 10:02:56 PM(UTC)
JONESTOCK

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 1/14/2015(UTC)
Posts: 19

Thanks: 4 times

Hello everyone,

While i try to copy data  from excel to msdownloader the downloader automatically converts the number to an upper non digit value,  lets say the close value is 44,250 in excel  i copy/paste this number to the downloader security data page and then the number becomes 45 000 ,  O H L C values always beacomes a single value.. Can anyone help me solve this problem? For example the numbers in excel the O : 43,240 H: 43,500 l: 43200 c: 43,300 becomes 43 43 43 43 for all 4 variable... What am doing wrong?..

 

Thanks..
Back to top

Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.
Back to top  
MS Support  
#2 Posted : Tuesday, January 20, 2015 8:45:50 PM(UTC)
MS Support

Rank: Advanced Member

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

Thanks: 91 times
Was thanked: 155 time(s) in 150 post(s)
The data sheet should not be rounding numbers to my knowledge. Does the problem occur within a new data sheet in The DownLoader? You may need to try performing a Tools-->Convert instead if this continues to persist instead of Copy/Pasting. You might also need to confirm the format of the column of data in Excel to make sure it is in the proper format type.
Back to top
JONESTOCK  
#3 Posted : Friday, January 23, 2015 10:32:50 PM(UTC)
JONESTOCK

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 1/14/2015(UTC)
Posts: 19

Thanks: 4 times

 

Well unfortunatly it rounds the numbers... This is maybe because of copy/paste situation as you mentioned... 

I also tried converting but could not succeed it, it always gave error.  For conversion MS rules dates to be DD/MM/YEAR format in excel but again my damn excel doest support such format for date ...

 

 if it would not be discomfort you , i could send you my excel data which i cant convert . I would appreciate it much.. 


Thank you very much for your kind interest...
Back to top
JONESTOCK  
#4 Posted : Friday, January 23, 2015 10:36:21 PM(UTC)
JONESTOCK

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 1/14/2015(UTC)
Posts: 19

Thanks: 4 times
DATE HOUR OPEN HIGH LOW CLOSE VOLUME 04.01.2012 15:20:00 63,1 63,25 63,075 63,225 3209 04.01.2012 15:25:00 63,225 63,25 63,125 63,2 1697 04.01.2012 15:30:00 63,225 63,375 63,2 63,35 2386 04.01.2012 15:35:00 63,325 63,35 63,3 63,325 969 04.01.2012 15:40:00 63,325 63,35 63,3 63,35 1165 04.01.2012 15:45:00 63,35 63,475 63,325 63,375 2081 04.01.2012 15:50:00 63,375 63,375 63,125 63,125 3633 04.01.2012 15:55:00 63,15 63,15 62,9 62,95 7162 04.01.2012 16:00:00 63 63,125 62,95 63,1 2333 This is a sample of how it looks like in excel sheet...
Back to top
MS Support  
#5 Posted : Friday, January 23, 2015 10:41:48 PM(UTC)
MS Support

Rank: Advanced Member

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

Thanks: 91 times
Was thanked: 155 time(s) in 150 post(s)
In re-reading your original post it might be a different issue than I originally thought. Do you know what your Regional Format in Windows is? You can go to the Control Panel and access the Region and Language section and see what language you have listed on the "Format" tab.
Back to top
JONESTOCK  
#6 Posted : Friday, January 23, 2015 10:42:48 PM(UTC)
JONESTOCK

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 1/14/2015(UTC)
Posts: 19

Thanks: 4 times
01/01/1800 15:20:000 63.0000 63.0000 63.0000 63.0000 3209
01/01/1800 15:25:000 63.0000 63.0000 63.0000 63.0000 1697
01/01/1800 15:30:000 63.0000 63.0000 63.0000 63.0000 2386
01/01/1800 15:35:000 63.0000 63.0000 63.0000 63.0000 969
01/01/1800 15:40:000 63.0000 63.0000 63.0000 63.0000 1165
01/01/1800 15:45:000 63.0000 63.0000 63.0000 63.0000 2081
01/01/1800 15:50:000 63.0000 63.0000 63.0000 63.0000 3633
01/01/1800 15:55:000 63.0000 63.0000 62.0000 62.0000 7162
01/01/1800 16:00:000 63.0000 63.0000 62.0000 63.0000 2333

AND THIS IS THE OUTCOME OF COPY PASTE 
Back to top
JONESTOCK  
#7 Posted : Friday, January 23, 2015 10:48:35 PM(UTC)
JONESTOCK

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 1/14/2015(UTC)
Posts: 19

Thanks: 4 times

OH YEEEEEEEEES!

 

THANK YOU VERY MUCH MS SUPPORT... 

 

ITS BASICALLY A WINDOWS REGION FORMAT PROBLEM...

 

I DID IT..

 

NOW IT WORKS...
Back to top
MS Support  
#8 Posted : Friday, January 23, 2015 10:51:51 PM(UTC)
MS Support

Rank: Advanced Member

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

Thanks: 91 times
Was thanked: 155 time(s) in 150 post(s)
The problem likely has to do with using commas as a digit grouping and possibly might relate to Turkey as a regional setting (other regions also have this issue).

I don't think you will be able to perform a direct copy and paste in this situation, but we should be able to figure out why a Tools-->Convert is failing and help with this. We would need to get a sample of the actual Excel file and we can figure out what needs to change in order to use the Convert function.

 

Edit: Or you could possibly change to English (United States) in the Regional Format to work around the issue.

Edited by user Friday, January 23, 2015 10:53:37 PM(UTC)  | Reason: Not specified
Back to top
JONESTOCK  
#9 Posted : Friday, January 23, 2015 11:07:20 PM(UTC)
JONESTOCK

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 1/14/2015(UTC)
Posts: 19

Thanks: 4 times

Well now i created a new security.. copied 3 years of intraday data and pasted in this securites downloader sheet .. waiting to see a real chart as it in happened in the past... Since my aim is backtesting my system the exact intraday hour is not importan , just the graph should look like at it happened in the past so that my test will give me the real overall...
Back to top
JONESTOCK  
#10 Posted : Friday, January 23, 2015 11:15:34 PM(UTC)
JONESTOCK

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 1/14/2015(UTC)
Posts: 19

Thanks: 4 times

By the way, since i catch you right now, can i ask you another problem of DIVISION ZERO RELATED problem..

 

Is there a way to overcome the problem of division zero related problem appearing each time i open a template ? Although there is no problem and i am okey with my template  i become obliged to close tens of such error messages... Is there a way to silence this ERROR MESSAGE forever? It consumes to much time for me..
Back to top
MS Support  
#11 Posted : Friday, January 23, 2015 11:20:45 PM(UTC)
MS Support

Rank: Advanced Member

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

Thanks: 91 times
Was thanked: 155 time(s) in 150 post(s)
Unfortunately there is not any way to permanently suppress the messages at this time. This has been written up as an enhancement request for the software although I do not know if/when this would change.

 

There are other topics on how you can sometimes avoid the messages programmatically, such as:

http://forum.metastock.com/Discussions/g/posts/t/147998/Miscellaneous--How-to-handle-a--divide-by-zero--error#post147998

Edited by user Friday, January 23, 2015 11:21:35 PM(UTC)  | Reason: Not specified
Back to top
JONESTOCK  
#12 Posted : Friday, January 23, 2015 11:21:40 PM(UTC)
JONESTOCK

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 1/14/2015(UTC)
Posts: 19

Thanks: 4 times

Okey it took about more than 5 minutes for copypasting for downloader but it worked , now i see exactly the graph of 3 years...

 

Thank you again MS SUPPORT...
Back to top
mstt  
#13 Posted : Saturday, January 24, 2015 12:32:47 AM(UTC)
mstt

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042

Was thanked: 57 time(s) in 54 post(s)
Hi JONESTOCK With regard to "Division by Zero" error, the fix is to change the line (or lines) of code causing the problem so that they no longer create the error and hence the error message window. If the templates you're referring to are password protected then there's not much you can do except report the problem to MetaStock (as it seems you have already done). If the template code is accessible then it should be relatively easy to spot the offending denominator by looking at the code expression immediately a division operator, /, which is also called a forward slash. Suppose that "X" is the problem denominator, then it can be changed from "X" to "If(X=0,0.0001,X)". Over time I've found that a substitute value of 1, rather than 0.0001, works just as well. However, it does pay to check the results of the original code against the modified version. Most MetaStock code can be copied from an expert, system or exploration into a <New Indicator>, and then tested against the modified code, say <New Indicator>(2). Plotting these two indicators in the same window on a suitable test chart will quickly tell you if the revised code produces a result that is acceptable. Be aware that each MetaStock tool has one or two unique functions that cannot be transferred to another tool. Examples of this are the OPT function for the Enhanced System Tester, and the Input() function for the Indicator Builder. If you cannot solve your problem but do have access to the misbehaving code then post that code and someone should be able to provide an answer. Roy
Back to top
thanks 1 user thanked mstt for this useful post.
JONESTOCK on 1/24/2015(UTC)
JONESTOCK  
#14 Posted : Saturday, January 24, 2015 10:30:59 PM(UTC)
JONESTOCK

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 1/14/2015(UTC)
Posts: 19

Thanks: 4 times

 Thanks roy i just saw your message, when i focus on this issue again i will in contact with you.. Right now i have to deal with  other issues.. Thanks again..
Back to top
Users browsing this topic
Guest (Hidden)
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.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET