MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

extracting subset of data in csv file

  Asked By: Kehkashan    Date: Jan 09    Category: MS Office    Views: 2524

I request your expertise in simplifying my work.

Daily I would get the End of day bhavcopy from the exchange which is a
.csv file. The first column contains the column heads like name, open
price etc. and the first column. Now I have to extract the names and the
corresponding column values from this list by referring to a notepad
that contains the ticker names to be extracted, place in another
workbook and save that file.

I wish the requirement is clear and request for members help in this regard.



2 Answers Found

Answer #1    Answered By: Noah Evans     Answered On: Jan 09

I am not sure if I understood well, but it seems that you are trying
to recover stocks end of the day quotes.
Is that it?
If you live in North America, why don't you simply use a WebQuery
(the MSM webquery works great), that will bring the requested tickers
directly into your workbook.
If you do not live in North America, you could probably create
another Webquery of your own.
If I understood you right, tell me and I could tell you more about
how to do that.

Answer #2    Answered By: Candace Foster     Answered On: Jan 09

thanks for the reply, here is what i am trying to do in gist.

suppose i have 4 columns of data in A, B, C and D. the first row
contains headings as name, tradedate, expirydate and closeprice. the
first column contains (under name) security name. i have data like this
running upto 150 rows. now i would like to do is

a) extract few rows of data from the sheet into new sheet by referencing
to names in another notepad.

b) create another column named as symbol based on the values of
tradedate and expirydate and name columns and append to the data file.

c) delete the column expirydate.

i live in India, and the two prominent commodity exchanges here are
NCDEX and MCX. they publish End of Day data everyday and but we need to
do something additional so that is can be updated to metastock for
analysis. i am trying to create a macro that automates this process and
once done will be very helpful for many of the traders overhere.

Didn't find what you were looking for? Find more on extracting subset of data in csv file Or get search suggestion and latest updates.