| View previous topic :: View next topic |
| Author |
3x5 maco method |
vishyvaranasi
Green Belt
Joined: 11 Jul 2011
Posts: 1159
|
Post: #46  Posted: Wed Sep 26, 2012 6:37 pm Post subject: Re: Hi All |
 |
|
Hi Prakash & Shahrachit.
I am still yet to succeed . The thing is when i am downloading the file it is automatically being saved as a zip file and when extracting that zip file 4 folders are opening and the contents are in xml format and when opening those some coded language is coming. By the way prakash how did u open when ur gmail account is logged in bcoz just now i had tried the same but in vain.
Vishy
| shahrachit wrote: | | pkholla wrote: | | shahrachit wrote: | Try searching some software on internet which converts your xlsx to xls. | vishyvaranasi wrote: | | Hi, Had tried hell lot to open the file but wasnt able to do. Can anyone help me in presenting the file in office 2003/07 format so as to allow me to see it. Vishy |
|
Friends:
1 I succeeded in opening .xlsx file in google documents (while logged in in gmail) and then saved a copy as .xls in my computer. The .xls opened in my older excel version!
2 Most people oblige if u ask them to again save a copy as .xls in their computer, which can then be attached to ICharts post
Prakash Holla |
Icharts allow max. 1mb file as attachment... When the excel was saved in earlier version; the size was more than 2mb. Also icharts does not allow zip files. I tried all means to upload; but failed...... |
|
|
| Back to top |
|
 |
|
|
|
sonai_81
White Belt
Joined: 27 Jan 2010
Posts: 14
|
| Post: #47 Posted: Wed Sep 26, 2012 7:05 pm Post subject: |
|
|
| To open the file, you need to use minimum office 2007..The file is in .xlsx format. Office 2003 can't open this format.. |
|
| Back to top |
|
|
vishyvaranasi
Green Belt
Joined: 11 Jul 2011
Posts: 1159
|
| Post: #48 Posted: Wed Sep 26, 2012 7:35 pm Post subject: Hi |
|
|
| sonai_81 wrote: | | To open the file, you need to use minimum office 2007..The file is in .xlsx format. Office 2003 can't open this format.. |
Even tried that without success
vishy |
|
| Back to top |
|
|
vishyvaranasi
Green Belt
Joined: 11 Jul 2011
Posts: 1159
|
| Post: #49 Posted: Wed Sep 26, 2012 7:46 pm Post subject: Hi |
|
|
Ha,
Finally was able to crack it. OPENED.By the way thnx shahrachit for ur PM
Vishy |
|
| Back to top |
|
|
stratus
White Belt
Joined: 10 Jun 2009
Posts: 6
|
| Post: #50 Posted: Wed Sep 26, 2012 8:25 pm Post subject: |
|
|
| vishyvaranasi wrote: | Hi Galraniji,
When i click on the xlsx link that u posted it is automatically being downloaded as a zip file and when i try to open it it isnt opening. So is there any other means that i can go thru the file.
Vishy |
You can download Libreoffice 3.6 version, which will open files, which are created by Microsoft Office 2010. You no need to pay for it, since it is opensource, and free.
http://www.libreoffice.org/download/
Hope this helps for anybody who like to open Microsoft office 2010 files. |
|
| Back to top |
|
|
pkholla
Black Belt
Joined: 04 Nov 2010
Posts: 2890
|
| Post: #51 Posted: Wed Sep 26, 2012 8:31 pm Post subject: |
|
|
Vishy: i received the file as an attachment to a gmail email and i just tried to open it and it opened as google document. later i tried "save as" with ext. xls and it worked
If u want will try with old msg and send you pm with exact procedure that works for me!
PS I like to try such puzzles, enlarges our vision and knowledge and in this case gives cheap satisfaction that we have s$%$%$d Bill Gates (who wants us to pay $$$$$$$ for upgrade to next next version of Windows/ Office)
Prakash Holla |
|
| Back to top |
|
|
amitkbaid1008
Yellow Belt
Joined: 04 Mar 2009
Posts: 540
|
| Post: #52 Posted: Wed Sep 26, 2012 10:46 pm Post subject: |
|
|
Why such discussion about format of a file.
Where is the author of file?
Why can't you save this file as .xls version upload again? |
|
| Back to top |
|
|
galrani
White Belt
Joined: 23 Oct 2011
Posts: 93
|
| Post: #53 Posted: Wed Sep 26, 2012 11:14 pm Post subject: |
|
|
But the point is how do you know during the day if the trade is going to result in a whipsaw or if the system has really given a reversal signal. 
Cheers
Shiva
| shahrachit wrote: | Thanks Shiva for reply....
Total points Loss due to Intraday Whips are 7764. If we had traded only one lot for intraday whips and continued the earlier trade; than Net P&L would have increased from 7531 to (7531+7764) = 15294....
| galrani wrote: | I have done backtest one one lot only
margin required is 25k but invested capital assumed to be 50k (incl 25k buffer)
In reality if you trade multiple lots, you get to innovate entries and exits to try to maximise profits and reduce losses due to whipsaws.
Losses will be there, no doubt about that. All that is required is to take each trade in anticipation of a giant trend like jan 2012
Cheers
Shiva
| shahrachit wrote: | Hi Galraniji,
Excellent work done.
But one question..... Why we use 2 lots for intraday; if we use only one lot in intraday then losses could be minimized ???
Or there is some misunderstanding by me ? |
 |
|
|
|
| Back to top |
|
|
baldewa
White Belt
Joined: 07 Nov 2010
Posts: 96
|
| Post: #54 Posted: Thu Sep 27, 2012 7:43 am Post subject: |
|
|
| galrani wrote: | But the point is how do you know during the day if the trade is going to result in a whipsaw or if the system has really given a reversal signal.
Cheers
Shiva
| shahrachit wrote: | Thanks Shiva for reply....
Total points Loss due to Intraday Whips are 7764. If we had traded only one lot for intraday whips and continued the earlier trade; than Net P&L would have increased from 7531 to (7531+7764) = 15294....
| galrani wrote: | I have done backtest one one lot only
margin required is 25k but invested capital assumed to be 50k (incl 25k buffer)
In reality if you trade multiple lots, you get to innovate entries and exits to try to maximise profits and reduce losses due to whipsaws.
Losses will be there, no doubt about that. All that is required is to take each trade in anticipation of a giant trend like jan 2012
Cheers
Shiva
| shahrachit wrote: | Hi Galraniji,
Excellent work done.
But one question..... Why we use 2 lots for intraday; if we use only one lot in intraday then losses could be minimized ???
Or there is some misunderstanding by me ? |
|
|
|
point is also, that how to calculate reversal value |
|
| Back to top |
|
|
galrani
White Belt
Joined: 23 Oct 2011
Posts: 93
|
| Post: #55 Posted: Thu Sep 27, 2012 8:15 am Post subject: |
|
|
| baldewa wrote: | | galrani wrote: | But the point is how do you know during the day if the trade is going to result in a whipsaw or if the system has really given a reversal signal.
Cheers
Shiva
| shahrachit wrote: | Thanks Shiva for reply....
Total points Loss due to Intraday Whips are 7764. If we had traded only one lot for intraday whips and continued the earlier trade; than Net P&L would have increased from 7531 to (7531+7764) = 15294....
| galrani wrote: | I have done backtest one one lot only
margin required is 25k but invested capital assumed to be 50k (incl 25k buffer)
In reality if you trade multiple lots, you get to innovate entries and exits to try to maximise profits and reduce losses due to whipsaws.
Losses will be there, no doubt about that. All that is required is to take each trade in anticipation of a giant trend like jan 2012
Cheers
Shiva
| shahrachit wrote: | Hi Galraniji,
Excellent work done.
But one question..... Why we use 2 lots for intraday; if we use only one lot in intraday then losses could be minimized ???
Or there is some misunderstanding by me ? |
|
|
|
point is also, that how to calculate reversal value |
That is already given in the file no? Refer to the column next to the Buy sell column.
Cheers
Shiva |
|
| Back to top |
|
|
shahrachit
White Belt
Joined: 12 Jul 2012
Posts: 117
|
| Post: #56 Posted: Thu Sep 27, 2012 9:13 am Post subject: |
|
|
I agree to it; but can't we continue One position till 3:15 & if it is a real reversal; Close that position. Also will continue with the second lot taken during reversal between 9:30 to 3:15.
In case there was a false reversal or intra-day whisp... close the second lot taken between 9:30 to 3:15 and continue with the first position taken..
Regards,
Rachit.
| galrani wrote: | But the point is how do you know during the day if the trade is going to result in a whipsaw or if the system has really given a reversal signal.
Cheers
Shiva
|
|
|
| Back to top |
|
|
galrani
White Belt
Joined: 23 Oct 2011
Posts: 93
|
| Post: #57 Posted: Thu Sep 27, 2012 9:29 am Post subject: |
|
|
I have back tested the same and it gives lower returns compared to my variation. All the data is there in the file, you can modify the logic to see the results.
Intraday whips occur during trendless days. The loss due to whips will be lower in these market conditions. On news specific days, you may get wild swings (like RBI review days etc) that may result in wide whipsaw losses, but these are to be taken in stride.
I for one try to reduce my positions before such news specific days.
Cheers
Shiva
| shahrachit wrote: | I agree to it; but can't we continue One position till 3:15 & if it is a real reversal; Close that position. Also will continue with the second lot taken during reversal between 9:30 to 3:15.
In case there was a false reversal or intra-day whisp... close the second lot taken between 9:30 to 3:15 and continue with the first position taken..
Regards,
Rachit.
| galrani wrote: | But the point is how do you know during the day if the trade is going to result in a whipsaw or if the system has really given a reversal signal.
Cheers
Shiva
|
|
|
|
| Back to top |
|
|
shahrachit
White Belt
Joined: 12 Jul 2012
Posts: 117
|
| Post: #58 Posted: Thu Sep 27, 2012 9:38 am Post subject: |
|
|
During intraday whips... how many position you hold ---- 2 (one earlier and one new for reversal reversal) or 3 (one earlier and two new for reversal and close one earlier + one new reversal position by EOD if its true reversal) ?
| galrani wrote: | I have back tested the same and it gives lower returns compared to my variation. All the data is there in the file, you can modify the logic to see the results.
Intraday whips occur during trendless days. The loss due to whips will be lower in these market conditions. On news specific days, you may get wild swings (like RBI review days etc) that may result in wide whipsaw losses, but these are to be taken in stride.
I for one try to reduce my positions before such news specific days.
Cheers
Shiva
| shahrachit wrote: | I agree to it; but can't we continue One position till 3:15 & if it is a real reversal; Close that position. Also will continue with the second lot taken during reversal between 9:30 to 3:15.
In case there was a false reversal or intra-day whisp... close the second lot taken between 9:30 to 3:15 and continue with the first position taken..
Regards,
Rachit.
| galrani wrote: | But the point is how do you know during the day if the trade is going to result in a whipsaw or if the system has really given a reversal signal.
Cheers
Shiva
|
|
|
|
|
| Back to top |
|
|
anand_2012
White Belt
Joined: 06 Feb 2012
Posts: 84
|
| Post: #59 Posted: Thu Sep 27, 2012 9:56 am Post subject: |
|
|
can any one tell what is the time frame for intraday and
what are the ema cross over is that 3,5 or anything else |
|
| Back to top |
|
|
galrani
White Belt
Joined: 23 Oct 2011
Posts: 93
|
| Post: #60 Posted: Thu Sep 27, 2012 10:03 am Post subject: |
|
|
Hi Rachit
Lets assume you start the day with one lot long.
You will input a stop loss order for 2 lots short at the reversal point. (One lot to cover your long and one to go short)
If the order is executed intraday and by end of day you see that the market has gone back above the reversal point (i.e. you have been shipped  ) you enter longs two lots (one to cover your short and one to go long again)
If you are playing with multiple lots, then you can innovate and try to workout your own strategy to space out your entries and exits
Cheers
Shiva
| shahrachit wrote: | During intraday whips... how many position you hold ---- 2 (one earlier and one new for reversal reversal) or 3 (one earlier and two new for reversal and close one earlier + one new reversal position by EOD if its true reversal) ?
| galrani wrote: | I have back tested the same and it gives lower returns compared to my variation. All the data is there in the file, you can modify the logic to see the results.
Intraday whips occur during trendless days. The loss due to whips will be lower in these market conditions. On news specific days, you may get wild swings (like RBI review days etc) that may result in wide whipsaw losses, but these are to be taken in stride.
I for one try to reduce my positions before such news specific days.
Cheers
Shiva
| shahrachit wrote: | I agree to it; but can't we continue One position till 3:15 & if it is a real reversal; Close that position. Also will continue with the second lot taken during reversal between 9:30 to 3:15.
In case there was a false reversal or intra-day whisp... close the second lot taken between 9:30 to 3:15 and continue with the first position taken..
Regards,
Rachit.
| galrani wrote: | But the point is how do you know during the day if the trade is going to result in a whipsaw or if the system has really given a reversal signal.
Cheers
Shiva
|
|
|
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
