Link to home
Start Free TrialLog in
Avatar of Naresh Patel
Naresh PatelFlag for India

asked on

Del Formatting

Hi Experts,

I have One WB which downloads files from web, need to add some procedure after downloading on those files.
I am describing Step by step
1 Delete first 3 rows
2 Delete rows which have other than "BE" & "EQ" in column D except Header.
3 Next File till Last file.

See attached WB

Thanks
Del-D-V01.xlsm
Avatar of Michael Fowler
Michael Fowler
Flag of Australia image
I can help with the macro but the site for example http://nseindia.com/archives/equities/mto/MTO_29122014.dat does not return data for me (I suspect you need an account) and so I cannot see the data returned

Could you post an example with the data input from the current macro
Avatar of Naresh Patel
Naresh Patel
Flag of India image

ASKER

here is the sample files ....attaching 3.

My files location is "D:\AmiBroker Data\NSE\Del"

it is free site I don't know why it does not return to data. may be for different location it may required account.

Thanks
23122014.csv
24122014.csv
26122014.csv
ASKER CERTIFIED SOLUTION
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Naresh Patel
Naresh Patel
Flag of India image

ASKER

Perfect - May Carry On With New Question?

Thanks
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image
Yes pls do
gowflow
Avatar of Naresh Patel
Naresh Patel
Flag of India image

ASKER

Here it is Incorporate Eq - Del.

Thanks