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 PatelTraderAsked:
Who is Participating?
 
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
 
Naresh PatelTraderAuthor Commented:
Working Perfect As Expected.

Thanks
0
 
Naresh PatelTraderAuthor Commented:
May I ask last request on this WB?
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
gowflowCommented:
yes pls
0
 
Naresh PatelTraderAuthor Commented:
May Now Post Link?
0
 
gowflowCommented:
yes go ahead.
gowflow
0
 
Naresh PatelTraderAuthor Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.