Messages In This Digest (2 Messages)
- 1a.
- Re: Full security name From: hashky
- 1b.
- Re: Full security name From: Gary Funck
Messages
- 1a.
-
Re: Full security name
Posted by: "hashky" hashky@yahoo.com hashky
Sun Aug 7, 2011 10:32 pm (PDT)
Randy -
This is what I use for pulling the full security name.
=(RCHGetTableCell("http://finance. yahoo.com/ "&C4,0,"("&C4&q/pr?s= ")","("&C4& ")"))
Would I be better off using the SMFGetTagContent? Could you give me the equation for pulling the same information using Tag Content?
The SMFGetTagContent is hard for me to get my mind around.
Ron
--- In smf_addin@yahoogroups.com , "mike_sobieski" <mike_sobieski@...> wrote:
>
> Randy, You're The Man. This works.
>
> Timeless Proverb (paraphrased):
> "the man who knows how will always be at the mercy of the man who knows why."
>
> Now, at least, now I know how. Thank you.
>
> I have no idea what you mean by reliable string, but I guess I'll find out if it doesn't work in the future.
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > The name and exchange are in separate "span" tags. Try something like:
> >
> > =smfGetTagContent("
> > https://personal.vanguard. com/us/funds/ stocks/snapshot? Ticker=
> > "&C4,"span",1,"HeadTag" )
> >
> > I'm not sure how reliable the search string is.
> >
> > On Fri, Jul 29, 2011 at 2:33 PM, mike_sobieski <mike_sobieski@>wrote:
> >
> > >
> > > Do you know of a data source that provides the complete security name?
> > >
> > > So far, the best I could come up with is:
> > >
> > > https://personal.vanguard. com/us/funds/ stocks/snapshot? Ticker=~~ ~~~
> > >
> > > But even this is a little messy with the "...Co( New York Stock Exchange)"
> > > stuff at the end.
> > >
> >
>
- 1b.
-
Re: Full security name
Posted by: "Gary Funck" gary@intrepid.com garyfunck
Mon Aug 8, 2011 12:18 am (PDT)
On 08/08/11 05:32:34, hashky wrote:
> Randy -
>
> This is what I use for pulling the full security name.
>
> =(RCHGetTableCell("http://finance. yahoo.com/ "&C4,0,"("&C4&q/pr?s= ")","("&C4& ")"))
I ended up using this in a spreadsheet that I put together a while back.
=RCHGetTableCell("http://finviz. com/quote. "&Symbol1,1,ashx?t= "fullview- ticker"," <tr")
where Symbol1 is a defined name for a particular cell.
- Gary
PS: Randy, or someone else on the list, likely suggested this.
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