Sabtu, 20 Agustus 2016

[smf_addin] Digest Number 3777

3 Messages

Digest #3777
1b
Re: GetYahooQuotes datacode by "Randy Harmelink" rharmelink
2a

Messages

Fri Aug 19, 2016 11:14 am (PDT) . Posted by:

tenacity9

datacode l1 returns price and date/time same as datacode l


l1 is supposed to return price only. But it returns, for example:

1:57pm - <b>119.60</b> Not 119.60


Can this be troubleshot and fixed.


If I am mistaken or receiving different results from everyone else, please try to explain.


Is there any other place I can get last price without having to use functions that require array formulas? I don't see Last Price available in GetElementNumber, for example.


Thanks in advance for the assistance.

Fri Aug 19, 2016 2:56 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

This returns the price only for me:

=RCHGetYahooQuotes("MMM","l1")

What invocation are you using?

That function doesn't require an array formula unless you want multiple
items returned. But each function invocation requires a separate Internet
access, so if you do a large number of them, your data retrieval may take a
long time. I've had several people complain that it was taking 15 minutes
or longer to get their quotes. When I told them to change it all to
array-entered formulas (limit of 200 tickers per function invocation),
recalculation went down to seconds.

On Fri, Aug 19, 2016 at 11:14 AM, tenacity9@
​...​
wrote:

> datacode l1 returns price and date/time same as datacode l
>
> l1 is supposed to return price only. But it returns, for example:
> 1:57pm - <b>119.60</b>
>
> Not 119.60
>
> Can this be troubleshot and fixed.
>
> If I am mistaken or receiving different results from everyone else, please
> try to explain.
>
> Is there any other place I can get last price without having to use
> functions that require array formulas? I don't see Last Price available in
> GetElementNumber, for example.
>
>
>

Fri Aug 19, 2016 12:46 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Bruce, does your calculations also include stock splits?
The reason I ask is that
I have had a problem calculating total return whenever I include stock splits and dividends.
If you have a routine that handles both, I'd be interested in seeing it.

Thanks,
Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, August 17, 2016 1:26 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Morningstar Historical Distributions (Dividends)


Dear Randy,

Your function works great. I made some modifications as follows:

=SUM(INDEX(RCHGetYahooHistory(B4,YEAR(F4),MONTH(F4),DAY(F4),YEAR(NOW()),MONTH(NOW()),DAY(NOW()),"v",,,,,99,2),,2))*C4

B4 is the cell with the stock symbol
F4 is the cell with the serialized date of stock purchase
C4 is the number of shares owned

The result is all of the dividend dollars received from the date of purchase until today.

Thank you for your help.

Bruce

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar