Recent content by rharmelink

  1. R

    Best RSI parameter (or other indicator) for 5 day hold

    RSI(2) has tested well for me on Portfolio123.com weekly rebalancing (using opening prices following the weekend)... For example, using the DJIA stocks gives a CAGR of 21.6% from 1999 to today, versus 6.1% for B&H on SPY. Average holding is 3.7 stocks with 64% turnover. The only rules I used...
  2. R

    5 years eps info ??

    Have you looked at AAII's Stock Investor Pro database? It has a lot of data you can play with. For more advanced and point-in-time screening and backtesting, I'd recommend Portfolio123.com.
  3. R

    fundamentals feed to Excel

    Two that I'm aware of: http://www.advfn.com/p.php?pid=financials&btn=annual_reports&symbol=MMM http://www.gurufocus.com/financials_print.php?symbol=MMM
  4. R

    fundamentals feed to Excel

    You could try my free open-source add-in: http://finance.groups.yahoo.com/group/smf_addin/ It's primarily a set of user-defined functions to extract data from the Internet.
  5. R

    Buying OOM Options naked

    Naked really isn't a concept to apply to buying options. When buying an option, you can't lose more than you've invested in the option. But if you sell an option, you are exposed to further losses -- unless those potential losses are covered by something, they are naked.
  6. R

    Parabolic SAR in EXCEL

    Sorry, but I've not done it. I don't see a reference library available...
  7. R

    Parabolic SAR in EXCEL

    Sounds like you didn't download and activate the TA-Lib add-in. The TA_SAR() function is not an EXCEL function, but part of that add-in.
  8. R

    Parabolic SAR in EXCEL

    On the TA-Lib forum, there is a mention of "does not support Excel 2007 row/column limits" -- so that's probably why you have the issue at 65000 lines.
  9. R

    Parabolic SAR in EXCEL

    Array-entered formulas are actually pretty easy when you get used to them. For example, if: -- Daily high prices are in the range E4:E27 -- Daily low prices are in the range F4:F27 -- Desired Acceleration (or Step) Factor is in cell G1 -- Desired Max Acceleration (or Step) Factor is in cell G2...
  10. R

    Parabolic SAR in EXCEL

    Why reinvent the wheel? It's in the free TA-Lib EXCEL add-in: http://ta-lib.org/index.html Just download the ta-lib-0.4.0-msvc.zip file from their site and look for the XLL file in the EXCEL directory of the ZIP file.
  11. R

    where can i find charts im looking for?

    How about a CandleGlance group on StockCharts: http://stockcharts.com/scripts/php/candleglance.php?$INDU,$COMPQ,$SPX,$RUT,$TRAN,$WLSH,$CRB,$USD|C
  12. R

    Candlestick Pattern Site?

    You could try: http://americanbulls.com/StockPage.asp?CompanyTicker=DJIND&MarketTicker=NYSE&Typ=I
  13. R

    Stock screener based on tech. Indicators

    Take a look at stockfetcher.com
  14. R

    Darvas did ok

    Depends on who you believe. Supposedly Darvas fled the country when brought up on charges of fraud related to his book. http://www.traderji.com/technical-analysis/9081-excerpt-how-i-made-2-000-000-stock-market-darvas.html#post63106
  15. R

    FireFox is screwing up my trades.

    Do you use add-ons with FireFox? There have been a few complaints about CPU bumps from people using the Folders4Gmail GreaseMonkey script. For example: "I have tried the new version now on two different computers. Both are Windows XP SP3, Firefox 3.5, Greasemonkey 0.8.20090123.1. In both...
Top