asked on

Formatting FO

Hi Experts,

I have one file which downloads data from web and formatted. Need to modification in code for I guess two lines. in context of this question.
in above link

Above is my existing code need to add more steps which below listed.
Step 1 Add this text in Cell P1 "Ticker,Date,Open,High,Low,Close,Volume,OI"
Step 2 Add this formula in cell P2 "=IF(OR(A2="FUTSTK",A2="FUTIDX"),B2&" "&C2&","&TEXT(O2,"DD-MMM-YY")&","&F2&","&G2&","&H2&","&I2&","&K2&","&M2,IF(OR(A2="OPTIDX",A2="OPTSTK"),B2&" "&C2&" "&D2&" "&E2&","&TEXT(O2,"DD-MMM-YY")&","&F2&","&G2&","&H2&","&I2&","&K2&","&M2,""))" and formula drop down till end.

I need to change Step 1 from Ticker,Date,Open,High,Low,Close,Volume,OI to <TICKER>,<DATE>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>,<OPENINT>

& Step 2 From TEXT(O2,"DD-MMM-YY") - TEXT(O2,"DD-MMM-YY") to TEXT(O2,"YYYYMMDD") - TEXT(O2,"YYYYMMDD")

Above link is very 1st phase of this formatting but after that many thing amended and added.
in attached I am refereeing Cell A6 & A7 Button which is Future and Option.

Thanks
Incoporated-Download-File-V23.xlsm

Naresh Patel

ASKER

Basically Needed output in both the instance bit different. see attached .txt files.

Thanks
F-O-Old.txt
F-O-New.txt

Jacques Geday

ok here are some questions:

1) In the formula there is nothing such as
TEXT(O2,"DD-MMM-YY") - TEXT(O2,"DD-MMM-YY") ....

but rather
TEXT(O2,""DD-MMM-YY"")

there is no substraction !!! ( - ) between 2 dates.

2) In the routine CreateTXT this is where I suppose we need to make the change it affect all of
"Future" ---> Button A6
"Options" ---> Button A7
"Future & Options" ---> Button A10
Are all 3 subject to the change ?

gowflow

Naresh Patel

ASKER

Yes there is no subtraction between two dates .I had separated for show that there is two instance in formula.
if this the case TEXT(O2,""DD-MMM-YY") then change to TEXT(O2,""YYYYMMDD")

Yes Chang to all 3

Thanks

ASKER CERTIFIED SOLUTION

Jacques Geday

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Naresh Patel

ASKER

End Of Phase One. There Is More Of Back Testing And Prediction On Phase 2. Totally Based On Excel Only. It Will Be Highly Appreciated If You Be A Part Of It. May Be From Next Week.

Thanks

Jacques Geday

Your welcome.
gowflow

Naresh Patel

ASKER

Knock Knock need little modification in existing incorporated download file ..may I ?

Jacques Geday

Sure let me know what is the link of the question
gowflow

Naresh Patel

ASKER

may I now?

Naresh Patel

ASKER

Here It Is.

Thanks

Naresh Patel

ASKER

please help me out on above link.

Thanks