Sabtu, 13 Agustus 2016

[smf_addin] Digest Number 3770[3 Attachments]

10 Messages

Digest #3770

Messages

Fri Aug 12, 2016 7:04 am (PDT) . Posted by:

garyhartling

The first formula produces nothing.

The second formula produces the attached screen grab.


---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :

Strange.


Try these two array-entered formulas and let me know what you see:

=RCHGetHTMLTable("https:// finance.yahoo.com/quotes/MMM, IBM/view/v1 https://finance.yahoo.com/quotes/MCD,IBM/view/v1",">Symbol")

=smfGetYahooPortfolioView(" MMM,IBM",,,1)

On Thu, Aug 11, 2016 at 8:51 PM, Gary.Hartling@ ​...wrote:


Sorry. I attached the wrong picture. Trying again.








Attachment(s) from
1 of 1 Photo(s)

Fri Aug 12, 2016 7:39 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. I just noticed the two formulas in my send message don't match the
two formulas you cited below. It looks like Yahoo added some blanks to what
I sent. Neither formula should have any blanks. The first has one in front
of "finance" and in front of "IBM". The second one has a blank in front of
"MMM".

We're having enough problems without that kind of help.

On Fri, Aug 12, 2016 at 7:04 AM, Gary.Hartling@
​...​
wrote:

>
> The first formula produces nothing.
>
> The second formula produces the attached screen grab.
>
> ---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
>
> Strange.
>
> Try these two array-entered formulas and let me know what you see:
>
> ​​
> =RCHGetHTMLTable("https:// finance.yahoo.com/quotes/MMM, IBM/view/v1
> <https://finance.yahoo.com/quotes/MCD,IBM/view/v1>",">Symbol")
>
> =smfGetYahooPortfolioView(" MMM,IBM",,,1)
>
>

Fri Aug 12, 2016 7:53 am (PDT) . Posted by:

garyhartling

OK. Here's the screen grab with the extra blank removed.
Attachment(s) from
1 of 1 Photo(s)

Fri Aug 12, 2016 8:22 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I need to see the results of both formulas, so I can see what it's picking
up from one to the other...

On Fri, Aug 12, 2016 at 7:53 AM, Gary.Hartling@
​...wrote:

>
> OK. Here's the screen grab with the extra blank removed.
>
>

Fri Aug 12, 2016 8:40 am (PDT) . Posted by:

garyhartling

That's it. The first formula still produces nothing on the screen. The formula is arrayed entered over the range C5:Q7 and produces blanks.


---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :

I need to see the results of both formulas, so I can see what it's picking up from one to the other...


On Fri, Aug 12, 2016 at 7:53 AM, Gary.Hartling@ ​...wrote:


OK. Here's the screen grab with the extra blank removed.








Fri Aug 12, 2016 8:46 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

OK. Attach the workbook. Let me see if everything looks OK
​ here​
.

On Fri, Aug 12, 2016 at 8:40 AM, Gary.Hartling@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> That's it. The first formula still produces nothing on the screen. The
> formula is arrayed entered over the range C5:Q7 and produces blanks.
>
>

Fri Aug 12, 2016 9:01 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The reason the first formula isn't working is that you didn't take the two
blanks out.

On Fri, Aug 12, 2016 at 8:54 AM, Gary.Hartling@
​...wrote:

>
> Attached workbook.
>
>

Fri Aug 12, 2016 9:28 am (PDT) . Posted by:

garyhartling

OK. So that formula seems to work. I took the blank out of the second formula but didn't notice the blanks in the first one. I assume the "Example" tab looks OK to you? I still get only the MMM line filled out and even that is mostly garbage or missing.

Fri Aug 12, 2016 9:59 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The "Example" tab works fine here. And both formulas work fine, once I took
out the blanks that were in each.

On Fri, Aug 12, 2016 at 9:28 AM, Gary.Hartling@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> OK. So that formula seems to work. I took the blank out of the second
> formula but didn't notice the blanks in the first one. I assume the
> "Example" tab looks OK to you? I still get only the MMM line filled out
> and even that is mostly garbage or missing.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.10

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)