Discussions
»
Product and Service Development
»
Data Related Questions
»
Create New Security in Downloader Problem with decimal in copy-paste
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 4/29/2012(UTC)
Posts: 3
|
Hi all,
I created a 'New security' with the Downloader to upload intraday data for a stock. When I copy-paste the data from the excel file (xls), the date and time are correctly pasted, but the price of the stock although in the excel has two decimals, when I paste it in the metastock it does not paste is correctly since it omits the decimals.
For example, in the excel the value of the 'Close' price is 20,08 I 'copy' it and then I go to the window of the security in Downloader, I paste it in column 'Close' and 20,0000 appears. It omits the decimals. I changed the format of the 20,08 in the excel I tried, number, text, general etc but it does not work. However, when I manually input the price of 20,08 in the Security window in Downloader, it accepts all decimals.
Does anybody know the reason it does not work in the copy-paste?
A quick response would be appreciated.
Thanks in advance.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,941
Thanks: 85 times
Was thanked: 155 time(s) in 150 post(s)
|
I suspect the cause is the symbol used for the decimal. some how, when pasting, the comma is being seen as a thousands separator instead of the decimal separator. If you change decimal symbol to a period, it may resolve the issue.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Data Related Questions
»
Create New Security in Downloader Problem with decimal in copy-paste
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.
