My Pivot - Resistance -Support Calculator

fortune123 · #21 21st December 2005, 05:34 PM

great work joy&mitali it would have been even better if we could have an option to save the data

Creation123 · #22 28th December 2005, 01:12 PM

thanks for this amazing job.I wish I could handle excel that well.

prsrivastav · #23 30th December 2005, 10:50 PM

Hi Joy-mitali
Thank For Developing The Pivot-calc
Pl Tell ,what Is The Formula You Are Using For Camerila Pivots.and Also From Where I Can Get The Utility Devloped By Srisara Regarding Pivot Point.i Have Heared It Is Very Useful For Calculating More Than One Company At A Time.
Waiting For You Reply
Prsrivastav

pkjha30 · #24 31st December 2005, 01:01 AM

Quote:

Originally Posted by joy_mitali

Hello everybody,
The 2nd version---is loaded now--now OHLC data can be loaded from EOD file---dwnlded from NSE--bhavcopy---or from srisara's data extractor--(metastk format)---the file must be a .csv file---
A special thanks to SRISARA for ur help
Regards,
joy_mitali

Hi Joy
I checked up your calculator. Loading of data from EOD file could not be done though I supplied nse EOD format
Market,Security, Previous Close, Open, High, Low, Close, Net Traded Value, Net Traded Quantity,
Corporate Indicator, Trades, 52 wk high, 52 wk low

JM_Innovations modification does work automatically

So I manually entered values and It displayed all the values as calculated for all the three types of pivots.

Perhaps I am missing something here.

I am curious as to why excel is chosen why not VB?

One suggestion

You can take a range of ohlc data for a stock and calculate RPS data and plot a chart in both directions and see the general trend as to how the calculated values correspond to the actual happenings.

Graphical representation works better.

regards
Pankaj

joy_mitali · #25 31st December 2005, 03:07 PM

Hello Pankaj,
Thanks for ur constructive suggestion---U have really given a good idea---regarding a graphical Representation---
Strange!!!The data is perfectly taking from the EOD ---file----downloaded from NSE---or by Srisara's DATAEXTRACTOR---
THe format of data must be----Symbol---Series---Open ---High---Low-Close---and whateverever else---
To be more precise---Symbol/Security Name---must be present in Column A
Open,High,Low,Close---must be present in Columns---C,D,E,F---respectively
Regarding choice of EXCEL----Its just my personal Preferance/Constrain for the time being---Though the code is actually in VB--
Regarding ur suggestion of the chart---now that --I m getting a steady supply of data---with my downloader---I will try to incorporate it--
Plz----do put a review---of the file I have sent u----Let me know if its working---
Regards,
joy_mitali

pkjha30 · #26 31st December 2005, 08:18 PM

Quote:

Originally Posted by joy_mitali

Hello Pankaj,

Plz----do put a review---of the file I have sent u----Let me know if its working---
Regards,
joy_mitali

Hi joy

I tried your software. It created both folders and output folder with all files is attached. Do have a look at it. Is it the desired outcome?

While running it gave three runtime errors no. 424, 1013 and object type mismatch. My system is winxp at home.

Last command button gave some excel file by name book1,book2,book3..... book789 etc but I could not subsequently trace the file or excel books.

I think your idea is to convert eod file to ***** format and then individual stock files. Can you put your algorithm for it so that I can check it?

Flwo of the program could be as follows:-

EOD Data download(Satya)
|
|
Data Converter(JM/Satya)
|
|
Porting data for individual stocks(JM)
|
|
Pivot resistance calculator(JM)
|
|
Charting/plotting
|
|
technical analysis and fundamental indicators

So if collaboration is there a complete software would emerge

regards
pankaj

sup_ida · #27 1st January 2006, 09:50 AM

Good Work joymitali .I have also developed Pivot calculator that can be used for all scrips in NSE .u have to just download the NSE bhavcopy .it will do the remaining.

hmp · #28 1st January 2006, 12:46 PM

hi sup
can u share your calci with us?

sup_ida · #29 1st January 2006, 09:44 PM

ya definitely hmp i will soon made that public.if u want that give me ur email address i send the copy of my project.

sar1479 · #30 3rd January 2006, 09:01 AM

Quote:

Originally Posted by sup_ida

ya definitely hmp i will soon made that public.if u want that give me ur email address i send the copy of my project.

pls send at viv2575@***************

Thx

Similar Threads for: My Pivot - Resistance -Support Calculator
Thread	Thread Starter	Forum	Replies	Last Post
Determining Support & Resistance Levels on Charts	CreditViolet	Technical Analysis	2	27th July 2006 04:10 PM
High Volume Penny Stocks starting uptrends	Traderji	Stocks & Shares	45	18th August 2005 12:37 PM
Support & Resistance Levels for the NSE Nifty 50	Traderji	Trading on Technicals	6	16th August 2004 03:15 PM
Support & Resistance Levels for the BSE Sensex	Traderji	Trading on Technicals	6	16th August 2004 03:13 PM