Sabtu, 18 Oktober 2014

[smf_addin] Digest Number 3212

15 Messages

Digest #3212
1a
Re: MSN data by whichwaytobeach

Messages

Sat Oct 18, 2014 5:23 am (PDT) . Posted by:

whichwaytobeach

Oh crap, I was wondering why 90% of my pull-ins say error on them!

UGH!

Marc

Sat Oct 18, 2014 6:57 am (PDT) . Posted by:

whichwaytobeach

Hello Everyone,

Now, since many of the MSN and GOOGLE elements I've used no longer work, I cannot find the RCH Element replacement numbers for the following data pieces:

Quarterly Balance Sheet FQ1 - Goodwill Quarterly Balance Sheet FQ1 - # of Common Shares Outstanding Company Description (write-up)

Thank you for any help.


Regards,


Marc



Sat Oct 18, 2014 8:05 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The AdvFN cross-domains fix (on Tips and FAQS web page) helped several
people get rid of their Google errors. Have you tried it?

I don't think there is another element with company description. This will
pull the business summary from Yahoo's profile page:

=smfGetTagContent(" http://finance.yahoo.com/q/pr?s="&C5,"p",1,">Business
Summary")

On Sat, Oct 18, 2014 at 6:57 AM, WHICHWAYTOBEACH@... wrote:

>
> Now, since many of the MSN and GOOGLE elements I've used no longer work, I
> cannot find the RCH Element replacement numbers for the following data
> pieces:
>
> - Quarterly Balance Sheet FQ1 - Goodwill
> - Quarterly Balance Sheet FQ1 - # of Common Shares Outstanding
> - Company Description (write-up)
>
>
>

Sat Oct 18, 2014 10:08 am (PDT) . Posted by:

whichwaytobeach

Hello Randy,

I am not sure I have the thread that describes the AdvFN cross-domains fix; is it this one?

Yahoo! Groups https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/20984

https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/20984

Yahoo! Groups https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/20984 --- In smf_addin@yahoogroups.com, Randy Harmelink wrote: > > The smfUpdateDownloadTable issue with elements 826 and 848 are because of >...



View on groups.yahoo.com https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/20984
Preview by Yahoo



Also, when I cut & paste =smfGetTagContent(" http://finance.yahoo.com/q/pr?s= http://finance.yahoo.com/q/pr?s="&C5,"p",1,">Business Summary") into the cell, I get an "Error" return.

Thanks for your reply.

Regards,

Marc

Sat Oct 18, 2014 10:12 am (PDT) . Posted by:

whichwaytobeach

Sorry about the link, I merely had to change it to my symbol input cell. :(

Thank you, Randy, for that one...

But the other link, do I have the right Q&A Tips location?

Regards,

Marc

Sat Oct 18, 2014 10:26 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Here's the link from the web site:

Link
<https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/10464>AdvFN.001
- A possible fix for "Error" responses from AdvFN due to a change from a
Windows Update.

On Sat, Oct 18, 2014 at 10:12 AM, WHICHWAYTOBEACH@... wrote:

>
> But the other link, do I have the right Q&A Tips location?
>

Sat Oct 18, 2014 10:49 am (PDT) . Posted by:

whichwaytobeach

Thanks, Randy, though the thread didn't help me. I ended up having to switch every single cell over to alternative RCH locations. The only ones which don't have alternatives are GOODWILL and # of Common Shares Outstanding, two of which you would think all sites would have the ability to pull from.

Regards,

Marc

Sat Oct 18, 2014 11:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Looks like AdvFN has the Goodwill in the "Cost in Excess" line item. So you
could try that element number.

AdvFN also has a "Share Out" line item?

Or, the Yahoo Key Statistics web page has the shares outstanding as an
element number.

On Sat, Oct 18, 2014 at 10:49 AM, WHICHWAYTOBEACH@... wrote:

>
> Thanks, Randy, though the thread didn't help me. I ended up having to
> switch every single cell over to alternative RCH locations. The only ones
> which don't have alternatives are GOODWILL and # of Common Shares
> Outstanding, two of which you would think all sites would have the ability
> to pull from.
>

Sat Oct 18, 2014 12:21 pm (PDT) . Posted by:

whichwaytobeach

Thanks Randy.

YOU fixed it! Thank you for hanging in there with me.

I went to your RCHGetYahooQuotes page, but I did not see Shares Outstanding there. But, were you saying that if I go to the Yahoo Key Statistics web page, there is a way of knowing which code to use? I right mouse clicked the web page element, but it had me swimming in code lines. ;).

Let me know if there is something I am missing. That would be cool to learn, and, I will guess other financial sites have a similar method you will hopefully mention to me.

Thanks,

Marc

Sat Oct 18, 2014 2:43 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

This is the element from the Yahoo Key Statistics web page:

*#* *Usage* *Source* *Element* Template or Notes 981 S YahooKS Shares
Outstanding RCHGetElementNumber-Template-Yahoo-Key-Statistics.xls

On Sat, Oct 18, 2014 at 12:21 PM, WHICHWAYTOBEACH@... wrote:

>
> I went to your RCHGetYahooQuotes page, but I did not see Shares
> Outstanding there. But, were you saying that if I go to the Yahoo Key
> Statistics web page, there is a way of knowing which code to use? I right
> mouse clicked the web page element, but it had me swimming in code lines.
> ;).
>
> Let me know if there is something I am missing. That would be cool to
> learn, and, I will guess other financial sites have a similar method you
> will hopefully mention to me.
>

Sat Oct 18, 2014 10:12 am (PDT) . Posted by:

hsadvisor1


Where are the latest add-in and Works-In-Progress files? All I see on the smf group web site are items dated back more than 2 to 3 years. Obviously I'm doing something wrong. Just want to make sure I have the latest add-in and elements.

Harry

Sat Oct 18, 2014 10:30 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't know what you're looking at -- everything on the SMF web site (not
Yahoo group) in the "Works in Progress" folder is from 2014, not 2 or 3
years old. The front page of the web site has the latest official release,
also from 2014.

On Sat, Oct 18, 2014 at 10:12 AM, hsadvisor1@... wrote:

> Where are the latest add-in and Works-In-Progress files? All I see on
> the smf group web site are items dated back more than 2 to 3 years.
> Obviously I'm doing something wrong. Just want to make sure I have the
> latest add-in and elements.
>

Sat Oct 18, 2014 11:46 am (PDT) . Posted by:

hsadvisor1

Hi Randy,

Here's the web address I go to. https://groups.yahoo.com/neo https://groups.yahoo.com/neo

I then click-on files. Still can't find latest files etc. I'm signed into my membership. Puzzling??

Harry



Sat Oct 18, 2014 12:01 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The "Read Me" files there, as well as an address at the bottom of these
messages, point to the SMF new web site:

http://ogres-crypt.com/SMF

I was unhappy with how the FILES area was not working on Yahoo groups.
Although they've since fixed a few of those issues. For example, file
descriptions.

On Sat, Oct 18, 2014 at 11:46 AM, hsadvisor1@... wrote:

> Here's the web address I go to. https://groups.yahoo.com/neo
>
> I then click-on files. Still can't find latest files etc. I'm signed into
> my membership. Puzzling??
>
>

Sat Oct 18, 2014 12:03 pm (PDT) . Posted by:

hsadvisor1

Once again, great service! Many thanks Randy. I don't know how you do it.

Harry

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 14.43

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)