PIVOT calculator question

FTSEBOY

Member
87 0
Hi all,
I noticed on the www.eurostoxx.co.uk webiste that Helen uses a pivot calculator. The data to be put in are the high/low and closes from the day before. I tried it out this morning based upon the FTSE cash market and remarkably the R2 figure was about 4000-00. Looking at the FTSE cash today it peaked at just over 4000-00. Is this some king of crystal ball or what? Does anyone actively use a pivot table and if so does anyone know how these figures are determined?
FTSEBOY
PS Please disregard my naivity as I am new to the game

waytogo

Active member
162 0
Hi

I dont use pivot points myself, although did go through a phase some time ago of working them out every day, and yes they do work at least some of the time.

Also, dont forget that round numbers will also give major support/resistance, often only for psychological reasons, so 4000 was always going to be a sticking point for the FTSE this morning, and it will need some good news to head up through it significantly.

Waytogo

Skimbleshanks

1
2,325 16
There are different ways of working out pivot points, if they are your particular 'thing'. The most common is High + Low + Close divided by 3 = the central pivot point.

However, for stocks which regularly gap up or down then some people use High + Low + Close + current day's Open divided by 4.

There are then R1 and S1 (resistance point 1 and support point 1), and R2 and R3, and there are also intermediate points between each of these, such as R0.5 and R1.5 etc.

They're supposedly used by floor traders in the pit who traditionally wrote the 5 points on the backs of their hands or memorised them. Some folks set great store by them, others wouldn't touch them with a bargepole - like every aspect of trading, it's horses for courses.

That's the basics - for the basic formula:
http://www.snapdragon.co.uk/resource/talk/talk8.htm
http://www.linnsoft.com/tour/techind/pp.htm

Bigbusiness

Experienced member
1,408 23
Excel pivot point calculator

I have attached an excel pivot point calculator I have been working on. I am not that good with excel so if there are any experts out there I am sure they could improve it.

I enter the Dow data in to the OHLC boxes and drag down the Pivot point first then the S3,S2,S1, R1, R2, R3 boxes and the moving average boxes. I also worked out the weekly pivots for the last two weeks.

Hoped to have a few charts but haven't worked out how to make them yet.

Attachments

• dow pivot.xls
48 KB · Views: 574

blackhawk

Junior member
27 0
There is a Pivot Calculator and other financial software tools available on this site: http://www.tradersoftware.biz/

The guy who runs it and wrote the software is a Trade2Win member.

TBS

Well-known member
385 0
Is this some king of crystal ball or what?

... what.

trendspotter

Junior member
25 0
There is also a simple calculator which is free at
www.pivotpoints.co.uk with links to various articles on Pivot points

Bigbusiness

Experienced member
1,408 23
Here is the dow today with the pivot lines. If only it worked this well every day!

Attachments

• pivot 6.5.gif
7 KB · Views: 684

zambuck

Experienced member
1,608 102
Re: Excel pivot point calculator

Bigbusiness said:
I have attached an excel pivot point calculator I have been working on. I am not that good with excel so if there are any experts out there I am sure they could improve it.

I enter the Dow data in to the OHLC boxes and drag down the Pivot point first then the S3,S2,S1, R1, R2, R3 boxes and the moving average boxes. I also worked out the weekly pivots for the last two weeks.

Hoped to have a few charts but haven't worked out how to make them yet.

I did something similar for Metastock as it is possible to DDE link data and chart it....however I found a ready made pivot point calculator on metastock user site which I now drop on the charts...

Have you seen an article by Jayanthi...editor of TASC she has another type of pivot point formulae which she has used sucessfully....

Bigbusiness

Experienced member
1,408 23
Hi Zambuck,

Do you mean this article?

http://store.traders.com/v11622pivpoi.html

What was different about her formulae? I have seen about using the open price but would be interested in any other variations.

Bigbusiness

Experienced member
1,408 23
Here is a 5min chart of the Dow on Friday 9.5.03.

Attachments

• 9.5.03.gif
13.2 KB · Views: 381

zambuck

Experienced member
1,608 102
Bigbusiness said:
Hi Zambuck,

Do you mean this article?

http://store.traders.com/v11622pivpoi.html

What was different about her formulae? I have seen about using the open price but would be interested in any other variations.

...Yes BB

It is the same one...although I have a PDF file of that article....

Do you want me to e mail it to you..????

amittamakuwala

Newbie
2 0
Pivot

zambuck said:
...Yes BB

It is the same one...although I have a PDF file of that article....

Do you want me to e mail it to you..????
hello dear i am also a interested in pivot levels.. i am mba student. i am not so rich person so can possible to send me that pdf file of that article....................

385 0

Similar threads

Replies
0
Views
2K
Replies
15
Views
3K
Replies
9
Views
11K
Replies
17
Views
6K
M
Replies
5
Views
6K

AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.