Messages In This Digest (7 Messages)
- 1a.
- Re: Bloomberg From: bushpilote@yahoo.ca
- 2a.
- Re: Get Table Cell From: sysmodie
- 2b.
- Re: Get Table Cell From: Mike McQuaid
- 3a.
- smfGetOptionQuotes returning ERROR From: cutthegrasssnow
- 3b.
- Re: smfGetOptionQuotes returning ERROR From: Randy H
- 4a.
- Just started with the RCHGetYahooquotes formula From: RonaldKok_98
- 4b.
- Re: Just started with the RCHGetYahooquotes formula From: Randy Harmelink
Messages
- 1a.
-
Re: Bloomberg
Posted by: "bushpilote@yahoo.ca" bushpilote@yahoo.ca bushpilote
Fri Feb 17, 2012 4:57 am (PST)
Thanks Randy.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> See:
>
> http://finance.groups.yahoo. com/group/ smf_addin/ message/17388
> http://finance.groups.yahoo. com/group/ smf_addin/ message/851
> http://finance.groups.yahoo. com/group/ smf_addin/ message/867
>
> On Thu, Feb 16, 2012 at 6:30 AM, <bushpilote@...> wrote:
>
> >
> > Besides using view selection source in Firefox, what else is there that
> > can give me a better understanding of "what it has"?
> >
>
- 2a.
-
Re: Get Table Cell
Posted by: "sysmodie" yg07@sysmod.com sysmodie
Fri Feb 17, 2012 9:08 am (PST)
Excuse me for jumping in on your thread but I was looking for a simple example and picked this first.
If I enter into a browser
http://emma.msrb.org/ SecurityView/ SecurityDetails. aspx?cusip= 838736UV6
I get a page asking me to "Accept" then I get the data.
When I enter that function in Excel I just get "Error"
=smfGetTagContent("http://emma. msrb.org/ ","a",-1,"/IssueDetSecurityView/ SecurityDetails. aspx?cusip= 838736UV6 ails.")
Is there something else I should do?
I've checked the source of that page and indeed see the data enclosed between <a> and /IssueDetails.aspx
- 2b.
-
Re: Get Table Cell
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Fri Feb 17, 2012 9:16 am (PST)
You have to view the original webpage and "Accept" using Internet Explorer
or the Excel Web Query.
The add-in uses the Excel interface which relies on IE so it must have the
"accept" cookie. Cookies from other browsers aren't visible to Excel or IE.
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of sysmodie
Sent: Friday, February 17, 2012 12:01 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Get Table Cell
Excuse me for jumping in on your thread but I was looking for a simple
example and picked this first.
If I enter into a browser
http://emma.msrb.org/ SecurityView/ SecurityDetails. aspx?cusip= 838736UV6
I get a page asking me to "Accept" then I get the data.
When I enter that function in Excel I just get "Error"
=smfGetTagContent("http://emma. msrb.org/ SecurityView/ SecurityDetails. aspx?cu
sip=838736UV6","a",-1," /IssueDetails. ")
Is there something else I should do?
I've checked the source of that page and indeed see the data enclosed
between <a> and /IssueDetails.aspx
- 3a.
-
smfGetOptionQuotes returning ERROR
Posted by: "cutthegrasssnow" dan@stitchwithus.com cutthegrasssnow
Fri Feb 17, 2012 12:38 pm (PST)
I have been using smfGetOptionQuotes to retrieve quotes from MSN for months in two different spreadsheets very successfully. Today, for no apparent reason, the function has begun returning ERROR. The spreadsheets have not even been closed since yesterday when they worked fine. Today, I update them and ERROR. Any thoughts as to what the problem could be? Something changed at MSN?
Thanks.
- 3b.
-
Re: smfGetOptionQuotes returning ERROR
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Fri Feb 17, 2012 12:45 pm (PST)
I just uploaded version 2.1.2012.02.17 of the add-in to the "Works in
Progress" folder for this issue.
MSN changed the base URL of the options quotes web page from:
http://moneycentral.msn.com/ investor/ options/default. asp?Symbol=
...to:
http://investing.money.msn. com/investments/ equity-options/ ?symbol=
http://investing.money.msn. com/investments/ etf-options/ ?symbol=
On Fri, Feb 17, 2012 at 12:11 PM, cutthegrasssnow <dan@stitchwithus.com >
wrote:
I have been using smfGetOptionQuotes to retrieve quotes from MSN for
months in two different spreadsheets very successfully. Today, for no
apparent reason, the function has begun returning ERROR. The
spreadsheets have not even been closed since yesterday when they worked
fine. Today, I update them and ERROR. Any thoughts as to what the
problem could be? Something changed at MSN?
- 4a.
-
Just started with the RCHGetYahooquotes formula
Posted by: "RonaldKok_98" rkok@gmx.de RonaldKok_98
Sat Feb 18, 2012 2:07 am (PST)
Hello,
I just joined this group and just started with the RCHGetYahooQuote-formula.
If I use thise code:
=RCHGetYahooQuotes(A2;"o") I get the price in cents (it should be 59,59 euro)
Example
ADS.DE ADIDAS N 5.959,00
Does anyone know how to get right?
And I also want to add another variable, how do I do that? Is that by
adding it comma-separated like =RCHGetYahooQuotes(A2;"o,p,f" ) etc?
Thanks in advance.
Regards,
Ronald
Holland
- 4b.
-
Re: Just started with the RCHGetYahooquotes formula
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Feb 18, 2012 2:10 am (PST)
Sorry, but the add-in is based on U.S. Regional settings. There are some
items in the "Links" area for adjusting conversion of amounts.
Check the "Documentation" folder of the Files area of the group for more
info on the function parameters. But, no, you would not comma-delimit the
Yahoo codes.
On Sat, Feb 18, 2012 at 1:58 AM, RonaldKok_98 <rkok@gmx.de> wrote:
>
> I just joined this group and just started with the
> RCHGetYahooQuote-formula.
>
> If I use thise code:
>
> =RCHGetYahooQuotes(A2;"o") I get the price in cents (it should be 59,59
> euro)
>
> Example
> ADS.DE ADIDAS N 5.959,00
>
> Does anyone know how to get right?
>
> And I also want to add another variable, how do I do that? Is that by
> adding it comma-separated like =RCHGetYahooQuotes(A2;"o,p,f" ) etc?
>
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar