freelanceprogrammers.org Forum Index » Perl

View previous topic :: View next topic

Help requested

rakeshsahgal Posted: Tue Jun 08, 2004 6:29 pm

Joined: 08 Jun 2004

Posts: 2

Help requested

Hi Group,

I need help in modifying data files that are created on my PC by the
data feed I get from my stock broker.

These files are text files in csv format. What I want to accomplish
is:

1. Rename the file - Each file name has 3 constituents. The stock
exchange ticker- this is unique to each stock, constant and never
changes. The second part is the category the stock is placed in by the
exchange - this doesnt change daily but can change any time(plus there
3 categories the stock exchnage uses). The third part is a numeric
code assigned to each file by the broker`s java program sitting on my
hard disk and changes daily. I want to remove the second and third
parts, and assign the stock exchange ticker as the file name.

An example of the file name is given below:

AJANTPHARMEQ10458 - the name therefore consists of

AJANTPHARM(ticker) + EQ(category code - this can be any of the 3 types
the stock exchange uses) + 10458(numeric code assigned by the broker`s
data feed).

2. After having completed the first task I want to then insert the
ticker/symbol in the begining of each row in the file.

The data in the file is in the following format:

20040607.100607, 95, 20000
20040607.100708, 94, 25000

The first data item in each row is the date and time in the
format(yyyymmdd.hhmmss), the second is the price and the third -
volume. There are no headers in the file.

My questions are:

1. Is this do-able in perl? I am assuming since these are text files
it should be, but given the fact that my knowledge of programming is
equal to zero I will appreciate someone knowledgeable guiding me on
this.

2. If do-able , can someone please guide me as to the commands etc I
should look at to achieve the desired result.

Thanks in advance for any help.

Regards

RS

freelanceprogrammers.org Forum Index » Perl

All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Freelace Website Designer - Customer web design and software building.
Booking Calendar - reservation calendar script
Land Surveying - total station instruments and equipments
China Wholesale - Electronics Products
Character Studio - Tutorials and Help