CoolWorks

cooltetra · #1 6th June 2006, 12:48 AM

Hi All

With encouragements from some of the very senior respectable members, I had started this thread. The aim was to learn about trading from the experts out here and to contibute in what ever way I could, in the way I can.
The content of this post needs to be changed, as I feel, it would be better to club all those attempts at one place.

My first attempt was an excel sheet that could give the details of the scrips traded on NSE/BSE (A predefined list)GAPAna. The aim was to trade the Gaps intraday.

The second sheet was CoolIntra, a sheet with some enhancement over GapAna and pivot tradings intraday.

The need expressed by some of you who used the sheet made me think of intigrating/ using some established TA software and that lead to the birth of ToAB, a sheet that pumped data into Amibroker.
The need to support FChart was expressed and this is the reason for the change of name of ToAB to CoolRT. The original postings related to ToAB can be found at ToAB.
The improvements to ToAB can be found at CoolRT.

I will be posting all the improvements of all these sheets at this place only.

The original post of this thread has been moved to the Original Post

Best Regards
Coool.
Comments and Suggestions always welcomed at cool_tetra@*****.co.uk

P.S. Don’t embarrass me by asking for the passwords for the sheets. If you need to discuss the logic you may please PM me.

Czar · #2 6th June 2006, 02:44 AM

congrats mate... great job.... finally got the chance to use the xl...boy I must say great work & great effort you have put in...Salute

pkjha30 · #3 6th June 2006, 09:10 AM

Hi Cooltetra

Very good job indeed. THIS WILL BECOME FIRST OF THE MUST DO WORKS FOR MEMBERS AFTER MORNING PRAYERS
Congrats.
Pankaj

cooltetra · #4 7th June 2006, 01:50 AM

Quote:

Originally Posted by Czar

congrats mate... great job.... finally got the chance to use the xl...boy I must say great work & great effort you have put in...Salute

Thankyou sir, You are the reason.

cooltetra · #5 7th June 2006, 01:53 AM

Quote:

Originally Posted by pkjha30

Hi Cooltetra

Very good job indeed. THIS WILL BECOME FIRST OF THE MUST DO WORKS FOR MEMBERS AFTER MORNING PRAYERS
Congrats.
Pankaj

Thanks Pankaj,

Your encouragement means a lot to me.

Request others to put there comments too. I am sure, implementing your ideas will in turn give me better understanding of the market.

With best regards
Coool.

rakesh4urs · #6 10th June 2006, 12:21 PM

hi really very good work..actually i also use this method ..and make profit..but do this thing manually calculation..it takes time so i do for some selected scripts..u have automated this systm..so all scripts is scaned...apart from this i also calculate low price ,heigh price for nest day which is based upon previous day data,,,which is 95% correct prediction..if u give password of this sheet so i can add extra featurs,,pivot..heigh, low for next day only..or tell me how u fetch this data from server...give adject link of server,,,also if i want current price of a script in excell sheet...what i have to do...if all this thins get completed..my excell utility will give buy..sell signal automatically...hope u will help me ...thanks

Quote:

Originally Posted by cooltetra

Hi All

With encouragements from some of the very senior respectable members, I am starting this thread.
I have assembled an excel sheet that can prove useful to get details for scrip price action during the trading hours. I use it for the GAP trading strategy.

For gap trading strategy visit http://www.stockcharts.com/..Strategies1.html

The original post referring to the sheet is at http://www.traderji.com..oops-sorry-4.html.

This is kind of repetition post, but I think will look more appropriate in this software section.

------------------------------------------------------------------------
About the excel sheet and it's compatibility

The excel sheet is not using any third party component. The only component that I have used is Microsoft WebBrowser component which I think should be available with all Microsoft Windows/Internet explorer user. This component is used to display charts for the scrips. If this causes problem, we can think of some alternatives.
The excel works fine on Windows XP. However, If we have any compatibility issue, with the help of you all, we will find some work arround.

We will be downloading some 100 KB of data every morning. For me it takes less than a minute to be ready for the day. Those working with Dialup may face some delays.
---------------------------------------------------------------------
I am including the "Read Me First" part, which I have put as the first sheet. Please consider it as the Disclaimer too.

Read Me First
For the Day
You must be logged in to ***** to get the Real time Detail. Otherwise, the quotes are delayed by 15 minutes.
The Refresh button gets the latest data as of the current time.

For the first time, use the Refresh button on master sheet to get the previous trade day data. Currently we have the data as of 2 June 2006. The other set of data under previous day is some manipulated data. Do not use it for any real trading use.. Run it around 10:05 to get the details of the opening price details for the day assuming that you have already logged in. If you dont have ***** ID, or dont want to log in, use it after 10:15 AM.
The Gap button compares the opening price with the previous days OHLC to decides on the gaps. Gapped sheet contains only Full Gap up or Down list.
The Chart sheet can be used to see real time chart(its delayed by 15 mins even if your are logged in) by selecting the scrip from the combo box. Currently it only allows to look for full gapped scrip. This is not a limitation. Its my personal preference to see only the one that have gapped up or down. If the general view is to get charts of all, I will modify it accordingly.

Legends

Higher than prev day last but lower than prev high -------> partial up gap ---> PU
Higher than prev day high --------------------------------> full gap up ------> FU
Lower than prev day Last but higher than prev day low ---> partial low gap --> PL
Lower than prev day low ----------------------------------> full gap down ----> FL

Preparing for the next Day
Copy today's data over to the previous”previous” day data. Use the Copy2Prev button.

Note:
The Master sheet has the details of most of the scrip traded on NSE. It is not all.
HW/SW Requirements:
The sheet has been developed on Windows XP/ Excel 2000. I have not tested it on any other configuration. But, it should work fine on all windows platform.

Disclaimer
I have not cross checked all the data that is returned by the code. Error handling is at the least. You should believe the data provided at your own risk.
The sheet can get stuck if you do not have access to the internet connection and try to refresh data.
I assure you that there is no malicious virus embeded. However please run your virus scanner.

Credits
Traderji.com ,StockCharts.com for the gap trading strategy.
Amit's Mystock tracker. It has been the starting point.
Google for most of the how tos.

Comment & Suggestions
cool_tetra@*****.co.uk
--------------------------------------------------------------------------
Please note that the attachment here is different from the one in the original post which includes some of suggestions from Murthy.

Check it today to get a feel of what information you could have at the start of the day.

I had to use WinRar as it provides greater compression. In case you don't have winrar, you may download the same from http://www.rarlab.com/

Please do provide your comments.

Best Regards
Coool.

cooltetra · #7 10th June 2006, 06:25 PM

Quote:

Originally Posted by rakesh4urs

hi really very good work..actually i also use this method ..and make profit..but do this thing manually calculation..it takes time so i do for some selected scripts..u have automated this systm..so all scripts is scaned...apart from this i also calculate low price ,heigh price for nest day which is based upon previous day data,,,which is 95% correct prediction..if u give password of this sheet so i can add extra featurs,,pivot..heigh, low for next day only..or tell me how u fetch this data from server...give adject link of server,,,also if i want current price of a script in excell sheet...what i have to do...if all this thins get completed..my excell utility will give buy..sell signal automatically...hope u will help me ...thanks

Hi Rakesh

Try some guess work, u know enough about me to be right with it.

In case you want me to tell u the password, drop a mail at the id given.

Quote:

also if i want current price of a script in excell sheet...what i have to do

Simple, refresh it once more using the Refresh Button, do not use the Gap button. It will get u the detail of the current price of all the scrip (assumed u are logged in)

Thanks for taking interest in the sheet.

Best Regards
Coool.

cooltetra · #8 10th June 2006, 07:08 PM

Hi All

I have got some very valuable inputs from a respectable border to enhance the excel sheet. And I am currently working on implementing the same.

Some of the features you can expect in the next versions are
1. For preparation work for the next day...
Facility to scan and select scrip that meet your requirement on the basis of
i. Last traded price greater (to disqualify the penny stocks or the elephants

)
ii. Total traded value (to avoid the ones which are traded less)
iii. Others, which my non trading mind can think of.
This aims at reducing the watch list and the downloads.
2. The features of intraday support and resistance levels. I plan to use the Woodie’s pivots for the same.
3. Additional color coding to indicate the current position of the scrip regarding its intraday support or resistance.(This will be using the pivots for the coloring)
4. Grouping of the scrip on weather they are range bound, above the R1/R2 level or S1/S2 level.
5. Parameters like %Change
6. We will be using the NSE bhav copy for the preparation so as to have the closing price.

And other ideas which you may think of sharing

192 views, 49 downloads and 2 comments

.
Didn't we have any compatibility issue either?

With best regards
Coool.

murthymsr · #9 10th June 2006, 11:07 PM

Quote:

Originally Posted by cooltetra

Hi All
..................
And other ideas which you may think of sharing

192 views, 49 downloads and 2 comments

.
Didn't we have any compatibility issue either?

With best regards
Coool.

hi all,

comments/views is only 1%.

i think it is worth to make a try of the posted XL sheet & offer suggestions / feature requests. by this you will get what you have been wanting to have and the best thing is ....

cool_tetra was graceous enough to make the XLSheet available free.

please contribute and you will have a tailor made solution to all your needs, rather than a ready made solution, which may or may not fit your needs.

the XL sheet is in the development stage and this is the best time to make a feature request.

murthymsr

coolcocky · #10 16th June 2006, 03:57 PM

i use your worksheet and it is really great. however, i have modified it a little by adding more formulas. however, the formulas are lost when i refresh the data.

i am attaching your excel file as modified by me which gives more data without much work. see if it is useful as sugesstion.

do not refresh the data as the formulas in gap sheet would be lost. however, the same can be copies from formula sheet.

also can you think of using average volume instead of last volume in my formula.