Jumat, 06 April 2012

[smf_addin] Digest Number 2168

Messages In This Digest (15 Messages)

Messages

1a.

Re: How to extract institutional ownership pie chart from Nasdaq.com

Posted by: "digsupply" picsound@gmail.com   digsupply

Thu Apr 5, 2012 5:01 am (PDT)



I understand. But which ticker does it refer to? To AMZN? To NFLX? How do I obtain the pie chart for a particular ticker?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You can generate the image URL yourself:
>
> http://charting.nasdaq.com/ext/SimpleCharts.dll?Pie?100&100&Data:0.50&11&PB:E4B26B|GB:FFFFFF|L0:0|F0:A5C2E0
>
> Note the "Data:0.50" -- that says to create a pie chart at 50%. So this
> would be 80%:
>
> http://charting.nasdaq.com/ext/SimpleCharts.dll?Pie?100&100&Data:0.80&11&PB:E4B26B|GB:FFFFFF|L0:0|F0:A5C2E0
>
> On Wed, Apr 4, 2012 at 5:34 PM, digsupply <picsound@...> wrote:
>
> > Thank you for your answer. I must tell you that I need this to use a
> > WebBrowser control in a userform, so what you suggested is not really
> > viable as I choose different tickers in a textbox in a userform
> >
> > What about using this formula?: smfGetTagContent("
> > http://www.nasdaq.com/symbol/"&LOWER(B720) & "/institutional-holdings"
> > If I use it, do you think I could extract what I need? Any ideas?
> >
> >
> >
> >
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > That URL probably is the instructions on how to draw the chart, so it may
> > > even vary day to day on the same ticker.
> > >
> > > One way to go would be to extract the URL from the web page, as needed.
> > >
> > > Or just generate the pie chart yourself, in EXCEL, using the actual data.
> > >
> > > On Wed, Apr 4, 2012 at 11:45 AM, digsupply <picsound@> wrote:
> > >
> > > > I need to extract a pie chart from the page "
> > > > http://www.nasdaq.com/symbol/pcx/institutional-holdings". When I copy
> > the
> > > > image location I get: "
> > > >
> > http://charting.nasdaq.com/ext/SimpleCharts.dll?Pie?100&100&Data:0.674368483935202&11&PB:E4B26B|GB:FFFFFF|L0:0|F0:A5C2E0
> > ".
> > > > The problem is that the URL does not contain the ticker, it just has a
> > data
> > > > #. Any idea how I can do that? Any tricks? Or any other website that
> > can
> > > > provide this information? Thanks in advance
> > > >
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
>

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

Re: How to extract institutional ownership pie chart from Nasdaq.com

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

Thu Apr 5, 2012 6:33 am (PDT)



Retrieve the percentage for AMZN or NFLX, and then substitute that amount
in the URL for the pie chart.

On Thu, Apr 5, 2012 at 5:01 AM, digsupply <picsound@gmail.com> wrote:

> I understand. But which ticker does it refer to? To AMZN? To NFLX? How do
> I obtain the pie chart for a particular ticker?
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > You can generate the image URL yourself:
> >
> >
> http://charting.nasdaq.com/ext/SimpleCharts.dll?Pie?100&100&Data:0.50&11&PB:E4B26B|GB:FFFFFF|L0:0|F0:A5C2E0
> >
> > Note the "Data:0.50" -- that says to create a pie chart at 50%. So this
> > would be 80%:
> >
> >
> http://charting.nasdaq.com/ext/SimpleCharts.dll?Pie?100&100&Data:0.80&11&PB:E4B26B|GB:FFFFFF|L0:0|F0:A5C2E0
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2a.

Re: Enquiry of smfGetTagContent() function

Posted by: "eric" ericckyuen@gmail.com   ericckyuen

Thu Apr 5, 2012 10:21 am (PDT)



Dear Randy

Thanks for your advice.

Using the RCHGetTableCell(), I am unable to extract the "Short Sell" figure
from this table :
http://www.etnet.com.hk/www/eng/stocks/realtime/quote.php?code=1800.

Grateful if you could help, pls.

Best Regards,

Eric

2012/4/4 Randy Harmelink <rharmelink@gmail.com>

> **
>
>
> The easiest solution would be to just use RCHGetTableCell() on both. It
> automatically removes HTML tags that are within the table cell.
>
> Otherwise, you'd need to use the "td" version of smfGetTagContent() and
> then use SUBSTITUTE() function to remove the <span...> and </span> portions
> of the table cell.
>
>
> On Tue, Apr 3, 2012 at 11:36 PM, ericckyuen <ericckyuen@gmail.com> wrote:
>
>>
>> I am using smfGetTagContent() function to extract some figures of the
>> following table :
>> http://www.aastocks.com/en/Stock/CompanyFundamental.aspx?CFType=6&symbol=00941
>>
>> It goes fine for +ve figures with this command. e.g. =0+smfGetTagContent("
>> http://www.aastocks.com/en/Stock/CompanyFundamental.aspx?CFType=6&symbol=00941","td",5,">
>> Interest Received")
>>
>> However, it needs to change (td) to (span) for -ve figures, e.g.
>> =0-SUBSTITUTE(smfGetTagContent("
>> http://www.aastocks.com/en/Stock/CompanyFundamental.aspx?CFType=6&symbol=00941","span",5,">
>> Interest Paid"),"-","")
>>
>> How can I cater for both +ve or -ve figures in the command?
>> I am unable to retrieve the correct figure if I do not use "td" for +ve
>> and "span" for -ve figure correctly.
>>
>> Grateful if your advice, pls.
>>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2b.

Re: Enquiry of smfGetTagContent() function

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

Thu Apr 5, 2012 10:48 am (PDT)



Try:

=RCHGetTableCell("
http://www.etnet.com.hk/www/eng/stocks/realtime/quote.php?code=1800",1,">Prv
Cls",">Short Sell",,,1)

On Thu, Apr 5, 2012 at 10:21 AM, eric <ericckyuen@gmail.com> wrote:

>
>
> Using the RCHGetTableCell(), I am unable to extract the "Short Sell"
> figure from this table :
> http://www.etnet.com.hk/www/eng/stocks/realtime/quote.php?code=1800.
>
> Grateful if you could help, pls.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3a.

is there a way to extract from XML?

Posted by: "B B" kokdari82@yahoo.com   kokdari82

Thu Apr 5, 2012 10:27 am (PDT)



Yahoo has xml files which load instantly compared to slow html pages.
But how would you extract something like the "BookValue" from this page?
http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22GOOG%22%29&env=store://datatables.org/alltableswithkeys

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

Re: is there a way to extract from XML?

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

Thu Apr 5, 2012 10:52 am (PDT)



Try:

=0+smfGetTagContent("
http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22GOOG%22%29&env=store://datatables.org/alltableswithkeys
","BookValue",1)

On Thu, Apr 5, 2012 at 10:27 AM, B B <kokdari82@yahoo.com> wrote:

> Yahoo has xml files which load instantly compared to slow html pages.
> But how would you extract something like the "BookValue" from this page?
>
> http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22GOOG%22%29&env=store://datatables.org/alltableswithkeys
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3c.

Re: is there a way to extract from XML?

Posted by: "B B" kokdari82@yahoo.com   kokdari82

Thu Apr 5, 2012 2:53 pm (PDT)



thank you!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Try:
>
> =0+smfGetTagContent("
> http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22GOOG%22%29&env=store://datatables.org/alltableswithkeys
> ","BookValue",1)
>
> On Thu, Apr 5, 2012 at 10:27 AM, B B <kokdari82@...> wrote:
>
> > Yahoo has xml files which load instantly compared to slow html pages.
> > But how would you extract something like the "BookValue" from this page?
> >
> > http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22GOOG%22%29&env=store://datatables.org/alltableswithkeys
> >
>

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

Re: Mottly Fool Cap Rating

Posted by: "yakahookey" brian.laws@gmail.com   yakahookey

Thu Apr 5, 2012 1:58 pm (PDT)



This works great for some ticker symbols and not at all for others. I cannot get WFM to work. Any suggestions?

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> An update to extraction of these data items, due to web page changes:
>
> MMM Value Description Formula 4 Caps Rating
> =VALUE(RCHGetWebData("http://caps.fool.com/Ticker/"&$E$4&".aspx","http:/\
> /g.fool.com/art/ratings/stars/trans/",1,42)) 4064 Players
> Outperforms
> =VALUE(smfGetTagContent("http://caps.fool.com/Ticker/"&$E$4&".aspx","spa\
> n",1,">All Players<")) 141 Players Underperforms
> =VALUE(smfGetTagContent("http://caps.fool.com/Ticker/"&$E$4&".aspx","spa\
> n",3,">All Players<")) 1273 All-Stars Outperforms
> =VALUE(smfGetTagContent("http://caps.fool.com/Ticker/"&$E$4&".aspx","spa\
> n",1,">All-Star Players<")) 19 All-Stars Underperforms
> =VALUE(smfGetTagContent("http://caps.fool.com/Ticker/"&$E$4&".aspx","spa\
> n",3,">All-Star Players<")) 28 Wall Street Outperforms
> =VALUE(smfGetTagContent("http://caps.fool.com/Ticker/"&$E$4&".aspx","spa\
> n",1,">Wall Street<")) 0 Wall Street Underperforms
> =VALUE(smfGetTagContent("http://caps.fool.com/Ticker/"&$E$4&".aspx","spa\
> n",3,">Wall Street<"))
>

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

Re: Mottly Fool Cap Rating

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

Thu Apr 5, 2012 2:04 pm (PDT)



WFM works fine for me, except that you have the old formula for the Caps
Rating -- see:

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

If you have some ticker symbols not working, you might want to check for
trailing blanks.

On Thu, Apr 5, 2012 at 1:23 PM, yakahookey <brian.laws@gmail.com> wrote:

> This works great for some ticker symbols and not at all for others. I
> cannot get WFM to work. Any suggestions?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (25)
4c.

Re: Mottly Fool Cap Rating

Posted by: "yakahookey" brian.laws@gmail.com   yakahookey

Thu Apr 5, 2012 4:39 pm (PDT)



I am using VALUE(smfGetTagContent("http://caps.fool.com/Ticker/"&$B1&".aspx","span",1,">All Players<"))

I have a list of 100 stocks. What I have found is the ticker symbol is not the issue. For some reason it allows a limited number to download and the rest just give #VALUE!.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> WFM works fine for me, except that you have the old formula for the Caps
> Rating -- see:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/12856
>
> If you have some ticker symbols not working, you might want to check for
> trailing blanks.
>
> On Thu, Apr 5, 2012 at 1:23 PM, yakahookey <brian.laws@...> wrote:
>
> > This works great for some ticker symbols and not at all for others. I
> > cannot get WFM to work. Any suggestions?
> >
>

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

Re: Mottly Fool Cap Rating

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

Thu Apr 5, 2012 5:00 pm (PDT)



It's something they do on their site. I get the message:

"You've made an awful lot of requests on our servers in a very short time.
No offense, but we're certain you're not a human."

On Thu, Apr 5, 2012 at 4:39 PM, yakahookey <brian.laws@gmail.com> wrote:

> I am using VALUE(smfGetTagContent("http://caps.fool.com/Ticker/"&$B1&".aspx","span",1,">All
> Players<"))
>
> I have a list of 100 stocks. What I have found is the ticker symbol is not
> the issue. For some reason it allows a limited number to download and the
> rest just give #VALUE!.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (25)
5a.

Launch ForceRecalc from an Excel program

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

Thu Apr 5, 2012 2:11 pm (PDT)



Is it possible to trigger a ForceRecalc through an Excel conditional statement e.g. IF (X<>Y,ForceRecalc)? Any ways other than launching it from the toolbar?

Thanks

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

Re: Launch ForceRecalc from an Excel program

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

Thu Apr 5, 2012 2:17 pm (PDT)



I don't know of a way to make it conditional like that.

On Thu, Apr 5, 2012 at 2:11 PM, thomas91112 <thomas91112@yahoo.com> wrote:

> Is it possible to trigger a ForceRecalc through an Excel conditional
> statement e.g. IF (X<>Y,ForceRecalc)? Any ways other than launching it
> from the toolbar?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
5c.

Re: Launch ForceRecalc from an Excel program

Posted by: "juranek54" chad.juranek@gmail.com   juranek54

Thu Apr 5, 2012 10:21 pm (PDT)



It looks like you are trying to get an automation process related to the calc. You could probably write some VBA for that to create a button or a scheduled calc. But as Randy posted, I don't think that is possible through conditional formatting.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I don't know of a way to make it conditional like that.
>
> On Thu, Apr 5, 2012 at 2:11 PM, thomas91112 <thomas91112@...> wrote:
>
> > Is it possible to trigger a ForceRecalc through an Excel conditional
> > statement e.g. IF (X<>Y,ForceRecalc)? Any ways other than launching it
> > from the toolbar?
> >
>

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

Re: Database

Posted by: "juranek54" chad.juranek@gmail.com   juranek54

Thu Apr 5, 2012 10:20 pm (PDT)



Its not difficult to link excel and access. I do it constantly and they are the two are powerful together. What you need to be concerned about is the problem down the line. How much data are you trying to store and analayze and how fast will that data size grow? Access is a great tool and I use it every day, however, depending on potential data size you might want to consider all options like a SQL server if you are looking at massive data sizes into the future. Access by itself can be limiting.

--- In smf_addin@yahoogroups.com, "lexstar" <lexstar@...> wrote:
>
> I think I have too much data in my Excel database, and I'm wondering if anyone could help me. I'm wondering if it would be wise to transfer the database into MS Access, and then query those data from Excel to do my analysis (is this even possible? if so, how difficult is it?)
>
> If anyone has any ideas, please I need help. Thanks in advance!
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
Recent Activity
Visit Your Group
Need traffic?

Drive customers

With search ads

on Yahoo!

Yahoo! News

Odd News

You won't believe

it, but it's true

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

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 01.49

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)