buy sell signal in excel

Hi friends & seniors,

Can any one help me.

I want to know whether buy / hold / sell signal can see in excel sheet itself by using yahoo.

It is for intra / short term / long term.

If so pls do let me know.

Thanks.
akx

u can device a strategy and use this excel Sheet.

http://www.traderji.com/software/7269-yahoo-auto-refresher.html


Thanks

Thanks for your imm response,

I have downloaded the file, But it is not working. I am not able to install it.

Pls guide.

Thanks

Seems to be working fine in my case.

Here, this is the EXCEL file, mebbe you were not able to un-rar properluy

You may want to join this forum. But you yourself have to be good at Excel in order to use the ideas and files you may get from them - http://tech.groups.yahoo.com/group/xltraders/

I am also attaching a file written by someone else on some other forum, which can download Yahoo data and generate signals based on couple of built in formulae. However, it limits you to use whatever is there in the sheet. Unless you can build your own exit, entry formulae, you cannot benefit from this.

In case you would like to pay some money, you can try AnalyzerXL. Its a paid program but there is a few days free evaluation period. It uses Yahoo data and has lot of inbuilt indicators and rules to generate trading signals.

dear alpha,
thanks for the file, but from this how can i find buy sell signals? pls help & adv.


Dear Cramer,
I have already joined this group, i am trying to find out the files, I am just going thru' the file.

& Dear swagat86

I really thank to u all friends, I thought i never get response from anybody, but you people are really great. Thanks a lot for the concern and care.

Friends, pls do help me on the above subject.

Thanks ... akx

You cant.

If you wanna get somethign that shows buy-sell signals - check some free softwares like AptiStock, Fibotrader etc - which makes a chart of the scrip quotes and gives you teh option of inserting trade flags onto the chart.

Ofcourse there are better software (and they cost a fortune) that indicate more rigourously and elegantly.


If you are willing to trust MACD to give you buy and sell signals (which I dont trust), then you can use an excel sheet by one of the forumites here.

I dont remember the thread though. Hopefully, that member would drop in by this thread and help.

ok.

but aptistock shows 2 days delayed data. Is there any way to get it.

However, if u get soemthing pls adv me the same.

Thnk u.

Download the utility called Data Extractor from www.investbulls.com .
It Downloads EOD from NSe Site and converts it into TXT file which is acceptable by any SW.


and regrding getting Signals in Excel u just need to put a few Formulas in place. Im sure u know the basics. lets say for example, a strategy called gap can be used. Try lookin for a sheet in Coolworks thread in Software section which is meant for Gap trading(Intrday) developed by Cooltetra.


Thanks

dear swagat,

Thanks for the support buddy,

In that website i have registered, it has to get approved.

I am waiting for the approval, once i download the file, I will let you know the things.

Once again thank you very much. Will get back to you.