Messages In This Digest (6 Messages)
- 1a.
- Re: Bllomberg...again! From: bushpilote@yahoo.ca
- 2a.
- Re: Schwab Weekly - Followup From: smithjhhic
- 2b.
- Re: Schwab Weekly - Followup From: Randy Harmelink
- 2c.
- Re: Schwab Weekly - Followup From: smithjhhic
- 2d.
- Re: Schwab Weekly - Followup From: Randy Harmelink
- 3a.
- Re: getting data from IBD stock checkup page From: ronspieker
Messages
- 1a.
-
Re: Bllomberg...again!
Posted by: "bushpilote@yahoo.ca" bushpilote@yahoo.ca bushpilote
Sun Mar 25, 2012 6:40 am (PDT)
To annoy non-programmers like me. Thank you Randy.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The problem with .TEDSP:IND is that they have an orphaned <span> tag within
> the price span. That is, this:
>
> =smfGetTagContent("http://www.bloomber g.com/quote/ .tedsp:ind
> ","span",1,">.TEDSP:IND" )
>
> ...returns this:
>
> 0.41 <span>
>
> So adding zero to that gives a #VALUE! error. But you can use SUBSTITUTE()
> to remove the string:
>
> =0+SUBSTITUTE(smfGetTagContent ("http://www.bloomber g.com/quote/ .tedsp:ind
> ","span",1,">.TEDSP:IND" ),"<span> ","")
>
> I don't know why they code the pages inconsistently.
>
> On Fri, Mar 23, 2012 at 6:33 AM, <bushpilote@...> wrote:
>
> >
> > I'd appreciate it if you would help me construct a formula to get the last
> > price for ".TEDSP:IND". This has been covered before but the solution
> > offered doesn't work anymore.
> >
> > The following formula:=0+smfGetTagContent( "
> > http://www.bloomberg.com/quote/ ","span",1,"move:ind >move:IND" gives me
> > the last price for the MOVE Index and #VALUE! for ".TEDSP:IND".
> >
> > The only explanation that I can up with for this is that the last price's
> > element for each security on the Bloomberg site are different:
> > MOVE:IND = <span class=" price">
> > .TEDSP:IND = <span class=" price">,,,<\span>
> >
> > If that's the case then how do I tweak the formula to get the last price
> > for the TED spread?
> >
> > Using the advanced mode from web in Excel 2007 will get me the last price
> > and the daily change but I prefer working with your add-in.
> >
>
- 2a.
-
Re: Schwab Weekly - Followup
Posted by: "smithjhhic" smithjhhic@yahoo.com smithjhhic
Sun Mar 25, 2012 4:37 pm (PDT)
Randy,
Thanks for the help you provide last year. The recommendation field often has multiple lines, separated by <br>. Is there a way to return all the lines in the recommendation or comments section?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Just use ordinary EXCEL string concatenation to get the stock symbol in the
> formula. For example:
>
> =RCHGetTableCell("https://schwabweekl y.marketedge. com/secop/
> "&A1&".asp?p=SC",0,">Recommen dation"," class=f1l" )
> =RCHGetTableCell("https://schwabweekl y.marketedge. com/secop/
> "&A1&".asp?p=SC",0,">Comment" ,"class=f1l" )
>
> On Sun, Mar 27, 2011 at 3:29 AM, smithjhhic <smithjhhic@...> wrote:
>
> > Thank you for the help. Is it possible to point to another cell to obtain
> > the stock symbol vs typing it in the formula. Also, I tried with other data
> > on the web page and it worked except for "Recommendation" and "Comment".
> > Would I need to use a different formula for these?
> >
>
- 2b.
-
Re: Schwab Weekly - Followup
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Mar 25, 2012 6:27 pm (PDT)
It looks to me like it *is* returning all lines...
On Sun, Mar 25, 2012 at 4:37 PM, smithjhhic <smithjhhic@yahoo.com > wrote:
>
> Thanks for the help you provide last year. The recommendation field often
> has multiple lines, separated by <br>. Is there a way to return all the
> lines in the recommendation or comments section?
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Just use ordinary EXCEL string concatenation to get the stock symbol in
> the
> > formula. For example:
> >
> > =RCHGetTableCell("https://schwabweekl y.marketedge. com/secop/
> "&A1&".asp?p=SC",0,">Recommen dation"," class=f1l" )
> > =RCHGetTableCell("https://schwabweekl y.marketedge. com/secop/
> "&A1&".asp?p=SC",0,">Comment" ,"class=f1l" )
>
- 2c.
-
Re: Schwab Weekly - Followup
Posted by: "smithjhhic" smithjhhic@yahoo.com smithjhhic
Sun Mar 25, 2012 11:19 pm (PDT)
Randy,
Yes, my error. Related question, I would like to keep my row height 1 line vs. auto height. However, I don't know of a method to view the information when focused on a cell with multi-line content (ex below) without expanding the height. Do you know of a method? The formula bar shows only the formula. I am an Excel novice and unable to find the answer in searching help.
v/r,
Jeff
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It looks to me like it *is* returning all lines...
>
> On Sun, Mar 25, 2012 at 4:37 PM, smithjhhic <smithjhhic@...> wrote:
>
> >
> > Thanks for the help you provide last year. The recommendation field often
> > has multiple lines, separated by <br>. Is there a way to return all the
> > lines in the recommendation or comments section?
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > Just use ordinary EXCEL string concatenation to get the stock symbol in
> > the
> > > formula. For example:
> > >
> > > =RCHGetTableCell("https://schwabweekl y.marketedge. com/secop/
> > "&A1&".asp?p=SC",0,">Recommen dation"," class=f1l" )
> > > =RCHGetTableCell("https://schwabweekl y.marketedge. com/secop/
> > "&A1&".asp?p=SC",0,">Comment" ,"class=f1l" )
> >
>
- 2d.
-
Re: Schwab Weekly - Followup
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Mar 25, 2012 11:40 pm (PDT)
I didn't see an example below?
You can't have it both ways -- you'd need to choose one or the other.
Hmmm. How about in a comment? Something like:
=RCHCreateComment("",0,500, 50,,,,,RCHGetTab leCell("
https://schwabweekly.marketedge. com/secop/
"&J3&".asp?p=SC",0,">Recommen dation"," class=f1l" ),"Recommendatio n")
On Sun, Mar 25, 2012 at 11:19 PM, smithjhhic <smithjhhic@yahoo.com > wrote:
> Randy,
> Yes, my error. Related question, I would like to keep my row height 1
> line vs. auto height. However, I don't know of a method to view the
> information when focused on a cell with multi-line content (ex below)
> without expanding the height. Do you know of a method? The formula bar
> shows only the formula. I am an Excel novice and unable to find the answer
> in searching help.
> v/r,
> Jeff
>
- 3a.
-
Re: getting data from IBD stock checkup page
Posted by: "ronspieker" tip001@verizon.net ronspieker
Sun Mar 25, 2012 7:32 pm (PDT)
--- In smf_addin@yahoogroups.com , Mike Fitzpatrick <mff3429@...> wrote:
>
> thanks much, randy, for putting together the IBD template file. I've
> manually maintained a spreadsheet of all 197 industry subgroups and the
> top stocks in them, generally just updating the top 20 subgroups every
> few weeks or so. a rather tedious task. now i can get easily get a
> up-to-date listing by using the addin. attached is a pdf of the
> spreadsheet.
> i've also incorporated the ibd template into my individual stock summary
> spreadsheet, which includes not just the IBD ratings, but other info
> pulled for various sites, all based on the various template files. very
> handy.
> again thanks much. how much time a week do you put in to managing the
> add-in and emails/posts?
> - mike
>
Would you provide some more in-depth explanation on how you got to the final template you attached in pdf? I don't see how to get there. Thanks much.
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