| View previous topic :: View next topic |
| Author |
Intraday Trading Strategy |
bablya
White Belt
Joined: 31 May 2011
Posts: 38
|
Post: #376  Posted: Wed Jun 08, 2011 11:28 am Post subject: |
 |
|
| sriki_r wrote: | Attached the excel file which has the calculation of this strategy.
Hope it helps if not already present in this thread.
Please correct the formulas if there are any mistakes. |
good work sriki .... lot r still confused in doing calculation and ask motabhai everyday. It's coutesy of him tht he replies every query . Surely will save lot of noise created with respect to calculation.
I have not tested formulas. Requesting Excel expert guyto test them.
|
|
| Back to top |
|
 |
|
|
|
avinash02
White Belt
Joined: 22 Feb 2009
Posts: 343
|
| Post: #377 Posted: Wed Jun 08, 2011 11:37 am Post subject: |
|
|
| sriki_r wrote: | Attached the excel file which has the calculation of this strategy.
Hope it helps if not already present in this thread.
Please correct the formulas if there are any mistakes. |
sriki
very nice worked .........
avinash
|
|
| Back to top |
|
|
vinst
Black Belt
Joined: 09 Jan 2007
Posts: 3303
|
| Post: #378 Posted: Wed Jun 08, 2011 11:47 am Post subject: |
|
|
| Long entry taken at 5548 for tgt 5581, SL 5519
|
|
| Back to top |
|
|
lakshmikanth
White Belt
Joined: 13 May 2011
Posts: 41
|
| Post: #379 Posted: Wed Jun 08, 2011 11:48 am Post subject: |
|
|
hai mr sriki_r good job i tested it perfectly done   
|
|
| Back to top |
|
|
godisbogus
White Belt
Joined: 01 Sep 2006
Posts: 32
|
| Post: #380 Posted: Wed Jun 08, 2011 11:57 am Post subject: |
|
|
Here is my version of excel sheet for Avinash strategy. If you need any additional columns please let me know.
| Description: |
|
Download |
| Filename: |
Avinash Strategy.xls |
| Filesize: |
26 KB |
| Downloaded: |
482 Time(s) |
|
|
| Back to top |
|
|
bablya
White Belt
Joined: 31 May 2011
Posts: 38
|
| Post: #381 Posted: Wed Jun 08, 2011 12:14 pm Post subject: |
|
|
see my later post
Last edited by bablya on Wed Jun 08, 2011 12:38 pm; edited 3 times in total |
|
| Back to top |
|
|
guptak03
White Belt
Joined: 03 May 2011
Posts: 50
|
| Post: #382 Posted: Wed Jun 08, 2011 12:20 pm Post subject: |
|
|
| we better take 9.30 price bcoz every 1 differs in der rates ..avibhai aap ka kya rai hain
|
|
| Back to top |
|
|
avinash02
White Belt
Joined: 22 Feb 2009
Posts: 343
|
| Post: #383 Posted: Wed Jun 08, 2011 12:38 pm Post subject: |
|
|
| bablya wrote: | | godisbogus wrote: | | Here is my version of excel sheet for Avinash strategy. If you need any additional columns please let me know. |
cgts and thx to both........godis and sriki.
godis, in ur sheet u can do modifiacation . When the trend is UP, short side trade details like SELL SL & SELL TAR do create confusion.pls make the opposite trade fields blank. And evenif SL hits and we reverse position we do calcu again with diff values. So opposite side details r redundant
Also SRIKI and GODIS, u both hav not mentioned date column.
I liked the RED/GREEN colour code indicating result of trade. SRIKI think over it.
Now last thing, u seem to be excel expert.loss/profit of evrybody is diff depending on his entrypoint. But can we have 1 COMMON excel which will maintain all daily transactions and will give rough figures of results.
( i agree tht everybody can prepare separate sheet, But it can happen tht somebody don't trade on anyday. To reflect strategy output, all transactions need to be in it .hence i thought of common sheet)
bablya |
cgts godis nd sriki
nd i agree with bablya both of u not mentioned date column...we need date column .....nd godis ....When the trend is UP, short side trade details like SELL SL & SELL TAR do create confusion so batter to its blank..its easy to understand....
avinash
|
|
| Back to top |
|
|
bablya
White Belt
Joined: 31 May 2011
Posts: 38
|
| Post: #384 Posted: Wed Jun 08, 2011 12:39 pm Post subject: Excel sheet by Godis and Sriki. |
|
|
cgts and thx to both........godis and sriki.
godis, in ur sheet u can do modifiacation . When the trend is UP, short side trade details like SELL SL & SELL TAR do create confusion.pls make the opposite trade fields blank. And evenif SL hits and we reverse position we do calcu again with diff values. So opposite side details r redundant
Also SRIKI and GODIS, u both hav not mentioned date column.
I liked the RED/GREEN colour code indicating result of trade. SRIKI think over it.
Now last thing, u seem to be excel expert.loss/profit of evrybody is diff depending on his entrypoint. But can we have 1 COMMON excel which will maintain all daily transactions and will give rough figures of results.
( i agree tht everybody can prepare separate sheet, But it can happen tht somebody don't trade on anyday. To reflect strategy output, all transactions need to be in it .hence i thought of common sheet)
(Bcos AVI Strat is so simple, there r lot of critic regd its result. 1 sheet stating all transaction with results for a month will shut mouth of all critics, Ithink Godis has data from 1jun. So why not make a sheet for Jun ?
ALL THIS TO BE DONE WITH AVIBHAI'S PERMISION. AVIBHAI over to u
bablya
|
|
| Back to top |
|
|
avinash02
White Belt
Joined: 22 Feb 2009
Posts: 343
|
| Post: #385 Posted: Wed Jun 08, 2011 12:41 pm Post subject: |
|
|
| guptak03 wrote: | | we better take 9.30 price bcoz every 1 differs in der rates ..avibhai aap ka kya rai hain |
guptak03
we alwys take data at 9.30.....give a good result
avinash
|
|
| Back to top |
|
|
avinash02
White Belt
Joined: 22 Feb 2009
Posts: 343
|
| Post: #386 Posted: Wed Jun 08, 2011 12:44 pm Post subject: |
|
|
| bought at 5534
|
|
| Back to top |
|
|
avinash02
White Belt
Joined: 22 Feb 2009
Posts: 343
|
| Post: #387 Posted: Wed Jun 08, 2011 12:52 pm Post subject: Re: Excel sheet by Godis and Sriki. |
|
|
| bablya wrote: | cgts and thx to both........godis and sriki.
godis, in ur sheet u can do modifiacation . When the trend is UP, short side trade details like SELL SL & SELL TAR do create confusion.pls make the opposite trade fields blank. And evenif SL hits and we reverse position we do calcu again with diff values. So opposite side details r redundant
Also SRIKI and GODIS, u both hav not mentioned date column.
I liked the RED/GREEN colour code indicating result of trade. SRIKI think over it.
Now last thing, u seem to be excel expert.loss/profit of evrybody is diff depending on his entrypoint. But can we have 1 COMMON excel which will maintain all daily transactions and will give rough figures of results.
( i agree tht everybody can prepare separate sheet, But it can happen tht somebody don't trade on anyday. To reflect strategy output, all transactions need to be in it .hence i thought of common sheet)
(Bcos AVI Strat is so simple, there r lot of critic regd its result. 1 sheet stating all transaction with results for a month will shut mouth of all critics, Ithink Godis has data from 1jun. So why not make a sheet for Jun ?
ALL THIS TO BE DONE WITH AVIBHAI'S PERMISION. AVIBHAI over to u
bablya |
bablya
u dont need a permision ok ..we are frnds here so dont use word permision,bag....we are support all eachother..nd better to make a sheet for jun
avinash
|
|
| Back to top |
|
|
vinay28
Black Belt
Joined: 24 Dec 2010
Posts: 11748
|
| Post: #388 Posted: Wed Jun 08, 2011 12:55 pm Post subject: |
|
|
| A small suggestion. Shouldn't open-high be replaced by high-open?
|
|
| Back to top |
|
|
godisbogus
White Belt
Joined: 01 Sep 2006
Posts: 32
|
| Post: #389 Posted: Wed Jun 08, 2011 12:56 pm Post subject: |
|
|
Yes Sir. I have added the date column and deleted all redundant stuff. You can now download the new version.
| Description: |
|
Download |
| Filename: |
Avinash Strategy.xls |
| Filesize: |
26.5 KB |
| Downloaded: |
464 Time(s) |
|
|
| Back to top |
|
|
avinash02
White Belt
Joined: 22 Feb 2009
Posts: 343
|
| Post: #390 Posted: Wed Jun 08, 2011 12:59 pm Post subject: |
|
|
| godisbogus wrote: | | Yes Sir. I have added the date column and deleted all redundant stuff. You can now download the new version. |
hey godisbogus
kya huva bhai aaj aapne direct sir bola i dont like it .... 
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
