Nse Eod Data 02/11/2007

[madhukar]

Hi
I am travelling now. I will send the micro as soon as I reach home.
Bye

 

[doctorrahul]

Daily Nse Eod Data

nse eod data for 16/11/2007 zipped.

 

[S N Bajpai]

Dear Madhukar,
Greetigs, I am a new member. Will much appreciate if you pl send me your micro program for converting nsebhavcopy to metastock format.

 

[madhukar]

Hi
Sorry for delay in sending the micro program.
I am pasting the program below.
Step 1 Just open the nsebhavcopy in xl
Step 2 Run the following micro
Sub metastock()
'
' metastock Macro
' Macro recorded 11/11/2007 by M S BOTE
'
' Keyboard Shortcut: Ctrl+m
'
Range("K1:K1169").Select
Selection.NumberFormat = "m/d/yyyy"
Selection.Cut
Range("B1").Select
ActiveSheet.Paste
Range("G1").Select
Selection.EntireColumn.Delete
Selection.EntireColumn.Delete
Range("H1").Select
Selection.EntireColumn.Delete
Range("A1").Select
Selection.EntireRow.Delete
End Sub
Step 3 The file is ready for metastock format
Step 4 The no 1169 is the no of shares listed on NSE
Step 5 Give me the call if you need any other info.
Thanks & Bye
Madhukar S. Bote
[email protected]

 

[S N Bajpai]

Dear Madhukar,
Many Thanks to you and to traderji.com. I am not very computer literate. But no problem.Thanks again for the open offer to approach you if further guidance is required.
Beat Regards and bye for now. Bajpai

 

[macieman]

Hi Madhukar,

Please send me the macro in Excel, to my email macieman@**********

Thanks in Advance

Mohan