Jumat, 17 Februari 2012

[smf_addin] Digest Number 2118

Messages In This Digest (10 Messages)

Messages

1a.

Re: How i can extract data from this website ...

Posted by: "back" backmehl@yahoo.de   backmehl

Thu Feb 16, 2012 3:08 am (PST)



Hi, thanks a lot ...

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> How about:
>
> =RCHGetHTMLTable("
> http://www.ariva.de/jd_1_spec.value-fonds/historische_kurse
> ","Datum",-1,"",1)
>
> On Thu, Feb 16, 2012 at 1:22 AM, back <backmehl@...> wrote:
>
> >
> > i hope you can help me ...
> >
> > How can i extract the data table from the following site?
> >
> > http://www.ariva.de/jd_1_spec.value-fonds/historische_kurse
> >
> > Than you very much !!
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
1b.

Re: How i can extract data from this website ...

Posted by: "back" backmehl@yahoo.de   backmehl

Thu Feb 16, 2012 3:33 am (PST)





Hi Randy,

once again ...

What about here, i tried different ways but i get not the table back ... i don't know

http://www.finanztreff.de/kurse_einzelkurs_history.htn?i=13232309

--- In smf_addin@yahoogroups.com, "back" <backmehl@...> wrote:
>
> Hi Randy,
>
> i hope you can help me ...
>
> How can i extract the data table from the following site?
>
> http://www.ariva.de/jd_1_spec.value-fonds/historische_kurse
>
> Than you very much !!
>
> Regards
>
> BM
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2a.

Re: Get Table Cell

Posted by: "Steven" stevenletzer@yahoo.com   stevenletzer

Thu Feb 16, 2012 4:52 am (PST)



Thank you, 1 more thing. It seems that some bonds have a detailed description on lines 1&2. The short description (the one I want)is on line 3. For example, for CUSIP 472149BH5 - this is the first 2 lines returned.
JEA BULK POWER SUPPLY SYSTEM REVENUE BONDS, SCHERER 4 PROJECT ISSUE, SERIES 2010A (FEDERALLY TAXABLE - ISSUER SUBSIDY - BUILD AMERICA BONDS) (FL)

what I want is the third line, which is.
JEA FLA BULK PWR SUPPLY SYS REV TAXABLE-SCHERER 4 PJ-SER A (FL)*

How do I adjust the smf formula?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> How about:
>
> =smfGetTagContent("
> http://emma.msrb.org/SecurityView/SecurityDetails.aspx?cusip=838736UV6
> ","a",-1,"/IssueDetails.")
>
> On Wed, Feb 15, 2012 at 4:14 PM, Steven <stevenletzer@...> wrote:
>
> > I am trying to capture the name of a bond at emma.msrb.org For example:
> >
> > http://emma.msrb.org/SecurityView/SecurityDetails.aspx?cusip=838736UV6
> > The words Security Details are at the top line of the description page.
> > The next line is what I want to capture:
> > SOUTH LYON MICH CMNTY SCHS REF (MI)*
> >
> > any ideas?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2b.

Re: Get Table Cell

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu Feb 16, 2012 9:35 am (PST)



I don't see any reliable way to do it, without doing both. For the new
CUSIP, you can do:

=smfGetTagContent("
http://emma.msrb.org/SecurityView/SecurityDetails.aspx?cusip=472149BH5
","span",-1,"_secondLevelIssueDataLabel")

So, you'd really need to do that one first. And, then, if it returns
"Error", do the other one.

On Thu, Feb 16, 2012 at 5:52 AM, Steven <stevenletzer@yahoo.com> wrote:

> Thank you, 1 more thing. It seems that some bonds have a detailed
> description on lines 1&2. The short description (the one I want)is on line
> 3. For example, for CUSIP 472149BH5 - this is the first 2 lines returned.
> JEA BULK POWER SUPPLY SYSTEM REVENUE BONDS, SCHERER 4 PROJECT ISSUE,
> SERIES 2010A (FEDERALLY TAXABLE - ISSUER SUBSIDY - BUILD AMERICA BONDS) (FL)
>
> what I want is the third line, which is.
> JEA FLA BULK PWR SUPPLY SYS REV TAXABLE-SCHERER 4 PJ-SER A (FL)*
>
> How do I adjust the smf formula?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3a.

Re: Bloomberg

Posted by: "bushpilote@yahoo.ca" bushpilote@yahoo.ca   bushpilote

Thu Feb 16, 2012 5:30 am (PST)



Thank you all. Embarrassingly simple.

Besides using view selection source in Firefox, what else is there that can give me a better understanding of "what it has"?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Try:
>
> =RCHGetTableCell("http://www.bloomberg.com/quote/CRY:IND",1,"Year to date:")
> =RCHGetTableCell("http://www.bloomberg.com/quote/CRY:IND",1,"1-Year:")
>
> Usually, the semi-colon is sufficient to make it unique. The ">" and "<"
> strings were not abutted to the descriptions, so they wouldn't have worked
> in this case. You really do need to look at the source code to verify what
> it has...
>
> On Wed, Feb 15, 2012 at 9:44 AM, <bushpilote@...> wrote:
>
> > Hi Randy,
> > I'm stuck in extracting ">Year To Date:<" and ">1-Year:<" data from the
> > following site: http://www.bloomberg.com/quote/CRY:IND.
> >
> > I've tried getting the data by using variations of the formulas listed
> > below, which I found on your message board, with no success.
> >
> > "=smfStrExtr("|"&smfGetTagContent("
> > http://www.bloomberg.com/apps/quote?ticker=CRY:IND
> > ","h1",1,"id=""company_info"""),"|","<");
> >
> > "=RCHGetTableCell("http://www.bloomberg.com/apps/quote?ticker=CRY:IND
> > ",1,">open"
> >
> > Any suggestions on how to resove this?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
3b.

Re: Bloomberg

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu Feb 16, 2012 5:36 am (PST)



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@yahoo.ca> wrote:

>
> Besides using view selection source in Firefox, what else is there that
> can give me a better understanding of "what it has"?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
4a.

Re: Google Docs version of Company Overview

Posted by: "bobsledproductions" JPeters3515@snet.net   bobsledproductions

Thu Feb 16, 2012 6:04 am (PST)




I'm curious to know whether this works on an android phone, Kindle Fire, or an iPad. Grateful if someone who has on of these devices could try and provide feedback. I'm stuck with a blackberry, and the interface prevents me from changing anything.

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> I share the same concerns as Pete A about privacy.
>
> Regarding the language I had a similar problem as Pete. Initially all the
> characters were Asian (double-byte) characters.
>
> I clicked on the Setup tab on the bottom of the page and saw the Language
> was set to Zhongwen. I'm not fluent in that so selected English and all was
> well. Just click cell C2 and you'll get a dropdown list of supported
> languages.
>
> I agree it was a very interesting exercise - thanks J Peters.
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of Pete A
> Sent: Wednesday, February 15, 2012 12:01 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: Google Docs version of Company Overview
>
>
>
>
> Thanks for a fascinating experiment and nice blog post.
>
> That said, I personally would NOT put my serious data in the hands of Google
> (or anyone who claims the right to use my data as they please). "Free" might
> feel that way, but they must make their money somehow. I'd rather pay for
> quality software from which I control access. Google has recently announced
> major changes to their privacy rules...not so good in my view. My own
> paranoia I'm sure. Thanks for sharing your experience. Fascinating.
>
> When i ran the google sheet, it was all in cuniform...didn't get far enough
> to do the setup sheet thing you discussed in your blog post.
>
> Pete A
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
> "bobsledproductions" <JPeters3515@> wrote:
> >
> > Previously I created a Company Overview worksheet leveraging the addin,
> that is in the "files" section, but recently I was curious to know how far
> Google Docs has come, and whether the same type of workbook could be created
> in the Spreadsheet app. So I spent about 3-4 hours the other day, and got
> pretty close. If you are interested, take a look at the Company Overview
> spreadsheet that I created and published here:
> >
> > https://docs.google.com/templates?q=company+overview
> <https://docs.google.com/templates?q=company+overview&category=2&type=spread
> sheets&sort=rating&view=public>
> &category=2&type=spreadsheets&sort=rating&view=public
> >
> > I also put together a blog that detailed the steps here and how it was
> done (a little rough, but hopefully you get the point):
> >
> >
> http://justspreadsheets.blogspot.com/2012/02/company-overview-google-docs-ve
> rsion.html
> >
> > I know this doesn't exactly fit within Randy's group, so apologies if you
> view this as spam, not my intention. But, from my perspective if something
> similar to the addin could be built and delivered through a fully hosted
> solution like google docs, with nothing required to be installed on your
> desktop, and work on say mobile devices, and be localized, it could be quite
> powerful and useful.
> >
> > At this point in time, I'm far from convinced that I would ever replace
> Excel with Google docs, but....there is something compelling about a no
> cost, no download, device independent solution.
> >
> > Anyways, let me know your thoughts.....
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
5a.

Re: download/update the earings release date

Posted by: "ronmac17" ronmac17@yahoo.com   ronmac17

Thu Feb 16, 2012 8:40 am (PST)



Systematic Investor has a routine for downloading EPS data from ADVN
and plotting price and EPS data in one chart

https://systematicinvestor.wordpress.com/

link to plots for WMT

https://systematicinvestor.files.wordpress.com/2012/01/plot1-small4.png

https://systematicinvestor.files.wordpress.com/2012/01/plot2-small3.png

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> What would you want to extract from the page? I've not found them
> particularly useful.
>
> On Wed, Feb 15, 2012 at 3:04 PM, millerd1_smf <
> millerd1_airmail_net@...> wrote:
>
> >
> > Have you ever prepared an earnings report data macro?
> >
> > I see a Yahoo webpage where one can get expected earnings reports by
> > incrementing weeks. You seem pretty proficient with yahoo pages have you
> > seen this one? http://biz.yahoo.com/research/earncal/20120402.html
> >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
6a.

Adding new functions to RCHGetElementNumber

Posted by: "scott.furtado" scott.furtado@yahoo.com   scott.furtado

Thu Feb 16, 2012 9:12 am (PST)



Hello!

I have been using this plugin and I LOVE IT! Thank you so much! I would like to add new queries to the RchGetElementNumber to make retrieval easier. For example, I wanted to pull the Business Summary on the Profile page of Yahoo. I used =smfGetTagContent("http://finance.yahoo.com/q/pr?s=A","p",4). The problem is where I put in the ticker symbol "A" where pr?s=A I am unable to enter a reference cell for the ticker. This means I would have to manually change each symbol making the process very difficult. Is there a way I can add the function into RchGetElementNumber so I can use a reference cell instead of manually changing the ticker?

Thanks!

-Scott

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6b.

Re: Adding new functions to RCHGetElementNumber

Posted by: "Randy H" rharmelink@gmail.com   rharmelink

Thu Feb 16, 2012 9:45 am (PST)



Sorry, but you can't make that an element, because it would exceed an
EXCEL/VBA limitation of 256 bytes. Otherwise, I would have referred you
to this recent message:

http://finance.groups.yahoo.com/group/smf_addin/message/17219

But you can just fix your current formula (which doesn't work for me) --
instead of this working version:

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

...you can use normal EXCEL string concatenation:

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

...where cell B8 contains the ticker symbol.

On Thu, Feb 16, 2012 at 10:00 AM, scott.furtado
<scott.furtado@yahoo.com> wrote:

I have been using this plugin and I LOVE IT! Thank you so much! I
would like to add new queries to the RchGetElementNumber to make
retrieval easier. For example, I wanted to pull the Business Summary on
the Profile page of Yahoo. I used
=smfGetTagContent("http://finance.yahoo.com/q/pr?s=A
<http://finance.yahoo.com/q/pr?s=A> ","p",4). The problem is where I
put in the ticker symbol "A" where pr?s=A I am unable to enter a
reference cell for the ticker. This means I would have to manually
change each symbol making the process very difficult. Is there a way I
can add the function into RchGetElementNumber so I can use a reference
cell instead of manually changing the ticker?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need traffic?

Drive customers

With search ads

on Yahoo!

Yahoo! News

Odd News

You won't believe

it, but it's true

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 02.40

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)