problem copy/paste excel data to security file in downloader

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

Notification

Error

problem copy/paste excel data to security file in downloader - problem copy/paste excel data to security file in downloader

Options

Previous Topic Next Topic

Leclere		#1 Posted : Thursday, September 29, 2011 3:55:54 AM(UTC)
Rank: Newbie Groups: Registered, Registered Users, Subscribers Joined: 9/29/2011(UTC) Posts: 3		Hi, I am using MS 11.0, Vista and Excel 2003. My regional settings are programmed as following: decimal = , thousands separator = . When I copy/paste a excel cell (formated as a "number" with 4 decimals)( ex: 4,5214) to a cell of a file in the Downloader, the 4 decimals are converted to zero in the Downloader (ex:4,000) Why? If the format of the excel cell is changed to "text" or "standard" (instead of "number") in excel, the result in the Downloader file is the same, i.e. 4,000 (instead of 4,5214) A change in the regional settings (decimal = . and thousands separator = ,) doesn't help: 4.5214 in excel is then converted to 45,214.00 in the Downloader ... Can you please help?


User Profile View All Posts by User View Thanks


	Wanna join the discussion?! Login to your Discussions forum account or Register a new forum account.

MS Support		#2 Posted : Friday, October 14, 2011 2:10:08 PM(UTC)
Rank: Advanced Member Groups: Moderators, Registered, Registered Users, Subscribers Joined: 10/8/2010(UTC) Posts: 1,960 Thanks: 92 times Was thanked: 155 time(s) in 150 post(s)		Which field are you pasting the data into? Open, High, Low, and Close data will accept decimal values. However Volume and Open Interest are expected to have no decimal components.


User Profile View All Posts by User View Thanks

Leclere		#3 Posted : Wednesday, October 19, 2011 8:17:23 AM(UTC)
Rank: Newbie Groups: Registered, Registered Users, Subscribers Joined: 9/29/2011(UTC) Posts: 3		tks for your reply. I paste into the close cell.


User Profile View All Posts by User View Thanks

MS Support		#4 Posted : Wednesday, November 2, 2011 1:36:28 PM(UTC)
Rank: Advanced Member Groups: Moderators, Registered, Registered Users, Subscribers Joined: 10/8/2010(UTC) Posts: 1,960 Thanks: 92 times Was thanked: 155 time(s) in 150 post(s)		I'm sorry but I have been unable to replicate the issue you are describing. If possible, please call or chat with our support staff. They have a tool which will allow you to share your screen with them so we may observe this and find a resolution.


User Profile View All Posts by User View Thanks

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.