CoolWorks

sai20_2000 · #**141** 27th September 2006, 01:01 PM

HI Cool,
Iam working on WIN2K OS and excel2002, I have done all the instructions as you have saidin help file (incld putting the format file).
The excel do fetch RT data but AB is not getting updated. Wht may be the prob? Pls advise
regards

cooltetra · #**142** 28th September 2006, 10:40 PM

Quote:

Originally Posted by sai20_2000

HI Cool,
Iam working on WIN2K OS and excel2002, I have done all the instructions as you have saidin help file (incld putting the format file).
The excel do fetch RT data but AB is not getting updated. Wht may be the prob? Pls advise
regards

Hi Sai
Did you downloaded and put tthe format file, idclose.format in Amibroker format directory?
And are you looking at database that has been configured as intraday with periodicity as tick.

Best Regards
Coool.

rhimadri · #**143** 26th October 2006, 08:41 AM

Quote:

Originally Posted by cooltetra

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.

I WOULD APPRECIATE IF YOU PLEASE PROVIDE ME A LINK FOR DOWNLOADING COOLRT COMPATABLE FOR FCHART. BEST REGARDS

rhimadri · #**144** 26th October 2006, 01:59 PM

Quote:

Originally Posted by murthymsr

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

DEAR SIR,

PLEASE LET ME KNOW THE LINK FOR DOWNLOADING CoolRCv1.1 AS I COULD NOT FIND THE SAME IN THIS SITE.

BEST REGARDS

HIMADRI ROY

murthymsr · #**145** 26th October 2006, 04:06 PM

Quote:

Originally Posted by rhimadri

DEAR SIR,

PLEASE LET ME KNOW THE LINK FOR DOWNLOADING CoolRCv1.1 AS I COULD NOT FIND THE SAME IN THIS SITE.

BEST REGARDS

HIMADRI ROY

hi himadri,
you may visit:

http://www.traderji.com/54514-post1.html

for this and other sw made available at this site by generous contributors.
murthymsr

rhimadri · #**146** 4th November 2006, 11:46 AM

Quote:

Originally Posted by murthymsr

hi himadri,
you may visit:

http://www.traderji.com/54514-post1.html

for this and other sw made available at this site by generous contributors.
murthymsr

Dear Sir,

I did not find your software CoolRCV1.1 suitable for FCHART in the above link. I would appreciate if you please let me know the link for downloading. I want to see intraday chart in FCHART with yahoo data.

Best Regards

Himadri

cooltetra · #**147** 5th November 2006, 03:25 AM

Hi Himadri
The link is there in the the first page itself of this thread. You will need to do a bit of settings as suggested by Murthy Sir so that you can have the charts in FCharts. I guess you are getting a bit confused by the name CoolRC and CoolR, they are the same( a typo).
Do let me know in case you find any difficulty in setting up the same. But the best person to help here will be Murthy sir as he has tought me how to set it up with FCharts.

Best Regards
Coool.

rhimadri · #**148** 5th November 2006, 09:07 AM

Dear Sir,

Please let me know specifically which software I will use for downloading intraday data from yahoo with Fchart integration. I would appreciate if you please clarify the same and provide me the link.

Regards

Himadri

Tipss_Bse_Nse · #**149** 2nd December 2006, 01:56 AM

dear sir

very good work

i want one clarification regarding refresh

is it possible to add the autorefresh for intraday button

regds
Tipss_bse_Nse

Quote:

Originally Posted by chachi

Hi MurthySir & Cool,

Inspired by cooltetra I have developed a Stock chart viewing xls file. Please go thru the attachment. If it is of any help, I will be glad. The charts are from yahoo site and hence there are some delays of about 15 minutes (too much!!!) for Intraday, and 5 day charts. 3 Month chart also surprisingly is not being properly updated by yahoo and it lags about 1 day.

I have also tried various other sites like NSE and BSE for the charts, problem being very slow loading in comparision to yahoo. But the data will not be lagging much from BSE & NSE site. May be cooltetra may try from NSE/BSE sites for loading charts. Presently as a sample I have given chart from Yahoo site.

Once again I emphasize here that I could do this only by getting some clue & lots of inspiration from cooltetra's efforts.

the macro is available on the Sheet (not in the module)

Regards
Chachi

rkgoyal_98 · #**150** 20th December 2006, 05:38 PM

Hi all

This is regarding the post that with CoolRC the quotes are not delayed if we are logged on to Yahoo. I have tried the following with the results also indiacted. Kindly tell me if i am doning anything wrong.

Opened in.finance.yahoo.com
Loged on with my Yahoo ID

Opened ambibroker with database already set
Opend CoolRC and started fetch

The columns were got filled with data and data of the indexs started to change after mrket opened, however data of the scripts didi not change.
Data of the scripts started changing after 15 minutes.

Yesterday i had not logged on in.finance.com and the results were the same
kindly tell me if the lag of 15 minutes can be done away with, if so what i need to do

Thanks

Rajeev