BFreshour
139 posts
msg #38919
- Ignore BFreshour |
11/16/2005 3:14:12 PM
Since SF doesn't provide real time data and the stockcharts.com scan leaves A LOT to be desired, I was wondering if anyone could help me calculate RSI(2) on the fly. I know the formula but it doesn't seem to work correctly. Perhaps I'm doing something wrong.
Does anyone have any experience in building a spreadsheet that could calculate RSI(2) on the fly by entering the current price (based on historicaly close prices)?
I know that sounds confusing and probably is more trouble than it's worth. SF would be a life saver with real time data... UGH!
|
TheRumpledOne
6,529 posts
msg #38923
- Ignore TheRumpledOne |
11/16/2005 3:28:58 PM
TradeStation does it.
And with their new reduced rates, you get the platform FREE if you trade enough.
In fact, just open a FOREX account and do 10 round trips a month and the platform is free... only takes $5,000 to OPEN the account and $1,000 or so to maintain it... meaning open the account, and then pull most of your money out.
HTH
|
BFreshour
139 posts
msg #38924
- Ignore BFreshour |
11/16/2005 3:30:40 PM
What about calculating the EMA of RSI(2) on the fly?
In particular, I'm interesting in the EMA(3) of RSI(2) vs the EMA(13) of RSI(2).
Weird combo, I know. I'm crazy.
|
jclaffee
81 posts
msg #38926
- Ignore jclaffee |
11/16/2005 4:15:31 PM
BFreshour. . .
First, let me say that I owe my interest in the use of RSI(2) as an oscillator to the advocacy of TheRumpledOne!
Second, it is very important to my trading and I use eSignal's MarketCenter Live at about $29 per month solely to have it in real time (in a spread of intervals) through the day.
I've tried with limited success to calculate it in Excel for myself and have decided that this way suits me best.
Jim
|
BFreshour
139 posts
msg #38928
- Ignore BFreshour |
11/16/2005 5:07:58 PM
I would gladly pay $29 a month. I currently have the following:
StockWatch.com Streaming Quotes (for QuoteTracker) $20 a month
StockCharts.com Advanced Charting with Real Time $30 a month
StockFetcher Advanced $17 a month
If I could get rid of all three of those for eSignal.
My next question is about the computation of that EMA of the RSI(2).
|
BFreshour
139 posts
msg #38929
- Ignore BFreshour |
11/16/2005 5:27:31 PM
My thoughts haven't really been concise. This is what I'm looking for:
Real-time ability to search daily charts for an EMA(RSI(2),3) cross-over of EMA(RSI(2),13).
Don't ask why the strangeness of the indicator, I'm a little odd-duck myself.
|
BFreshour
139 posts
msg #38930
- Ignore BFreshour |
11/16/2005 6:58:20 PM
Apparently I don't understand EMA's or there's a bug with SF. Check out this...
Pull up any stock on that list and look at the crossover of r on s on the graph. Nearly everytime it crosses it predicts a move of value. Are the EMA's taking into account the next days RSI value? I'm confused.
|
TheRumpledOne
6,529 posts
msg #38931
- Ignore TheRumpledOne |
11/16/2005 7:50:34 PM
You have yourself a very fine filter!
I ran the above as a test.
To use it for real use this line:
r crossed above s
instead of the 1 day ago version.
MAY ALL YOUR FILLS BE COMPLETE.
|
dkatz
64 posts
msg #38933
- Ignore dkatz |
11/16/2005 8:50:52 PM
Avery -- trying to run the filter with "r crossed above s", getting 0 hits. Would also like to add RSI(2) less than 5 1 day ago as that really pinpoints the entry ... what am I doing wrong here? It's clearly an awesome filter though. Congratulations BFreshour -- this one is a keeper!
|
JohnyYuma
60 posts
msg #38935
- Ignore JohnyYuma |
11/16/2005 9:10:20 PM
Folks
my programming knowledge is pretty rudimentary
but
try using specific names for the variables instead of generic alphabet letters - and it might work
e.g. rsi2 instead of r............ etc.
Hope this helps
Thanks
|