If you are interested in Pivots please email me using the internal MoneyAm mail facility.

morning Bt and all.

morning bt et al. Quiet day today with US hol?

Cool stuff BT & LW, ?? any chance of a peek @ the code behind this masterpiece please ?(for educational purposes only)?

Mbbcat: 'Fraid not. I originally did this all for my use, but decided to post the resultant spreadsheet here. All the blood and guts remains in my own software and/or Excel VisualBasic. My own spreadsheet extends the Pivot table a lot further, but that's my "edge". ;-)

morning BT and all.
Will the sea of red turn into calm blue seas today? well atleast the suns shining in ellesmereport

BT

understandable that you don't want to give away your edge - I was thinking more in terems of some cut down / isolated examples that may serve as teaching / learning aids / exercises - surely that wouyld not compromise anything but would help alot of people develop their own specialised versions ??

mbbcat: could you explain a bit further as to what you would like to see?

morning BT and all.

morning BT and all.
ttt

morning BT and fellow pivoters.

morning BT, JJ50 et al.

morning BT, zarif et all.

morning BT, JJ50 et al.

morning BT, JJ50 et al.

morning BT, JJ50 et al.

Had a couple of requests to explain colouring:

Look at the closing price - it has to appear in the Pivot range somewhere. So the colour coding of the Pivot values reflect where the closing price is. Below central Pivot is red, above central Pivot is blue.

(Just noticed there's a small gremlin on one of the lower colourings.)

They are visual clues as to where the closing price may indicate the "sentiment" of the stock [think about closing auctions] and it's direction. There's a awlful lot of visual clues based on the pivot colouring and the price/vol rise/fall and it's a matter of looking at, and recognizing, the patterns.The idea is to just let you do a quick visual scan to look for any anomalies to add to your watch list.

can you explain how to used the pivot point

morning Bt,JJ50 and nice to have u on board Dogg
rgds
zarif

Dogg: Click on the Reference 3 (the 1 and 2 need binning I see) in the thread header. Just above the bouncing red arrow. Pretty good description in there..In a nutshell they give you a pretty good entry and exit point in a stock, but always use a secondary indicator to make sure of course.Don't forget, there's no such thing as a "sure bet" in life. Otherwise we'd all be using it.

Morning all