Jumat, 19 Juli 2019

[smf_addin] Digest Number 4580

4 Messages

Digest #4580

Messages

Thu Jul 18, 2019 8:37 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

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?

On Thu, Jul 18, 2019 at 3:02 AM a.bereziuk@... wrote:

>
> The problem is that a trade price is slightly different from that returned
> from Yahoo. So I can quickly overwrite the returned price with the exact
> one and start my macro for copying and archiving the trade data. With an
> array entered function it is not possible to edit the cell. I only have not
> more than 10 positions in the portfolio. Since GetYahooQuotes() have not
> functioned for individual quotes, I used smfGetYahooPortfolioView(). Or is
> there another function (for Yahoo) for it?
>
>
>

Thu Jul 18, 2019 8:41 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Are you using an older version of EXCEL? It may have different limitations
on string lengths within the EVALUATE() function.

In my personal add-in, I have a number of macros I use that allow me to
export a range as a table, depending on where I'm planning to paste it. One
for HTML, two for Reddit, and one for The Motley Fool.

On Thu, Jul 18, 2019 at 3:47 AM a.bereziuk@... wrote:

>
> > Having said that, the two formulas worked fine for me using
> smfUpdateDownloadTable:
>
> For some reason the functions GetTableCell() and GetElementNumber() work
> fine with the macro. But the 2 Yahoo functions return "#value!" in the
> cells. They both work, when I put them directly in the cells and write
> "MMM" ticker directly. Could you please look, what is different in the
> Yahoo functions comparing to webpage extraction functions in the macro code.
>
> The difference in my Excel is the European regional delimiters: in
> function calls: ";" in place of "," and in decimal numbers: "," instead of
> "." for US.
>
> Which tool do you use to copy your Excel table and to paste it as a
> HTML-Table in the forum?
>
>
>

Thu Jul 18, 2019 9:35 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

Hello Randy - suddenly several Morningstar items stopped working.

I have a M* premium membership, logged on with the browser. When entering alt D-D-W to login in excel, the screen I get is different than before, only text. Don't know if it is related.

The items that used to work a couple of days ago:

Fair value uncertainty
=RCHGetElementNumber($A8,889)

Economic Moat
=RCHGetElementNumber($A8,890)

Fair value
=RCHGetElementNumber($A4, 886)

Stars
=smfConvertData(smfStrExtr(RCHGetWebData("http://financials.morningstar.com/company-profile/c.action?t="&A4,"r_star"),"r_star","'"))&"*"

Regards,
Jose L. Jacob

Fri Jul 19, 2019 1:37 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I wasn't able to get it to work here. The login process has changed, and I
get a message that the method the EXCEL IE object is using is not allowed.
So I don't see any way to actually log in for EXCEL and the add-in to use
the premium items.

On Thu, Jul 18, 2019 at 9:35 PM Jose Jacob pepecan47@... wrote:

> Hello Randy - suddenly several Morningstar items stopped working.
>
> I have a M* premium membership, logged on with the browser. When entering
> alt D-D-W to login in excel, the screen I get is different than before,
> only text. Don't know if it is related.
>
> The items that used to work a couple of days ago:
>
> Fair value uncertainty
> =RCHGetElementNumber($A8,889)
>
> Economic Moat
> =RCHGetElementNumber($A8,890)
>
> Fair value
> =RCHGetElementNumber($A4, 886)
>
> Stars
> =smfConvertData(smfStrExtr(RCHGetWebData("
> http://financials.morningstar.com/company-profile/c.action?t=
> "&A4,"r_star"),"r_star","'"))&"*"
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 05.45

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)