Minggu, 05 Juni 2016

[smf_addin] Digest Number 3720

5 Messages

Digest #3720
1a
1b
Re: Highest Quote between Dates by "Randy Harmelink" rharmelink
1c
1d
Re: Highest Quote between Dates by "Randy Harmelink" rharmelink
1e

Messages

Sat Jun 4, 2016 7:09 am (PDT) . Posted by:

ridgebacksexcel

Randy,


Thanks for the tips. I understand now about the adjusted closing price.


Also I will use =DateValue(RCHGetYahooQuotes("SPY","d1")) instead of =Today() in my spreadsheet to speed things up. Great tip.


I think the easiest price I should track is the historical High Adjusted close price for a stock.


I have this formula for now as an example:


=MAX(RCHGetYahooHistory(INTC,2014,1,6,2016,6,3,,"A",0,,,200,1))) which returns: $34.83


The documentation for the RCHGetYahooHistory does not discuss the Pdim1 and Pdim2 items.


I assume PDim1 is the number of days it can look back. In the formula above that would be 200. I will need to go farther back. What would be the maximum number to enter here? If I put 2000 it changes to $35.94 which is the more correct price I believe for the highest adj. close.


What does PDim2 do?


Do I need a "1" in PAdjust if my PItem search is "A"? It seems to not make a difference.


Is this the best formula to use to seek the Highest adj. closing price for a stock on Yahoo History and how far back in time can I search?



Thanks for all the clarity. This is very helpful information.




Sat Jun 4, 2016 12:08 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

pDim1 and pDim2 specify the number of rows and columns for the function to
return. Typically, they aren't needed, because the function sets them based
on the range the function is array-entered over. In this case, we need to
override the default processing, because we aren't array-entering the array
over a range, but do need an array to be returned for the MAX() function.
In this case, I requested 200, because I knew it would be bigger than the
date range I supplied.

And, no, you don't need the pAdjust parameter if you're specifying the
adjusted closing price data item. However, if you changed the "A" to an "H"
or an "O" or a "L", it would give you the adjusted equivalent of those data
items. For this particular formula, the "A" and the "C" should return the
same item because pAdjust is set to 1.

On Sat, Jun 4, 2016 at 7:09 AM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks for the tips. I understand now about the adjusted closing price.
>
> Also I will use =DateValue(RCHGetYahooQuotes("SPY","d1")) instead of
> =Today() in my spreadsheet to speed things up. Great tip.
>
> I think the easiest price I should track is the historical High Adjusted
> close price for a stock.
>
> I have this formula for now as an example:
>
> =MAX(RCHGetYahooHistory(INTC,2014,1,6,2016,6,3,,"A",0,,,200,1))) which
> returns: $34.83
>
> The documentation for the RCHGetYahooHistory does not discuss the Pdim1
> and Pdim2 items.
>
> I assume PDim1 is the number of days it can look back. In the formula
> above that would be 200. I will need to go farther back. What would be the
> maximum number to enter here? If I put 2000 it changes to $35.94 which is
> the more correct price I believe for the highest adj. close.
>
> What does PDim2 do?
>
> Do I need a "1" in PAdjust if my PItem search is "A"? It seems to not make
> a difference.
>
> Is this the best formula to use to seek the Highest adj. closing price for
> a stock on Yahoo History and how far back in time can I search?
>
> Thanks for all the clarity. This is very helpful information.
>

Sat Jun 4, 2016 12:44 pm (PDT) . Posted by:

ridgebacksexcel

Ok Thanks.


What is the largest amount of rows the Pdim1 item can handle?

Sat Jun 4, 2016 12:47 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not a clue...

Right now, the highest # of days available on Yahoo is under 12,000.

On Sat, Jun 4, 2016 at 12:44 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Ok Thanks.
>
> What is the largest amount of rows the Pdim1 item can handle?
>

Sat Jun 4, 2016 12:49 pm (PDT) . Posted by:

ridgebacksexcel

Ok. Thanks for all your help Randy.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar