oops sorry...

Hi Cooltetra
I would love to try the sheet and as i am in the software field may be i would be able to contribute a lil to the automation part

adilsalee@gmail.com

Hi CoolTera,
I'm also waiting for ur Excel sheet---Thanks in advance---for ur willingness to contribute ur works in this forum---
And By the way MurthyGaru---Do plz upgrade ur OS ---to Windows XP--Ha Ha---If u permit me---I m more than willing to send u all the necessary requirements ---
Regards,
joy_mitali

Hi Murthygaru

Don't accept the advise of joy. He just wants Microsoft shares ramped up so that he can invest in it and make cool profit by exiting at higher levels.

Since you are a long term loyal member for Team Dinosaurs you can wait for 64 bit monsters and window Viesta to decimate xp and establish firmly on users' real estate on the top of the desk. Till such time 98 is perfectly fine. If you want it run like sensex then add some memory like 1 Gb. That will do the trick.Do You know the little secret? our babu moshaya has joined microsoft in dumping xp on unsuspecting users.
With due apology to joy. Murthygaru will never change sides.

Regards
Pankaj

Hi Murthy
Thanks once again for the kind and encouraging words.

About the excel sheet and 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. Please note that I am not from Open System's background.

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 yahoo 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 Yahoo 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 close 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. 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@yahoo.co.uk
--------------------------------------------------------------------------

Your suggestions to improve this is highly awaited.



Hope you find it useful. In case of any compatibility issue, please let me know. We together will fix it.

Thanks once again for the opportunity given.

Best Regards
Coool.

Attached Files

GapAna.zip (81.3 KB, 95 views)

Hi Pankaj,
Really cool going---
MurthyGaru--Dont listen to pankaj---He is always planing to increase ur overheads---with all the GB---stuffs ---After all ---BabuMosais -----r always there for everyone---HA HA HA--
Thanks CoolTera for ur posting---
Regards,
joy_mitali

thanks, joy for the offer to help.
i have everything required for upgradation except the intention!

and ultimataly, all the generous programmers of this forum need a system available at your disposal, for testing the software developed for win98 compaatibility, i hope !

thanks joy, thanks pankaj for what all you said.

all the best.
murthymsr

hi cooltetra,

it's really cool, but not tetra, but nova (nine) times.

i found it to be basiaclly compatible with Win98 etc, as i requested in my earlier post ....

the chart is a cool adition, but is it live? i.e., without the 15 min delay after logging in? we have to check up !

you have about 900 stocks in the list. earlier yahoo had a ceiling of 200 per request. is the limit removed now? or you made an innovative workaround? just curious.

probably, you may be able to include segregation of stocks by pivot points too later.

your documentary support to the program also is commendable. not many coders have that orientation at the release itself.

i would like to congratulate you for your intention to share something with the members of the community.

all the best.
murthymsr

PS: i have one suggestion. please open a new thread in the software section and repost your message with the attachment. the will help many people to take the benefit.

Hi Murthy
Thanks once more for the encouraging words. My intention is to learn more and more from you all.

I have kept the things in QA style for clarity only.


Yes, It is Live. that is you have the complete layout ready, but gets populated with the time. I think it is 15 minutes bars.

I also thought, they had a ceiling of 200 per request. But, when I tried it did not allow me anything more than 70(near about).
So, this is in a loop, with just 52 scrip requested at a time.

I would love to do it. But, I am not sure about the segregation logic by the pivot points. And this sure would be a very great addition to it. Please tell me about how to go about it.

With encouraging words coming from some one of your caliber, now I have the confidence to start a thread. Will do it shortly.

Thanks a lot.
Best Regards
Coool.

boy oh boy we have a software guru onboard with stocks guru traits...a deadly combination.

@coool: thanks a billion mate...exactly what i wanted (dint know so many would be interested) only regret is........

lol...kidding...well coool regret is man you deserved your own thread something like cooolworks or cooolsoft tittle kya dada yeh sorry thread mein you put such good work... infact i'm expecting you have some more wonders like these hidden...comon out with...well thanks a lot...hope your innovation continues & maybe you develop a software service industry with service to finance sector...lol thanks again

@murthymsr: sir better wait it out for the next software teji to upgrade abhi no use upgrading for 1 year nahi to again you will get stuck just when the new one is coming...lol

Hello CZAR
I am sooooo excited. I never knew I would be getting such a response. The need was expressed by you in another thread, but thought you might not notice it in that thread. So, picked up one of your recent one. And kind of my way of saying sorry for the remark I had made to you, so no better thread than this. Moreover, seriously, I did not have enough confidence to start a new thread of mine.
Now, I am motivated enough to start a new thread soon. Will need to have a write up for that to go with it. Will do it tonight. And cooolwork is a good title.

The next plan is to have some thing on the resitance/support test and reversal.

Thanks again
Best Regards
Coool.