4 Messages
Digest #4583
Messages
Sun Jul 21, 2019 6:27 pm (PDT) . Posted by:
bobc94595
What formula is now available to retrieve the Forward Annual Dividend Rate? The GetElementNumber 4924 or 4925 no longer seems to deliver the info.
Sun Jul 21, 2019 7:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The key statistics data elements are working fine here. Someone else also
reported an issue this evening.
Possibly a temporary Yahoo glitch? Or you may have an older IE object that
Yahoo no longer supports?
I think all of the dividend items are available via the
smfGetYahooPortfolioView() function. But please use it as an array-entered
function over a range and not to get individual data items.
On Sun, Jul 21, 2019 at 6:27 PM conlonrc@... wrote:
> What formula is now available to retrieve the Forward Annual Dividend
> Rate? The GetElementNumber 4924 or 4925 no longer seems to deliver the info.
>
>
reported an issue this evening.
Possibly a temporary Yahoo glitch? Or you may have an older IE object that
Yahoo no longer supports?
I think all of the dividend items are available via the
smfGetYahooPortfoli
function over a range and not to get individual data items.
On Sun, Jul 21, 2019 at 6:27 PM conlonrc@... wrote:
> What formula is now available to retrieve the Forward Annual Dividend
> Rate? The GetElementNumber 4924 or 4925 no longer seems to deliver the info.
>
>
Mon Jul 22, 2019 4:50 am (PDT) . Posted by:
a.bereziuk
[quote]
I have no idea what you're describing. If you're overwriting it, why would you even need an automated value returned?
If you copying and archiving, it wouldn't matter if it came from an array-entered formula?
[/quote]
As a swing trader I need the automated value to watch over days and to compare it with the buy price. When I see that it is time to sell, I make the trade. But the real trade price should be corrected in the cell. Then I archive all the trade data (Last, % Chg., etc.) to calculate my exact return and trading performance. And for the statistics too. I also can overwrite this cell with the target price. Of course, I could make another cell (column) for that and I probably will do so.
I have no idea what you're describing. If you're overwriting it, why would you even need an automated value returned?
If you copying and archiving, it wouldn't matter if it came from an array-entered formula?
[/quote]
As a swing trader I need the automated value to watch over days and to compare it with the buy price. When I see that it is time to sell, I make the trade. But the real trade price should be corrected in the cell. Then I archive all the trade data (Last, % Chg., etc.) to calculate my exact return and trading performance. And for the statistics too. I also can overwrite this cell with the target price. Of course, I could make another cell (column) for that and I probably will do so.
Mon Jul 22, 2019 5:04 am (PDT) . Posted by:
a.bereziuk
>Are you using an older version of EXCEL? It may have different limitations on string lengths within the >EVALUATE() function.
I use Excel 2016. But Yahoo functions calls are shorter than extraction functions calls.
I use Excel 2016. But Yahoo functions calls are shorter than extraction functions calls.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar