3 Messages
Digest #3777
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.
l1 is supposed to return price only. But it returns, for example:
1:57pm - <b>119.
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.
>
>
>
=RCHGetYahooQuotes(
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.
>
> 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
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(RCHGetYa
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:
Posting Komentar