Formatting Index

Hi Experts,

  I have one file which download data from web and format that data. need to add few more step in existing button "Index" after all process done.

  Step 1 In  .csv file - cell P1 past this text "<TICKER>,<DATE>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>"
 Step 2 in cell P2 past this formula till end =A2&","&TEXT(B2,"YYYYMMDD")&","&C2&","&D2&","&E2&","&F2&","&I2"
  Step 3 Copy column P and past to new open .txt file and save as .csv file name
  Step 4 Delete original .csv file
  Step 5 Next .csv
  END

  Version 22 File

  Thanks
iNDEX-CSV.xlsx
LVL 8
Naresh PatelFinancial AdviserAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gowflowCommented:
ok I presume you forgot to post your file just mentioned it. But having worked already on all of this project I have the latest file.

As I did a lot of modifications to adapt this routine it is better to upload the whole file.

Pls check this version for Index and advise if all ok.

gowflow
Incoporated-Download-File-V23.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Naresh PatelFinancial AdviserAuthor Commented:
Working Perfect As Expected.

Thanks
0
Naresh PatelFinancial AdviserAuthor Commented:
May I ask last request on this WB?
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

gowflowCommented:
yes pls
0
Naresh PatelFinancial AdviserAuthor Commented:
May Now Post Link?
0
gowflowCommented:
yes go ahead.
gowflow
0
Naresh PatelFinancial AdviserAuthor Commented:
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.