nishant123
New Member
- Joined
- Jan 17, 2011
- Messages
- 2
I have a set of data in note pad which gets revised every day and it keeps on updating on the regular basis as and when things are done live i will post a set of data here .Following are the three set of examples:
51065778,11,OPTSTK,SBIN ,27JAN2011, 2650.00,CE,SBIN11JAN2650CE ,1 ,RL ,1 ,PROP1,1 ,2,125 , 54.15,2,10975 ,10975 ,OPEN ,UNCOVER,10 JAN 2011 14:06:34,10 JAN 2011 14:06:34,2011011056238489,Nil ,10 JAN 2011 14:06:34
51085671,11,OPTSTK,RELIANCE ,27JAN2011, 1060.00,CE,RELIANCE11JAN1060CE ,1 ,RL ,1 ,PROP1,1 ,2,250 , 18.60,2,10975 ,10975 ,OPEN ,UNCOVER,10 JAN 2011 14:09:23,10 JAN 2011 14:09:23,2011011056338929,Nil ,10 JAN 2011 14:09:23
50288150,11,FUTSTK,SBIN ,27JAN2011, , ,SBIN11JANFUT (Script name) ,1 ,RL ,1 ,PROP1,1 ,1(here 1 means bot),125(here 125 is the number of shares) , 2648.95( here this is the rate),2,10975 ,10975 ,OPEN ,UNCOVER,10 JAN 2011 10:16:46,10 JAN 2011 10:16:46,2011011051737593,Nil ,10 JAN 2011 10:16:46
these are the 3 data from so there is a list of all such things and many more so from the above list if i want to get only SBIN11JANFUT ie the SBIN thing might change there are 255 other company names also, so the thing is 11JANFUT is common in all so as and when i do the companys trade then i want a macro that should update it saying (considering that i want the data from the 3rd sample) i would like to have No.of shares then rate then scriptname and if its buy is should go on the left side ie this is the Excel type i want it in.:
<table class="MsoTableGrid" style="border: medium none ; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 13.5pt;"> <td style="border: 1pt solid black; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: solid solid solid none; border-color: black black black -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: solid solid solid none; border-color: black black black -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> </td> <td style="border-style: solid solid solid none; border-color: black black black -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: solid solid solid none; border-color: black black black -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: solid solid solid none; border-color: black black black -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: solid solid solid none; border-color: black black black -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> </td> <td style="border-style: solid solid solid none; border-color: black black black -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> </tr> <tr style="height: 13.5pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="]Qty<o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="]Traded rate<o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="]Qty<o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="]Traded rate<o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> </td> </tr> <tr style="height: 13.5pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o
></o
>[/FONT]
</td> </tr> <tr style="height: 13.5pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o
></o
>[/FONT]
</td> </tr> <tr style="height: 13.5pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o
></o
>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o
></o
>[/FONT]
</td> </tr> </tbody></table> <o
> </o
>
So if bought then should go on the buy side and if sold should go on the sell side.so it should give the Qty ,The rate and then the name doe the Stock (Srcip ie companies name ) p/l is for my purpose that will give me my profit \loss on real time basis so my data is updating on real time basis .
So i need a macro which gets the data i want and feeds it and remember if new stock name is added then it should not over write the first one .So please help me on this one .
51065778,11,OPTSTK,SBIN ,27JAN2011, 2650.00,CE,SBIN11JAN2650CE ,1 ,RL ,1 ,PROP1,1 ,2,125 , 54.15,2,10975 ,10975 ,OPEN ,UNCOVER,10 JAN 2011 14:06:34,10 JAN 2011 14:06:34,2011011056238489,Nil ,10 JAN 2011 14:06:34
51085671,11,OPTSTK,RELIANCE ,27JAN2011, 1060.00,CE,RELIANCE11JAN1060CE ,1 ,RL ,1 ,PROP1,1 ,2,250 , 18.60,2,10975 ,10975 ,OPEN ,UNCOVER,10 JAN 2011 14:09:23,10 JAN 2011 14:09:23,2011011056338929,Nil ,10 JAN 2011 14:09:23
50288150,11,FUTSTK,SBIN ,27JAN2011, , ,SBIN11JANFUT (Script name) ,1 ,RL ,1 ,PROP1,1 ,1(here 1 means bot),125(here 125 is the number of shares) , 2648.95( here this is the rate),2,10975 ,10975 ,OPEN ,UNCOVER,10 JAN 2011 10:16:46,10 JAN 2011 10:16:46,2011011051737593,Nil ,10 JAN 2011 10:16:46
these are the 3 data from so there is a list of all such things and many more so from the above list if i want to get only SBIN11JANFUT ie the SBIN thing might change there are 255 other company names also, so the thing is 11JANFUT is common in all so as and when i do the companys trade then i want a macro that should update it saying (considering that i want the data from the 3rd sample) i would like to have No.of shares then rate then scriptname and if its buy is should go on the left side ie this is the Excel type i want it in.:
<table class="MsoTableGrid" style="border: medium none ; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 13.5pt;"> <td style="border: 1pt solid black; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: solid solid solid none; border-color: black black black -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: solid solid solid none; border-color: black black black -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
[FONT="]BUY<o
></o
>[/FONT]


</td> <td style="border-style: solid solid solid none; border-color: black black black -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: solid solid solid none; border-color: black black black -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: solid solid solid none; border-color: black black black -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
[FONT="]Sell<o
></o
>[/FONT]


</td> </tr> <tr style="height: 13.5pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="]Qty<o


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="]Traded rate<o


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
[FONT="]Stock<o
></o
>[/FONT]


[FONT="]P/L<o
></o
>[/FONT]




</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="]Traded rate<o


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
[FONT="]Stock<o
></o
>[/FONT]


[FONT="]P/L<o
></o
>[/FONT]


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o


</td> </tr> <tr style="height: 13.5pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o


</td> </tr> <tr style="height: 13.5pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o


</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; height: 13.5pt;" nowrap="nowrap" valign="top"> [FONT="] <o


</td> </tr> </tbody></table> <o


So if bought then should go on the buy side and if sold should go on the sell side.so it should give the Qty ,The rate and then the name doe the Stock (Srcip ie companies name ) p/l is for my purpose that will give me my profit \loss on real time basis so my data is updating on real time basis .
So i need a macro which gets the data i want and feeds it and remember if new stock name is added then it should not over write the first one .So please help me on this one .