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

Notification

Icon
Error

Options
Go to last post Go to first unread
hrgwea  
#1 Posted : Thursday, February 21, 2013 6:29:55 PM(UTC)
hrgwea

Rank: Newbie

Groups: Registered, Registered Users
Joined: 2/21/2013(UTC)
Posts: 1

Is there a way to import price adjustments from a text file (ascii format)?

Sometimes you have to apply adjustments factors on many different dates for a given security, and it's really tedious to do all that by hand. Is it possible to import everything from a text file?

wabbit  
#2 Posted : Thursday, February 21, 2013 6:56:18 PM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
The easiest way which comes to mind is to get a better data provider who does the error-free for you. The second way, is to copy the data to Excel or similar, and then use a VBA script to make the changes to the data. Because we don't natively have the ability to write back to the same MS data file, you'll have to save the amended data as a new file and the use the Downloader to convert that file to replace the existing MS data. wabbit [:D]
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.