My Pivot - Resistance -Support Calculator

[bharatk8]

hi guys,

there's a ready made pivot point calculator i've downloaded. here it is.

attatchment missing......ye kya ho raha hai?????????????

 

[pkjha30]

Thanks Pankaj ---for the link---I need to look at it again maybe--I m having no problem--Pankaj if u r also having any problem,let me know---I also need to know if it is working in some other machines---or not--
Dear Acro,
This excel utility is made in the WINXP platform with OfficeXp--I would like to know what OS r u using and which version of Office u r using---
Regards,
joy_mitali

Hi Joy

I ran it on two machines One with WINXP 32bit and win98SE both running office2000, without problem. If you want I will run on winXP64 bit and see if its OK.
User interface is very good and intuitive.

However what I am interested in is if you can calculate probability of each resistence and support level and project the graph on highest probability line and match it with actual figures, it might become a new indicator .

I really liked your intervention in another thread where flame war is going on, a trend not seen earlier in this forum. Appreciate it very much.

Regards
Pankaj

 

[pkjha30]

Hi all,

I have a cam pivot here

Hi
Link is excellent.
I notice that you have posted your explanation about pivot points there. If you post such items it would be highly appreciated by all forum members here. I have already bookmarked your link and will follow in fututre.
The CAM pivot given there is in rar format. Those who are not having a program to extract it can use 7-zip to extract the xls file. However automatic data import as provided by JOY is not available since it is an excel file with formulas only.

Regards
Pankaj

 

[joy_mitali]

Hello Pankaj,
Thanks for ur review---

However what I am interested in is if you can calculate probability of each resistence and support level and project the graph on highest probability line and match it with actual figures, it might become a new indicator

For calculating the requisit probablity----u either need the intraday data ---or the EOD data of each of the scrips-----this is what its appearing to me ---(Or can there be a alternate way!!!)---I have already been successful in isolating EOD data of each of the scrips ---along with the datas of various indicators---like MACD,ATR,Volatility,Volatility ratio,Williams%R,CHAUKINS Money Flow, etc. etc.---STOCHASTICS and RSI is creating a bit problem(which I wil resolve soon)---Thereafter I will try to implement the probablistic version---U have given a good idea---Once a post the EOD of the Diff scrips with the indicators--I would like some more suggestions from all of u---(I myself have a few of ides)
By the way---if u can find some charting Software compatible with VB and Excel--(Preferably Freeware--ha ha)--do let me know---Not much experience with charting---but willing to learn and implement seriously---
HEllo Acro,
I do not have Office 97 to test it----for the timebeing--if u can upgrade to OFFICE 2000 or Offfice XP---then it will be working as per the reviews of Pankaj---But I will also try to see if it can be made compatible with Office 97---or OFFICE 98
Regards,
joy_mitali

 

[pkjha30]

Hello Pankaj,
Thanks for ur review---



MACD,ATR,Volatility,Volatility ratio,Williams%R,CHAUKINS Money Flow, etc. etc.---STOCHASTICS and RSI is creating a bit problem(which I wil resolve soon)---Thereafter I will try to implement the probablistic version---U have given a good idea---Once a post the EOD of the Diff scrips with the indicators--I would like some more suggestions from all of u---(I myself have a few of ides)
By the way---if u can find some charting Software compatible with VB and Excel--(Preferably Freeware--ha ha)--do let me know---Not much experience with charting---but willing to learn and implement seriously---

joy_mitali

Hi
Thanks for encouraging words. I do not know much about indicators mentioned above but all of them seems to be functions of OHLCV may be total traded qty or delivery etc(basically volume) as learnt from various sources.

AMITBE and SAINT as indicating "Strong" or "WEAK" resistance or support for a equities. These terms essentially denote probability of breaching respective points in either directions. So, I think they can share some insight into this aspect.

As regards charting software, if you are well versed in VB then you can do it easily.If you want I can give you link to sourcecode for charting and you can debug or troubleshoot the codes yourself with visual basic 6 preferably enterprise edition. Visual Basic .NET is stated to be much versatile but I have no idea. Its express editions you can download free of cost from windows website. But is has a serious limitation in that it requires .NET Version2.0 and software will not be compatible with other versions.

I am not yet through with charting part . I will tell you more when I come to it.

Regards
Pankaj

 

[joy_mitali]

Hello Pankaj,

As regards charting software, if you are well versed in VB then you can do it easily.If you want I can give you link to sourcecode for charting and you can debug or troubleshoot yourself with visual basic 6 preferably enterprise edition.

I will be previledged---from ur Help---Waiting for the next part---of ur briefings--
Regards,
joy_mitali

 

[Bhavesh888]

I have baught indian oil (IOC) ,51 shares at 460. what is the net supprt and resistance for it.It's like long turm or short turm.plz guide me and also show me new breakout in other stocks.

 

[chintan786]

HI JOY MITALI, PKJHA,.. and all those ppl whp need not to load data manually. Can any body tell me how to load EoD file and use Symbol Box.

wht I doing right now.....

selected " ENTER OHLC FROM EoD FILE"----- then click on " SELECT DIR.... FILE"---- WRITE NAME OF SYMBOL IN SYMBOL BOX---- HITTING BUTTON --" LOAD OHLC DATA".

NOW REAL PROBLEM STRTS... NOTHING IN "OPEN" .. HIGH ,, LOW , CLOSE BOX.

I ALWAYS AFTER THT NEED TO ENTER PRICES MANUALLY.... WHYYYY??

CAN ANY ONE TELL ME WHY.

I TRIED BOTH DATA FILE FROM PKJHA'S UTILITY AND FILE FRM NSE IN CSV FORMAT. BUT NO GAIN...


PLZ HELP ME OUT


CHINTAN

 

[kkseal]

Hi,

Does anybody know of a Pivot calculator that calculates pivots based on Camarrilla Eqns ? Can be easily implemented in Excel, but a small desktop application that

i) loads the symbols from a database
ii) has dropdowns to select the symbol, date & timeframe (daily, wkly, mthly etc)
iii)loads the HLC data from same database as in (i) (based on the TF selected)
iv) allows the computed pivot values (alongwith Symbol, date & TF) to be saved to a txt file /Excel sheet
v) Has a 'Compute' & 'Save' button (with obvious functionality)

would be handy.

(To avoid complexity, only daily data can be allowed to begin with. Later other TFs can be incorporated)

Will the S/W development experts in the forum give it a thought?

Regards,
Kalyan.

P.S. : Can also allow computing other kinds of Pivots (Floor, Woodies etc.) through another 'Pivot Type' dropdown. (The corresponding formula can then be selected internally through a CASE or IF-ELSE construct. The 'Pivot Type'/alias will also need to be saved in this case to avoid confusion later )

 

[chintan786]

hi Kalyan, in Joymitali's pivot calculator .... u can calculate Camarila Pivot also....

try it..


chintan