2 New Messages
Digest #2811
Messages
Tue Oct 15, 2013 8:34 am (PDT) . Posted by:
af3512b8ef4166b5c33401271c05da3c
Thank you !!!!
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Easiest way is to use RCHGetYahooHistory(). For example, this array-entered over a range:
=RCHGetYahooHistory("MMM",,,,,,,"v")
On Mon, Oct 14, 2013 at 4:50 PM, <johkouf@... mailto:johkouf@...> wrote:
Hello I am new to this amazing forum .
Could you please help me with Dividends download?
I want to download in a sheet all the available(or within a range of dates ) dividends and the ex-dividend dates ..
Which formula should I use for that ?
---In smf_addin@yahoogrou
Easiest way is to use RCHGetYahooHistory(
=RCHGetYahooHistory
On Mon, Oct 14, 2013 at 4:50 PM, <johkouf@
Hello I am new to this amazing forum .
Could you please help me with Dividends download?
I want to download in a sheet all the available(or within a range of dates ) dividends and the ex-dividend dates ..
Which formula should I use for that ?
Tue Oct 15, 2013 11:01 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
As Randy replied it is in the current SMF-ADDIN
Here is an example. As you can see only a few options work. I did not
investigate why.
Plus, I personally would not use an RSI(22,5) which is hardcoded in the VBA.
Welles Wilder, who created the RSI, used a value of 14 which still works
best in most cases.
You will need to determine what RSI value works best for your trading or
simply use it as coded.
In fact, Welles Wilder used a value of 14 in almost all the indicator that
he developed back in 1977
I recommend you checkout Wilder's Parabolic Stop And Reverse (PSAR)
indicator. It is a complete trading system all inclusive.
However, like any indicator you need to learn how it should be used and
follow its rules.
Before you use this function you should at the very least know how the
Target price is calculated and understand the logic behind it.
I looked t several stocks and none of the Buy Target Prices come close to
where I would be entering the stock.
So you will need some explanation from Randy on Buy Target price.
Kermit
MMM
Ticker is cell A2
Cells C5 thru C16 contain the formula shown below to retrieve the items list
in Cells B5 thru B16. Simply by changing "A5" to point to the corresponding
"A" cell
01
Current RSI
51.82
smfRSITargetPrices(Ticker,20,80,A5)
02
Buy Target Price
117.71
03
Sell Target Price
--
04
Last Traded Price
120.59
05
Bid Price
Error
06
Ask Price
Error
07
Open Price
Error
08
Low Price
Error
09
High Price
Error
10
Volume
Error
11
Previous Close
121.40
12
Previous RSI
93.73
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Roger Diaz
Sent: Monday, October 14, 2013 6:19 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] smfRSITargetPrices()
Sorry. You're right.
Could you include it in the current add-in?
Roger
Here is an example. As you can see only a few options work. I did not
investigate why.
Plus, I personally would not use an RSI(22,5) which is hardcoded in the VBA.
Welles Wilder, who created the RSI, used a value of 14 which still works
best in most cases.
You will need to determine what RSI value works best for your trading or
simply use it as coded.
In fact, Welles Wilder used a value of 14 in almost all the indicator that
he developed back in 1977
I recommend you checkout Wilder's Parabolic Stop And Reverse (PSAR)
indicator. It is a complete trading system all inclusive.
However, like any indicator you need to learn how it should be used and
follow its rules.
Before you use this function you should at the very least know how the
Target price is calculated and understand the logic behind it.
I looked t several stocks and none of the Buy Target Prices come close to
where I would be entering the stock.
So you will need some explanation from Randy on Buy Target price.
Kermit
MMM
Ticker is cell A2
Cells C5 thru C16 contain the formula shown below to retrieve the items list
in Cells B5 thru B16. Simply by changing "A5" to point to the corresponding
"A" cell
01
Current RSI
51.82
smfRSITargetPrices(
02
Buy Target Price
117.71
03
Sell Target Price
--
04
Last Traded Price
120.59
05
Bid Price
Error
06
Ask Price
Error
07
Open Price
Error
08
Low Price
Error
09
High Price
Error
10
Volume
Error
11
Previous Close
121.40
12
Previous RSI
93.73
From: smf_addin@yahoogrou
Of Roger Diaz
Sent: Monday, October 14, 2013 6:19 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] smfRSITargetPrices(
Sorry. You're right.
Could you include it in the current add-in?
Roger
Tidak ada komentar:
Posting Komentar