Formula Help

Discuss Formula Help at the F-Chart within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Hi to All I have just started using FChart Pro and I have Drawn two ...


Go Back   Traderji.com - Discussion forum for Stocks Commodities & Forex > TOOLS & RESOURCES > Software > F-Chart

Notices


Reply
 
Thread Tools
Sponsored Links
  #1  
Old 2nd March 2008, 09:24 PM
Member
 
Join Date: Mar 2008
Posts: 49
slah04 is on a distinguished road
Default Formula Help



Hi to All

I have just started using FChart Pro and I have Drawn two nos EMA, namely EMA2: 30 period and EMA3: 50 period along with RSI as an indicator

I would like to scan stocks for long when EMA2 crosses EMA3 for the first time AND when the RSI goes over 60 for the first time

Simlarly for scanning stocks for short

EMA3 crosses EMA2 for the first time AND RSI goes below 50 for the first time

Most important question is where do I put these formula: in the "Scanner"? If that is so, what should be the other conditions that have to fulfilled in the "Scanner Window"
Reply With Quote
  #2  
Old 2nd March 2008, 11:19 PM
Member
 
Join Date: Feb 2008
Location: Durgapur, West Bengal
Posts: 30
basab19 is on a distinguished road
Default Re: Formula Help

Sir,
You have developed two EMAs namely 30 Days EMA and 50 Days EMA. I think, if you use Window XP Professional system in your Desktop. Go to open a Excell worksheet. Put the Headings in sequence :
Date, Price Movements (High,Low and Close), RSI, 30-D EMA, 50-D EMA, Difference, Triggerline, Divergence.
> Download the required price data from nseindia.com
> Put the respective data under High,Low,Close.
> Prepare daywise RSI formula and copy down it.
> Prepare the 30, 50 EMAs under respective Headings.
> Compute the diff. of two EMAs under DIFFERENCE column.
> Prepare TRIGGER Line data (a 9-D EMA of Diff.), copy down it
> Last of all prepare the difference between DIFFERENCE & TRIGGER i.e.,
conveniently called the DIVERGENCE, but in reality it is HISTOGRAM.
You can view two series of SWINGS (UP & DOWN) if after painting through Mouse you go to GRAPH menu choose BAR GRAPH and enjoy the view. This is most accurate one and BUY when it Goes in DN SWING and sell when it goes UPSwing.
Reply With Quote
  #3  
Old 3rd March 2008, 08:05 AM
Member
 
Join Date: Mar 2008
Posts: 49
slah04 is on a distinguished road
Default Re: Formula Help

Thks. Shall try that. But is it possible in FChart PRO?
Reply With Quote
  #4  
Old 3rd March 2008, 09:09 AM
Member
 
Join Date: Jan 2006
Posts: 144
rhimadri is on a distinguished road
Default Re: Formula Help

Quote:
Originally Posted by slah04 View Post
Hi to All

I have just started using FChart Pro and I have Drawn two nos EMA, namely EMA2: 30 period and EMA3: 50 period along with RSI as an indicator

I would like to scan stocks for long when EMA2 crosses EMA3 for the first time AND when the RSI goes over 60 for the first time

Simlarly for scanning stocks for short

EMA3 crosses EMA2 for the first time AND RSI goes below 50 for the first time

Most important question is where do I put these formula: in the "Scanner"? If that is so, what should be the other conditions that have to fulfilled in the "Scanner Window"
You can scan stocks based on your selected parameters. Try the following formula for scanning:-

(1) EMA2 > EMA3 AND EMA2[1] < EMA3[1] AND RSI > 60 AND RSI[1] < 60

(2) EMA2 < EMA3 AND EMA2[1] > EMA3[1] AND RSI < 50 AND RSI[1] > 50

Please copy paste the formulas in respective in condition 1 & 2 and then start scanning to get your desired results.

Cheers

Himadri
Reply With Quote
  #5  
Old 3rd March 2008, 09:26 AM
Member
 
Join Date: Mar 2008
Posts: 49
slah04 is on a distinguished road
Default Re: Formula Help

Thks Himadriji. But where do I copy and paste the formula? In the "Scanner" Window? or the main chart window where there are numbered 1,2 3 & 4 text boxes?
Reply With Quote
  #6  
Old 3rd March 2008, 09:34 AM
Member
 
Join Date: Jan 2006
Posts: 144
rhimadri is on a distinguished road
Default Re: Formula Help

Quote:
Originally Posted by slah04 View Post
Thks Himadriji. But where do I copy and paste the formula? In the "Scanner" Window? or the main chart window where there are numbered 1,2 3 & 4 text boxes?
Copy paste the formula in formula entry box by left mouse clicking on (1) or (2) on main window & write formula. Name the formula and copy paste the formula in formula builder box. Please go through help file and you will find everything is written in very simple language.

Cheers

Himadri
Reply With Quote
  #7  
Old 3rd March 2008, 11:05 AM
Member
 
Join Date: Mar 2008
Posts: 49
slah04 is on a distinguished road
Default Re: Formula Help

Dear Himadriji

Instead of using RSI[1] < 60 how can I put a formula for the same day RSI to be between 50 and 70
Reply With Quote
  #8  
Old 3rd March 2008, 11:12 AM
Member
 
Join Date: Jan 2006
Posts: 144
rhimadri is on a distinguished road
Default Re: Formula Help

Quote:
Originally Posted by slah04 View Post
Dear Himadriji

Instead of using RSI[1] < 60 how can I put a formula for the same day RSI to be between 50 and 70
You can write (RSI[1] < 70 AND RSI[1] > 50) INSTEAD OF RSI[1] < 60

Himadri
Reply With Quote
  #9  
Old 3rd March 2008, 11:55 AM
Member
 
Join Date: Mar 2008
Posts: 49
slah04 is on a distinguished road
Default Re: Formula Help

Thks. It worked. Can I add another AND condition with the existing formula, like for the Chaikin Oscillator?
Reply With Quote
  #10  
Old 3rd March 2008, 12:29 PM
Member
 
Join Date: Jan 2006
Posts: 144
rhimadri is on a distinguished road
Default Re: Formula Help

Quote:
Originally Posted by slah04 View Post
Thks. It worked. Can I add another AND condition with the existing formula, like for the Chaikin Oscillator?
You can add other condition also to filter more but scanning will be slow. I think if you add CCI formula also with the same formula you may find some effective results. However its upto you on what condition you will stress. If you add CCI formula with your existing formula, You can try to add this in condition 1 & 2

(1) AND CCI > 100 AND CCI > CCI2

(2) AND CC1 < 100 AND CCI < CCI2

If you have condition for Chaikin oscillator, please let me know so that I can also try for the same.

Cheers

Himadri
Reply With Quote
Sponsored Links


Reply

Bookmarks


Advertise Here


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


All times are GMT +5.5. The time now is 07:35 AM.

Indemnity, Disclaimer & Disclosure Notice:
• By visiting Traderji.com you indicate your acceptance of our Forum Rules Disclaimer & Disclosure and indemnify Traderji.com, its associates and related parties of all claims howsoever resulting from the usage of the forum.
Disclaimer: Trading or investing in stocks & commodities is a high risk activity. Any action you choose to take in the markets is totally your own responsibility. Traderji.com will not be liable for any, direct or indirect, consequential or incidental damages or loss arising out of the use of this information.
Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein. The writers may or may not be trading in the securities mentioned.
• All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy of information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. If you find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
 


Copyright © 2001 - 2008, Traderji.com All Rights Reserved.

Recommended Websites - www.TradersEdgeIndia.com - www.TradingPicks.com - www.MasterOfTrading.com