My daytrading

[Raghavacc]

Thank you Vijay,

Here is the link
http://www.4shared.com/account/dir/p_bue37W/_online.html?&rnd=18#dir=26434578

 

[murthyavr]

Thank you Vijay,

Here is the link (Excel 2007 format; xlsx)
http://www.4shared.com/account/dir/p_bue37W/_online.html?&rnd=18#dir=26434578

Those who have MS Office version of 2003 and below should download this version posted as attachment.

And, the conditional formatting feature suggested by Raghav is not available in version 2003 and below. Those who want the duplicate entries to be highlighted should follow this procedure.

1. Identify the range, in which duplicates are to be highlighted. Let's say, the range is B2:B20.

2. Select the range as identified above (In this example, B2:B20)

3. Go to Format -> Conditional Formatting.

4. In the dialog box that follows (titled Conditional Formatting), change "Cell Value is" to Formula is

5. Type the following formula in the next box.
(Please change the range to the actual requirement)

=COUNTIF($B$2:$B$20,B2)>1

6. Click on Format button in the same dialog box

7. In the following window (titled Format Cells), click on Patterns tab.

8. Select a color for highlighting duplicate entries.

9. Click on OK to close Format Cells window.

10. Again click on OK to close Conditional Formatting window.

Hope this will be useful to some of us.

 

[bikashkumar11]

deleteddddd

 

[krish4166]

Raghav,
Here is this exercise how we are going to calculate pivots.

==================================================
Weekly Pivots

1) Weekly Pivot Point=(Weekly High+Weekly Low +Weekly Close)/3

2) Weekly R1 =(Weekly Pivot x 2) Weekly Low

3) Weekly R2 = (Weekly Pivot + Weekly High) Weekly Low

4) Weekly S1 = (Weekly Pivot 2) Weekly High

5) Weekly S2 = (Weekly Pivot Weekly High) +Weekly Low

================================================== ======

Monthly Pivot

1) (Monthly Pivot=Monthly High+Monthly Low +Monthly Close)/3

2) Monthly R1 =(Monthly Pivot x 2) Monthly Low

3) Monthly R2 = (Monthly Pivot + Monthly High) Monthly Low

4) Monthly S1 = (Monthly Pivot 2) Monthly High

5) Monthly S2 = (Monthly Pivot Monthly High) +Monthly Low

As per above formula given the calculation of NF for weekly and monthly as follows:
WEEKLY PIVOT Value : 5595
R1 = 5745.6
R2 = 5852.6
S1 = 5488
S2 = 5551.4
MONTHLY PIVOT value: 5493.43
R1 = 5804.46
R2 = 5964.83
S1 = 5333.06
S2 = 5342.77

Raghav,
As per above calculations for weekly and monthly, first we have to look for resistance R1 and then R2 and also in support S2 first and then S1 later. plz explian whether it is correct.

 

[Raghavacc]

I have thought of clearing all the confusion doubt regarding trend and retracement hence putting 2 charts. Please understand both trend range and retracement they are 2 faces of a coin.We can consider them either way.Whether u call him "Son in law" or "Daughters husband" it means same....
Hope it clears all doubts/confusions.

Ps: earlier we have missed 76.4% levels. I will reedit all the posts and make them more understandable.more later

 

[murthyavr]

Ps: earlier we have missed 74.6% levels.

Raghav, is it not 78.60%?

 

[deepanshah13]

Will anyone please upload the Fibonacci Calculator in EXCEL Sheet?

We can get Pivot Points using Excel Sheet. If anyone upload the Fibonacci Calculator in Excel sheet, we can have everything - Pivot Point, Fibonacci Retracement Levels and Confluence of these (as suggested by Raghavsir) in just ONE Excel Sheet.

Thanks and Regards.

 

[Raghavacc]

Raghav, is it not 78.60%?

Huh!!I have to write all over again.I do not think precision is meant for Trading.What all we look for is a zone .A zone to where price reaches and makes a reaction.That zone can be of 10 points or it can be of 50 points.
I have seen so many traders especially in Forex arguing that its 23.6% and not 21.8% .Even for 78 or or 76% .Does that really matter for us ?No not at all. We will leave it to others.

The danger with this debate is that it never ends.I would say I can prove it mathematically. You will say you have Lot of fib books. Where do we end up???we do not move .We remain where we are.I may be wrong in 74.6% or I may be right. Both do not matter in market.

Lets look at an example.High of Nifty last month -5650.Low – 5175. Range is 475 points. From high 78.6% retracement is 5277 and 76.4% is 5296---What do I do ?
5300 -5250 or 5300 -5270 is my range.I look for price to react at this zone.I am neither 76.4% guy nor a 78.6%.

Now in post no 765 why I took 76.4% is to make life easy for new comers. There is saying “People have put Idli in the mouth of a patient who could not even swallow the water”.
Hence I have used same sequence for trend as well retracement .

100-23.6=76.4,-100-38.2=61.8,-100-50=50,-100-61.8=32.8,-100-76.4=23.6,-100-100=0.
Thats how I have matched both trend range and retracements.Its only for simplicity.Let the vehicle start moving .Let new comers first understand what we are doing. Then we shall adjust everything as per the circumstances.

 

[Raghavacc]

Please lets move on Can any one Come up with Fib numbers for last month as well last week so that we can compile and proceed further?

 

[murthyavr]

Please lets move on Can any one Come up with Fib numbers for last month as well last week so that we can compile and proceed further?

NIFTY Index

Actuals:
Open High Low Close
5561.05 5657.90 5195.90 5647.40 For June,2011 month
5441.20 5705.80 5434.25 5627.20 For the week-ended 01/07/2011



Fib Levels

Monthly Weekly
23.60% 5549 5642
38.20% 5481 5602
50.00% 5427 5570
61.80% 5372 5538
76.40% 5313 5503
123.60% 5767 5770
138.20% 5834 5810
150.00% 5889 5842
161.80% 5943 5874
176.40% 6473 6185