CoolWorks

cooltetra · #**101** 17th August 2006, 02:18 AM

CoolRC

Improvements over ToAB.

Added support for Fchart.
Will only add data to AB, if volume is greater than zero. This automatically take care of the market close issue.
Will check and run only when Amibroker is running. FChart users can also use it but that need to be specified explicitly.Refer to FChart sheet for the help on configuring Fchart with this sheet.
Auto start as per market start and stop time has been attempted. However not throughly tested.Works on the test machine.This starts the data collection as the market start and stops at the time specified.

Some DONTs

Do not alter anything in columns marked in pink on the setup sheet.
Do Not change the name of the sheet in any case. The program will not work.
Do not alter the HelpSheet content. Doing so may make this unusable.
This sheet cannot be sold, modified or reused in any other form.
You can distribute it at your free will.
Author does not seek any payment for this sheet. However encouragement is expected and will be appreciated.This will help in future developments and enhancements of related tools.
The author does not take any responsibility of any loss you may face because of using the sheet either directly or indirectly. Use at your own discretion.

Credits to : MurthyMSR for FCHART configurations

Help on setting up the sheet is there in the help sheet. You can also refer
the original posting for ToAB for general setting.

Known Bug: If you start late, the first volume will be the commulitive volume till that point. This entry should be deleted/edited using the Quote Editor.

You can download the sheet from the first post in this thread.

A good coincidence, 100th Post in the thread, and my 200th post. :-)

Best Regards
Coool.

P.S. Free does not mean cheap. Hours has gone into it before reaching your hand.

inxsofme · #**102** 17th August 2006, 04:11 AM

Hello brother,

Thanx for the utility, though i've not yet checked but i know that as usual this will also be of immence help. Now i know where u were busy. Ur hard work is highly appreciated.

Keep up the good work

Gaurav

murthymsr · #**103** 17th August 2006, 07:47 AM

Quote:

Originally Posted by cooltetra

...................
You can download the sheet from the first post in this thread.

A good coincidence, 100th Post in the thread, and my 200th post. :-)

P.S. Free does not mean cheap. Hours has gone into it before reaching your hand.

dear cool,
congratulations, cool, on the release of next version, which provides support to FCharts also, in additions to improvements.

it's a good idea to place the latest version also at the first post, so that the links provided by me at the software section will continue to work.

it's true that many hours have to be spent before a software is released.
free does not mean cheap. it reveals the generocity of the developer. though it is free, members may pay it in words. members may use it and post their observations. it is that support cool is asking.

one request, to all users. please use with discretion. please set the refresh interval to as high as you may perceive it to be usefil. because the source ***** is free and we all together may not create problems to it's servers.

thanks cool, for the software. may God bless you for this.

MurthyMSR

murthymsr · #**104** 17th August 2006, 10:19 AM

hi all,
ATTENTION: CoolRCv1.1 users with FCharts:

while customising CoolRCv1.1 with FCharts, you may set the Time column as 'E' or 'I' but NOT 'F' as indicated in the FCharts Help. this change is because of change in column layout in the new version. rest all as indicated in help.
i found the program working with FCharts at this moment on my system.

all the best.
MurthyMSR

pkjha30 · #**105** 17th August 2006, 11:50 AM

HI cool

Congratulations on your efforts.This software would be of great help to all members. Your contribution is not unnoticed in the forum. There may be many silent and thankful members using your utility.Your mere presence and generous attitude makes this forum a worthwhile place to visit.I will surely check it out and tell you if anything more is required .

Pankaj

SGM · #**106** 17th August 2006, 11:53 AM

Great going cool

Quote:

"Cool is as Cool Does"

Hello

Beside using for intraday data feed, gap trading and stock ticker the sheet provided by cool also can be used to track the portfolio real time.

We can attach a sheet with our portfolio and add a column with title CMP (current market price), thus enabling us to calculate besides other things RRR, SL values, Profit/Loss targets both in terms of % and Rupee value. In this way we can check out/apply our rules for money management, position sizing, what-if-analysis or Stops in real time.

Regards
Sanjay

inxsofme · #**107** 17th August 2006, 01:52 PM

Hey brother,

I tried to use it today but it shows that "some tampering attempted or the file has got corrupted the sheet cannot be used". plz help desperately waitin.

Also attach a file containing ***** symbols in ur sheet will come handy to all the users of the sheet before it gets spread. i am attaching it for ur reference this will help the admirers of ur utilities and hope to see some more soon. Ur knowledge of excel is proving as a blessing for the members.

Gaurav

cooltetra · #**108** 17th August 2006, 10:31 PM

Quote:

Originally Posted by inxsofme

Hey brother,

I tried to use it today but it shows that "some tampering attempted or the file has got corrupted the sheet cannot be used". plz help desperately waitin.

Also attach a file containing ***** symbols in ur sheet will come handy to all the users of the sheet before it gets spread. i am attaching it for ur reference this will help the admirers of ur utilities and hope to see some more soon. Ur knowledge of excel is proving as a blessing for the members.

Gaurav

Hi Gaurav
Did you check your PM. I had left one message for you there. Please download again and try the sheet.

Best Regards
Coool.

cooltetra · #**109** 17th August 2006, 10:36 PM

Quote:

Originally Posted by SGM

Great going cool

Hello

Beside using for intraday data feed, gap trading and stock ticker the sheet provided by cool also can be used to track the portfolio real time.

We can attach a sheet with our portfolio and add a column with title CMP (current market price), thus enabling us to calculate besides other things RRR, SL values, Profit/Loss targets both in terms of % and Rupee value. In this way we can check out/apply our rules for money management, position sizing, what-if-analysis or Stops in real time.

Regards
Sanjay

Hi Sanjay
Could you please elaborate on your above mentioned points. May be I can include what you are suggesting.

Best Regards
Coool.

cooltetra · #**110** 17th August 2006, 10:40 PM

Quote:

Originally Posted by pkjha30

HI cool

Congratulations on your efforts.This software would be of great help to all members. Your contribution is not unnoticed in the forum. There may be many silent and thankful members using your utility.Your mere presence and generous attitude makes this forum a worthwhile place to visit.I will surely check it out and tell you if anything more is required .

Pankaj

Hi Pankaj
People like you are the reason that keep me motivated enough.
Thanks a lot for what you all do here.

Best Regards
Coool.