CoolWorks

Hello Murthy sir n Cool,

The symbol CLQ06.nym where CL is constant Q is the part that changes 06 stands for the year nym is for NYMEX also sir the symbol changes on the 21 of every month the present symbol is CLU06.nym(sep.), CLQ06.nym(aug), CLN06.nym(july) so sir i am not able to make out actually there is no proper mechanism (g-feb h-mar,j-apr. k-may, m-jun, n-jul, q-aug, u-sep) so i too change manually. Hope i gave u the required data to answer ur queries.

Camarilla Pivots
The formulae for the Camarilla pivots are:

Range = High - Low
R4 = C + (Range * 1.1/2)
R3 = C + (Range * 1.1/4)
R2 = C + (Range * 1.1/6)
R1 = C + (Range * 1.1/12)
PP = (High + Low + Close) / 3
S1 = C - (Range * 1.1/12)
S2 = C - (Range * 1.1/6)
S3 = C - (Range * 1.1/4)
S4 = C - (Range * 1.1/2)

Camarilla pivots are mainly applied in the daily timeframe. They consist of the main pivot price as for the Standard pivots and four symmetrical resistance and support levels.

The Camarilla resistance and support levels use a slightly different focus to the standard pivots. There are two primary methods of employing them:

* Reversals at R3/S3: The resistance level, R3 and support level, S3 are the predicted levels to contain the daily price movement. The expectation is that R3 - S3 will hold as price approaches those levels and will reverse at R3/S3 suggesting a reversal sell at R3 and reversal buy at S3.

* Breakout at R4/S4: If price exceeds the R3/S3 range and moves beyond the resistance level, R4 or support level, assume it represents a major breakout suggesting a buy above R4 and sell below S4.




Cheers
Gaurav

yes Sir,
It is woarkin well after 1004 error

Thanx again for wonderfull soft
Jay

dear cool,
today, i made another trial and checked the progra. my observations:

1) NSE Data sheet : filter on last (close) price:
i have set the limit to 'more than equal to' 20.00.
apart from others, i got ANTGRAPHI.NS (0.35) & LML.NS (16.60) also into the next sheet.

2) similarly, with the filter on last(close) less than equal to 20.00.
apart from others, i got RNRL.NS (20.05, MAHABANK.NS (20.35) & GOLDTECH (20.75) also into the next sheet.

when vVOLUME less than or equal to 50,000 is set,
i got GUJFLUORO.NS (vol=51080), CALSOFT.NS (51042), INDRAMEDDC.NS (50896, NECLIFE.nS (50525, & KAKATCEM.NS (50228) also in to the next sheet.

volume more than or equal to 50,000 appears to be workinng ok.

3) series =EQ & TOTTRDVAL logics could not be checked, because those fields are NOT carried forward to next sheet.

4) some people expressed the doubt if the stock quotes obtained from yahoo through this program are live! i found taht at least some times, there is a time lag of 15 mins between the index quotes and the stock quotes(of course, it's a source linked issue). we get a clear picture when the quotes becomes delayed, it is better to download the time (tag=t1) also from yahoo and show it as a separate column.

5) i have another request. presently, we are downloading previous day's indices data from yahoo after the market hours of the previous day. for any reason, if i am not able to download in the evening, (the data changes in the night), my indices data will have error. instead, if we download the indices data from NSE historic data link, i will be able to download along with the EOD data, even after start of trading on the next day.

6) presently, the indices data are displayed in rows after the column heading. i feel, this sometimes is creating problem while sorting of data. i suggest that the indices data may be placed in rows above the column headings, so thet, any sort is done only on ALL the rows below the column heading. i hope, i clealy expressed the point.

these points, if accepted, may be addressed before the next release coming out shortly.

feel free for any clarifiaction on what all i said above.

all the best.
MurthyMSR

Hi All
Starting again on CI to fullfill some old promises.

Need some help here.
I need some small images in WMF format. I don't have the required software to create those images. Can any one help in creating these images and sending me?

I need images with size equal to the normal cell size of excel. The format should be WMF.

The images I need should have the words
SYMBOL
GAP
%CH
PP
VR
PVR
WOODIES
CLASSICS
AVGVOL
YL
YH

This images will be the header in the master sheet. Any help appreciated.

Best Regards
Coool.

Read the whole thread great work rajiv, I'm going to use your software to help me use ronalds technique, all i need is full gap up down and 11am high low which i thinl is already threre, I'm more than happy

keep up the good work

hey rajiv its not working for me i keep geting eroor 1004 application defined or object defined error when ever i press any button in gapana or coolworks

Oh Thats not normal
Atleast with gapana, there was no issues, as it is using none of excel new feature.
Please let me know about your office version.

Also, we will try it together sometime in the night.


Best Regards
Coool.

Hi Murthy sir
Do we have source from which we can get this data. Hisorical data I know you can get, but only if you have already reqested, then only that sheet is prepared.
Please help.

Best Regards
Coool.

dear cool,

the data for all the NSE indices for a range of days can be obtained from the link:

http://www.nse-india.com/content/ind...histvalues.htm

say for example, to get the OHLC values for NIFTY for the date 01Aug2006 is:

http://www.nse-india.com/content/ind...2006182006.csv

the format being : IndexName,FromDate,ToDate.

once we understand the syntax, we may be able to retrieve the values.

hope this answers.
all the best.
MurthyMSR

Hi Murthy
I am aware of this, but you can query this directly.
The format clearly shows that last part 182006182006 is (day, month, year)(day, month, year), but if you use it directly, it comes with error. However, if you go to the site, and query it and then come back and again use this format it will work.
(

I am trying to find something other, if anyone knows it, please help.


Best Regards
Coool.