EXCEL Stock Market Functions Add-in Group

9 New Messages

Digest #2706

Re: BID AND ASK by "J@Y" g3m1n1980

Re: BID AND ASK by "Randy Harmelink" rharmelink

2.1

Re: RCHGetYahooQuotes() by "gbullr" gbullr

2.2

Re: RCHGetYahooQuotes() by "gbullr" gbullr

Re: Help Importing data from Morningstar to Excel by "waterboy5555" waterboy5555

Re: Help Importing data from Morningstar to Excel by "Randy Harmelink" rharmelink

Re: Advfn quarterly reports not updating by "ajtalukdar" ajtalukdar

Re: Advfn quarterly reports not updating by "Randy Harmelink" rharmelink

Messages

1a

Randy,

Can you just link element 25 in the master to last sale on the Nasdaq site? That moves the price up an entire day from the previous close with MSN

http://www.nasdaq.com/aspx/infoquotes.aspx?symbol=CYTK&selected=CYTK

Sent from AOL Mobile Mail

-----Original Message-----
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Wed, Jul 10, 2013 11:33 AM
Subject: Re: [smf_addin] BID AND ASK

Element #25, the "Last Price" on MSN has been defined as the
previous day's closing price since they redesigned the web page early
last year, so yes, it's pretty useless these days.

Take a look at the RCHGetYahooQuotes() function. It's much better at picking up daily quotes. You can gather numerous data items on up to 200 stocks (per function invocation), so it can be very fast at getting data. There's an entry in the LINKS area of the group that has a step-by-step example of setting up a data table. And the documentation for the function can be found in the "Documentation" folder in the FILES area of the group.

On Wed, Jul 10, 2013 at 7:05 AM, LINDA <lindaleven@yahoo.com> wrote:

HOW CAN I GET THIS FUNCTION TO GIVE ME THE CURRENT STOCK PRICE DURING THE MARKET DAY. I HAVE IT SET TO 25 AND IT JUST GIVES ME THE PREVIOUS DAYS CLOSE.

WHERE IS BID AND ASK OR THE CURRENT PRICE??????

PLEASE HELP

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

1b

Re: BID AND ASK

Tue Jul 23, 2013 7:54 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'd rather obsolete it. The only reason I added it initially is because I
converted everything on the MSN print page to an element. It was one I
should have skipped, since elements are NOT typically intended for things
that need to be updated frequently. Especially since RCHGetYahooQuotes()
does the job so much more efficiently.

Most of the "current quotes" from pages like the one you cite are more
difficult extractions. And, for some reason, seem to be changed frequently.

On Tue, Jul 23, 2013 at 6:17 AM, J@Y <xxjaysonxx@aol.com> wrote:

>
> Can you just link element 25 in the master to last sale on the Nasdaq
> site? That moves the price up an entire day from the previous close with MSN
>
>
> http://www.nasdaq.com/aspx/infoquotes.aspx?symbol=CYTK&selected=CYTK
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

2.1 Re: RCHGetYahooQuotes()

Tue Jul 23, 2013 1:01 pm (PDT) . Posted by:

"gbullr" gbullr

Sorry I could not find.

Does rchgetyahooquotes provide market cap?

Thanks.

--- In smf_addin@yahoogroups.com, "Randy Harmelink" <rharmelink@...> wrote:
>
> Sounds like you're not array-entering it. After highlighting the
> range and typing in the formula, you need to use Ctrl-Shift-Enter
> instead of just Enter to complete the formula.
>
> If you have it working in cell B2, you can also do this to expand it:
>
> 1. Click on cell B2.
> 2. Hold down shift and use the cursor keys to select the full range...B2:M100
> 3. Hit F2 to edit the formula
> 4. Hold down the Ctrl and Shift keys and press Enter (i.e. Ctrl-Shift-Enter)
>
> On 6/18/07, Daniel Rhodes <d_m_e_rhodes@...> wrote:
> >
> > Thanks for sorting out that problem. Unfortunately I've not got much further as now when I
> > input the formula I don't get all the numbers appearing but just 105.27 in Cell B2.
> >
> > Clearly I'm doing something wrong but I'm not sure what.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (61) . Top ^

2.2 Re: RCHGetYahooQuotes()

Tue Jul 23, 2013 1:04 pm (PDT) . Posted by:

"gbullr" gbullr

Apologies.. Found it... code J1.

--- In smf_addin@yahoogroups.com, "gbullr" <gaston.bullrich@...> wrote:
>
> Sorry I could not find.
>
> Does rchgetyahooquotes provide market cap?
>
> Thanks.
>
>
>
> --- In smf_addin@yahoogroups.com, "Randy Harmelink" <rharmelink@> wrote:
> >
> > Sounds like you're not array-entering it. After highlighting the
> > range and typing in the formula, you need to use Ctrl-Shift-Enter
> > instead of just Enter to complete the formula.
> >
> > If you have it working in cell B2, you can also do this to expand it:
> >
> > 1. Click on cell B2.
> > 2. Hold down shift and use the cursor keys to select the full range...B2:M100
> > 3. Hit F2 to edit the formula
> > 4. Hold down the Ctrl and Shift keys and press Enter (i.e. Ctrl-Shift-Enter)
> >
> > On 6/18/07, Daniel Rhodes <d_m_e_rhodes@> wrote:
> > >
> > > Thanks for sorting out that problem. Unfortunately I've not got much further as now when I
> > > input the formula I don't get all the numbers appearing but just 105.27 in Cell B2.
> > >
> > > Clearly I'm doing something wrong but I'm not sure what.
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (61) . Top ^

3a

Re: Help Importing data from Morningstar to Excel

Tue Jul 23, 2013 1:27 pm (PDT) . Posted by:

"waterboy5555" waterboy5555

I think the tables are interactive because Excel's web based query does not recognize them. Here is a snapshot of one table from the source code. From this data, if it is possible to extract the numbers into excel that would be awesome. Thanks for your help.

<td>
<div class="pmx_sstyle">

<div class="TLabelC" style="width:365px;">
<div class="pmx_rowbartitle">Stock Style Diversification</div>
<a href="/Rtport/Reg/StockStyle.aspx?ViewPage=16&dt=9" class="holdingdetail">| Holdings Detail</a>
</div>

<div class="pmx_ssdivers_cola">
<div class="ssdivers_im"><img src="../images/MSTAR/pm2003/Stylebox_Valuation.gif" width="97" height="30"></div>
<div class="pmx_boxw">

<div class="pmx_boxb">36</div>

<div class="pmx_box">25</div>

<div class="pmx_box">33</div>

<div class="pmx_box">3</div>

<div class="pmx_box">3</div>

<div class="pmx_box">1</div>

<div class="pmx_box">0</div>

<div class="pmx_box">0</div>

<div class="pmx_box">0</div>

</div>
<div class="ssdivers_im"><img src="../images/MSTAR/pm2003/Stylebox_Size.gif" width="28" height="97"></div>
</div>
<div class="pmx_ssdivers_colb">
<div class="ssdivers_im"><img src="../images/MSTAR/pm2003/Stylebox_Interest.gif" width="142" height="30"></div>
<div class="pmx_boxw">

<div class="pmx_box">0</div>

<div class="pmx_box">0</div>

<div class="pmx_box">0</div>

<div class="pmx_box">0</div>

<div class="pmx_box">0</div>

<div class="pmx_box">0</div>

<div class="pmx_box">0</div>

<div class="pmx_box">0</div>

<div class="pmx_box">0</div>

</div>
<div class="ssdivers_im"><img src="../images/MSTAR/pm2003/Stylebox_Credit.gif" width="30" height="97"></div>
</div>
<div class="pmx_row175a";>
<div class="ssdivers_cola">Not Classified </div>
<div class="ssdivers_colb">0.00%</div>
</div>
<div class="pmx_row175b";>
<div class="ssdivers_cola">Not Classified </div>
<div class="ssdivers_colb">100.00%</div>
</div>
</div>
</td>
</tr>


--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Take a look at the RCHCreateComment() function (or VBA code).
>
> I don't have access to the X-Ray area, so can't help with details there.
>
> I can say you'll need to log in with IE or the EXCEL Web Query dialog
> (preferred) to create the proper security cookie so that you MAY be able to
> access the charts. However, that assumes they are images, and not some
> application-based charts. If they are interactive, using an application,
> you probably won't be able to bring them into EXCEL.
>
> On Wed, Jul 17, 2013 at 5:22 PM, waterboy5555 <bopha99@...> wrote:
>
> > I would like to import 3 charts on the Morningstar portfolio X ray section
> > to an Excel spreadsheet. I am not very familiar with VBA so I would need a
> > good starting point of how to make such code. Thanks for your help.
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3b

Re: Help Importing data from Morningstar to Excel

Tue Jul 23, 2013 1:28 pm (PDT) . Posted by:

"waterboy5555" waterboy5555

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3c

Re: Help Importing data from Morningstar to Excel

Tue Jul 23, 2013 4:22 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

There aren't any tables there at all, other than the content of a single
table cell. But if I'm understand what you want, the general form would be:

=smfGetTagContent(_URL_,"div",_row_,"Stylebox_Valuation.gif")

...where _URL_ is the URL of the web page in question, and _row_ would vary
from 2 to 10....

On Tue, Jul 23, 2013 at 1:27 PM, waterboy5555 <bopha99@aol.com> wrote:

> I think the tables are interactive because Excel's web based query does
> not recognize them. Here is a snapshot of one table from the source code.
> From this data, if it is possible to extract the numbers into excel that
> would be awesome. Thanks for your help.
>
> <td>
> <div class="pmx_sstyle">
>
> <div class="TLabelC" style="width:365px;">
> <div class="pmx_rowbartitle">Stock Style Diversification</div>
> <a href="/Rtport/Reg/StockStyle.aspx?ViewPage=16&dt=9"
> class="holdingdetail">| Holdings Detail</a>
> </div>
>
> <div class="pmx_ssdivers_cola">
> <div class="ssdivers_im"><img
> src="../images/MSTAR/pm2003/Stylebox_Valuation.gif" width="97"
> height="30"></div>
> <div class="pmx_boxw">
>
> <div class="pmx_boxb">36</div>
>
> <div class="pmx_box">25</div>
>
> <div class="pmx_box">33</div>
>
> <div class="pmx_box">3</div>
>
> <div class="pmx_box">3</div>
>
> <div class="pmx_box">1</div>
>
> <div class="pmx_box">0</div>
>
> <div class="pmx_box">0</div>
>
> <div class="pmx_box">0</div>
>
> </div>
> <div class="ssdivers_im"><img
> src="../images/MSTAR/pm2003/Stylebox_Size.gif" width="28" height="97"></div>
> </div>
> <div class="pmx_ssdivers_colb">
> <div class="ssdivers_im"><img
> src="../images/MSTAR/pm2003/Stylebox_Interest.gif" width="142"
> height="30"></div>
> <div class="pmx_boxw">
>
> <div class="pmx_box">0</div>
>
> <div class="pmx_box">0</div>
>
> <div class="pmx_box">0</div>
>
> <div class="pmx_box">0</div>
>
> <div class="pmx_box">0</div>
>
> <div class="pmx_box">0</div>
>
> <div class="pmx_box">0</div>
>
> <div class="pmx_box">0</div>
>
> <div class="pmx_box">0</div>
>
> </div>
> <div class="ssdivers_im"><img
> src="../images/MSTAR/pm2003/Stylebox_Credit.gif" width="30"
> height="97"></div>
> </div>
> <div class="pmx_row175a";>
> <div class="ssdivers_cola">Not Classified </div>
> <div class="ssdivers_colb">0.00%</div>
> </div>
> <div class="pmx_row175b";>
> <div class="ssdivers_cola">Not Classified </div>
> <div class="ssdivers_colb">100.00%</div>
> </div>
> </div>
> </td>
> </tr>
> 
>
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > Take a look at the RCHCreateComment() function (or VBA code).
> >
> > I don't have access to the X-Ray area, so can't help with details there.
> >
> > I can say you'll need to log in with IE or the EXCEL Web Query dialog
> > (preferred) to create the proper security cookie so that you MAY be able
> to
> > access the charts. However, that assumes they are images, and not some
> > application-based charts. If they are interactive, using an application,
> > you probably won't be able to bring them into EXCEL.
> >
> > On Wed, Jul 17, 2013 at 5:22 PM, waterboy5555 <bopha99@...> wrote:
> >
> > > I would like to import 3 charts on the Morningstar portfolio X ray
> section
> > > to an Excel spreadsheet. I am not very familiar with VBA so I would
> need a
> > > good starting point of how to make such code. Thanks for your help.
> > >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

4a

Re: Advfn quarterly reports not updating

Tue Jul 23, 2013 11:34 pm (PDT) . Posted by:

"ajtalukdar" ajtalukdar

Hi Randy,

It is now amply clear that Advfn is not updating quarterly earnings data. Is there any other data source that can be used as an alternative, apart from Google Finance?

I have tried Google Finance, but have found many errors in their data.

--- In smf_addin@yahoogroups.com, "ajtalukdar" <ajtalukdar@...> wrote:
>
> Hello friends,
>
> I have noticed that lately advfn quarterly data is not getting updated on their website. Intiially I thought it was a problem with the add-in, but found that the advfn site itself is where the problem is. For instance, the quarterly data for none of the companies that have declared results this quarter have beenn updated - e.g. Alcoa, Yum Brands, wells fargo etc..
>
> The quarterly reports of some stock from the previous quarter are also pending - e.g. Oracle, Nike, Fedex, etc.
>
> Is anyone else facing this problem?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

4b

Re: Advfn quarterly reports not updating

Tue Jul 23, 2013 11:43 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

GuruFocus?

http://www.gurufocus.com/financials_print.php?symbol=AA

MorningStar? NASDAQ? Yahoo? MSN?

I don't know what quarterly data you're looking for. Google:

AA "income statement" quarterly

...and you'll find lots of sources of data.

On Tue, Jul 23, 2013 at 11:34 PM, ajtalukdar <ajtalukdar@yahoo.com> wrote:

>
> It is now amply clear that Advfn is not updating quarterly earnings data.
> Is there any other data source that can be used as an alternative, apart
> from Google Finance?
>
> I have tried Google Finance, but have found many errors in their data.
>