Kamis, 05 April 2012

[smf_addin] Digest Number 2167

Messages In This Digest (9 Messages)

Messages

1a.

Database

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

Wed Apr 4, 2012 7:40 am (PDT)



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 (3)
2a.

How to extract institutional ownership  pie chart from Nasdaq.com

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

Wed Apr 4, 2012 11:46 am (PDT)



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

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

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

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

Wed Apr 4, 2012 1:21 pm (PDT)



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@gmail.com> 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
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2c.

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

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

Wed Apr 4, 2012 5:34 pm (PDT)



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
> >
>

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

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

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

Wed Apr 4, 2012 5:49 pm (PDT)



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@gmail.com> 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 (4)
3a.

GetYahooHistory Failing to Update All Values

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

Wed Apr 4, 2012 2:15 pm (PDT)



Have an Excel spreadsheet that contains RCHGetYahooHistory for several stocks. Almost everytime when I enter ForceRecalc, one or more data values is missing. If I enter ForceRecalc again, the items that failed to display before will be updated but then one or more of the others will not update. It seems to always occur within the last two data days of the columns - it updates the previous 235 days just fine but the last two days are highly uncertain. Any ideas?

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

Re: GetYahooHistory Failing to Update All Values

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

Wed Apr 4, 2012 2:44 pm (PDT)





--- In smf_addin@yahoogroups.com, "thomas91112" <thomas91112@...> wrote:
>
> Have an Excel spreadsheet that contains RCHGetYahooHistory for several stocks. Almost everytime when I enter ForceRecalc, one or more data values is missing. If I enter ForceRecalc again, the items that failed to display before will be updated but then one or more of the others will not update. It seems to always occur within the last two data days of the columns - it updates the previous 235 days just fine but the last two days are highly uncertain. Any ideas?
>
Have been working with this a little more and find it is the last day of historical data that is uncertain. For example, the data for yesterday close of business finds the Date, Open, High, Low and Close values may appear in any combination. Sometimes the Date and Close may not appear, sometimes the Open and Close will not, or sometimes just the Date....you never know. Hitting ForceRecalc will usually, but not always correct this problem, however, as mentioned there are several columns and stocks that all suffer from this failure to display and it is random.

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

Re: GetYahooHistory Failing to Update All Values

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

Wed Apr 4, 2012 3:43 pm (PDT)



I suspect it is a Yahoo issue. I've had similar problems in the last month
or so, including with my browser. I think they may have one or more servers
that haven't been propagated with updates, or are missing the data
completely.

How many stocks are you getting?

On Wed, Apr 4, 2012 at 2:15 PM, thomas91112 <thomas91112@yahoo.com> wrote:

> Have an Excel spreadsheet that contains RCHGetYahooHistory for several
> stocks. Almost everytime when I enter ForceRecalc, one or more data values
> is missing. If I enter ForceRecalc again, the items that failed to display
> before will be updated but then one or more of the others will not update.
> It seems to always occur within the last two data days of the columns - it
> updates the previous 235 days just fine but the last two days are highly
> uncertain. Any ideas?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3d.

Re: GetYahooHistory Failing to Update All Values

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

Wed Apr 4, 2012 5:58 pm (PDT)



Have two sets of stock tickers (i) six stocks on six separate worksheets in one workbook, and (ii) a separate workbook with about 40 stocks all in one worksheet.  Each of these approaches has this problem.
Thanks

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, April 4, 2012 3:43 PM
Subject: Re: [smf_addin] GetYahooHistory Failing to Update All Values


 
I suspect it is a Yahoo issue. I've had similar problems in the last month or so, including with my browser. I think they may have one or more servers that haven't been propagated with updates, or are missing the data completely.

How many stocks are you getting?

On Wed, Apr 4, 2012 at 2:15 PM, thomas91112 <thomas91112@yahoo.com> wrote:

Have an Excel spreadsheet that contains RCHGetYahooHistory for several stocks.  Almost everytime when I enter ForceRecalc, one or more data values is missing.  If I enter ForceRecalc again, the items that failed to display before will be updated but then one or more of the others will not update.  It seems to always occur within the last two data days of the columns - it updates the previous 235 days just fine but the last two days are highly uncertain.  Any ideas?
>

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

Fashion News

What's the word on

fashion and style?

Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

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 02.12

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)