15 New Messages
Digest #2707
Messages
Wed Jul 24, 2013 8:09 am (PDT) . Posted by:
"Russell M" rerussellson
I too was worried about the ADVFN feeds so I emailed them...here is their response:
"Our financials for USA listed companies are using an old outdated feed from our service provider. Last week we began updating our financials to use the latest feed and hope to have it working soon as possible. Likely next week will be the earliest we can make the new financials available on the website."
We should be ok soon....
--- In smf_addin@yahoogroups.com , "ajtalukdar" <ajtalukdar@...> wrote:
>
> 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?
> >
>
"Our financials for USA listed companies are using an old outdated feed from our service provider. Last week we began updating our financials to use the latest feed and hope to have it working soon as possible. Likely next week will be the earliest we can make the new financials available on the website."
We should be ok soon....
--- In smf_addin@yahoogrou
>
> 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@yahoogrou
> >
> > 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?
> >
>
Wed Jul 24, 2013 9:51 am (PDT) . Posted by:
"waterboy5555" waterboy5555
I have tried to use this function, but am getting a #name? error. To use the smfgettagcontent formula, do I need to install an add in or something? Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> 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>
> > <!-- End Bond Style -->
> >
> >
> > --- 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
> >
> >
> >
> >
>
--- In smf_addin@yahoogrou
>
> 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(
>
> ...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@
>
> > 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="
> >
> > <div class="
> > <div class="
> > <a href="/
> > class="
> > </div>
> >
> > <div class="
> > <div class="
> > src="..
> > height="
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > </div>
> > <div class="
> > src="..
> > </div>
> > <div class="
> > <div class="
> > src="..
> > height="
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > <div class="
> >
> > </div>
> > <div class="
> > src="..
> > height="
> > </div>
> > <div class="
> > <div class="
> > <div class="
> > </div>
> > <div class="
> > <div class="
> > <div class="
> > </div>
> > </div>
> > </td>
> > </tr>
> > <!-- End Bond Style -->
> >
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Take a look at the RCHCreateComment(
> > >
> > > 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-
> > > you probably won't be able to bring them into EXCEL.
> > >
> > > On Wed, Jul 17, 2013 at 5:22 PM, waterboy5555 <bopha99@
> > >
> > > > 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
> >
> >
> >
> >
>
Wed Jul 24, 2013 9:54 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's part of the SMF add-in. Are you using an old version? Or are you not
even using the add-in?
On Wed, Jul 24, 2013 at 9:51 AM, waterboy5555 <bopha99@aol.com > wrote:
> I have tried to use this function, but am getting a #name? error. To use
> the smfgettagcontent formula, do I need to install an add in or something?
> Thanks.
>
even using the add-in?
On Wed, Jul 24, 2013 at 9:51 AM, waterboy5555 <bopha99@aol.
> I have tried to use this function, but am getting a #name? error. To use
> the smfgettagcontent formula, do I need to install an add in or something?
> Thanks.
>
Wed Jul 24, 2013 10:31 am (PDT) . Posted by:
"waterboy5555" waterboy5555
I believe I have added the add in now to excel. I am getting an error value in the cell I am using. The error value is linked to the webpage I want to get the information from. What can I try to not get the error value? I am using Excel 2010. Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It's part of the SMF add-in. Are you using an old version? Or are you not
> even using the add-in?
>
> On Wed, Jul 24, 2013 at 9:51 AM, waterboy5555 <bopha99@...> wrote:
>
> > I have tried to use this function, but am getting a #name? error. To use
> > the smfgettagcontent formula, do I need to install an add in or something?
> > Thanks.
> >
>
--- In smf_addin@yahoogrou
>
> It's part of the SMF add-in. Are you using an old version? Or are you not
> even using the add-in?
>
> On Wed, Jul 24, 2013 at 9:51 AM, waterboy5555 <bopha99@
>
> > I have tried to use this function, but am getting a #name? error. To use
> > the smfgettagcontent formula, do I need to install an add in or something?
> > Thanks.
> >
>
Wed Jul 24, 2013 10:37 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Did you visit MorningStar with the EXCEL Web Query process (preferred) or
with IE? They have a redirection process they go through on the first visit
of the day, so you need to have a cookie updated before the add-in can
access data.
Be sure to run the smfForceRecalculation after that, because you would need
to purge the add-in's saved copy of the web page (the once causing the
error). For more information on that macro, see the LINKS area of the group.
On Wed, Jul 24, 2013 at 10:31 AM, waterboy5555 <bopha99@aol.com > wrote:
> I believe I have added the add in now to excel. I am getting an error
> value in the cell I am using. The error value is linked to the webpage I
> want to get the information from. What can I try to not get the error
> value? I am using Excel 2010. Thanks.
>
with IE? They have a redirection process they go through on the first visit
of the day, so you need to have a cookie updated before the add-in can
access data.
Be sure to run the smfForceRecalculati
to purge the add-in's saved copy of the web page (the once causing the
error). For more information on that macro, see the LINKS area of the group.
On Wed, Jul 24, 2013 at 10:31 AM, waterboy5555 <bopha99@aol.
> I believe I have added the add in now to excel. I am getting an error
> value in the cell I am using. The error value is linked to the webpage I
> want to get the information from. What can I try to not get the error
> value? I am using Excel 2010. Thanks.
>
Wed Jul 24, 2013 10:50 am (PDT) . Posted by:
"waterboy5555" waterboy5555
Ahh. I tried both of those steps, but still am getting an error. When I enter the smfforcerecalculation in F8, am I supposed to see something pop up in the blank window? Because I just clicked run, but there were no changes.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Did you visit MorningStar with the EXCEL Web Query process (preferred) or
> with IE? They have a redirection process they go through on the first visit
> of the day, so you need to have a cookie updated before the add-in can
> access data.
>
> Be sure to run the smfForceRecalculation after that, because you would need
> to purge the add-in's saved copy of the web page (the once causing the
> error). For more information on that macro, see the LINKS area of the group.
>
> On Wed, Jul 24, 2013 at 10:31 AM, waterboy5555 <bopha99@...> wrote:
>
> > I believe I have added the add in now to excel. I am getting an error
> > value in the cell I am using. The error value is linked to the webpage I
> > want to get the information from. What can I try to not get the error
> > value? I am using Excel 2010. Thanks.
> >
>
--- In smf_addin@yahoogrou
>
> Did you visit MorningStar with the EXCEL Web Query process (preferred) or
> with IE? They have a redirection process they go through on the first visit
> of the day, so you need to have a cookie updated before the add-in can
> access data.
>
> Be sure to run the smfForceRecalculati
> to purge the add-in's saved copy of the web page (the once causing the
> error). For more information on that macro, see the LINKS area of the group.
>
> On Wed, Jul 24, 2013 at 10:31 AM, waterboy5555 <bopha99@
>
> > I believe I have added the add in now to excel. I am getting an error
> > value in the cell I am using. The error value is linked to the webpage I
> > want to get the information from. What can I try to not get the error
> > value? I am using Excel 2010. Thanks.
> >
>
Wed Jul 24, 2013 11:08 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
What do you get with this =RCHGetElementNumber("Version")
This will confirm you have the addin PROPERLY INSTALLED.
Here is what I get:
Stock Market Functions add-in, Version 2.1.2013.06.03 (C:\SMFADDIN; 1)
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of waterboy5555
Sent: Wednesday, July 24, 2013 1:51 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Help Importing data from Morningstar to Excel
Ahh. I tried both of those steps, but still am getting an error. When I
enter the smfforcerecalculation in F8, am I supposed to see something pop up
in the blank window? Because I just clicked run, but there were no changes.
--- In <mailto:smf_addin@yahoogroups.com > smf_addin@yahoogroups.com , Randy
Harmelink < <mailto:rharmelink@...> rharmelink@...> wrote:
>
> Did you visit MorningStar with the EXCEL Web Query process (preferred)
> or with IE? They have a redirection process they go through on the
> first visit of the day, so you need to have a cookie updated before
> the add-in can access data.
>
> Be sure to run the smfForceRecalculation after that, because you would
> need to purge the add-in's saved copy of the web page (the once
> causing the error). For more information on that macro, see the LINKS area
of the group.
>
> On Wed, Jul 24, 2013 at 10:31 AM, waterboy5555 < <mailto:bopha99@...>
bopha99@...> wrote:
>
> > I believe I have added the add in now to excel. I am getting an
> > error value in the cell I am using. The error value is linked to
> > the webpage I want to get the information from. What can I try to
> > not get the error value? I am using Excel 2010. Thanks.
> >
>
------------------------------------
Yahoo! Groups Links
(Yahoo! ID required)
<mailto:smf_addin-fullfeatured@yahoogroups.com >
smf_addin-fullfeatured@yahoogroups.com
This will confirm you have the addin PROPERLY INSTALLED.
Here is what I get:
Stock Market Functions add-in, Version 2.1.2013.06.
-----Original Message-----
From: smf_addin@yahoogrou
Of waterboy5555
Sent: Wednesday, July 24, 2013 1:51 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: Help Importing data from Morningstar to Excel
Ahh. I tried both of those steps, but still am getting an error. When I
enter the smfforcerecalculati
in the blank window? Because I just clicked run, but there were no changes.
--- In <mailto:smf_addin@yahoogrou
Harmelink < <mailto:rharmeli
>
> Did you visit MorningStar with the EXCEL Web Query process (preferred)
> or with IE? They have a redirection process they go through on the
> first visit of the day, so you need to have a cookie updated before
> the add-in can access data.
>
> Be sure to run the smfForceRecalculati
> need to purge the add-in's saved copy of the web page (the once
> causing the error). For more information on that macro, see the LINKS area
of the group.
>
> On Wed, Jul 24, 2013 at 10:31 AM, waterboy5555 < <mailto:bopha99@
bopha99@...> wrote:
>
> > I believe I have added the add in now to excel. I am getting an
> > error value in the cell I am using. The error value is linked to
> > the webpage I want to get the information from. What can I try to
> > not get the error value? I am using Excel 2010. Thanks.
> >
>
------------
Yahoo! Groups Links
(Yahoo! ID required)
<mailto:smf_addin-fullfeatu
smf_addin-fullfeatu
Wed Jul 24, 2013 11:18 am (PDT) . Posted by:
"waterboy5555" waterboy5555
I get
Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Users\csakai\Documents\Add in; 1)
If the source code is this where I want to extract the numbers like 79 and 12 and 0, what is the excel function that I should have?
<table class="assetTbl" border="0" cellpadding="0" cellspacing="0" width="230">
<tbody>
<tr class="assetFirstTr">
<td>
<img src="../images/MSTAR/pm2003/d.gif" height="10" width="10">
</td>
<td>
<img src="../images/MSTAR/pm2003/d.gif" height="1" width="5">
</td>
<td>
<img src="../images/MSTAR/pm2003/d.gif" height="1" width="84">
</td>
<td class="long">
<img src="../images/MSTAR/pm2003/d.gif" height="1" width="43">
</td>
<td class="short">
<img src="../images/MSTAR/pm2003/d.gif" height="1" width="48">
</td>
<td>
<img src="../images/MSTAR/pm2003/d.gif" height="1" width="40">
</td>
</tr>
<tr class="TextData">
<td>
</td>
<td>
</td>
<td>
</td>
<td class="TextDescription long" align="right">
Long%
</td>
<td class="TextDescription short" align="right">
Short%
</td>
<td class="TextDescription" align="right">
Net%
</td>
</tr>
<tr class="TextData">
<td>
<img src="//im.mstar.com/im/pm/xray/dot_green.gif">
</td>
<td>
</td>
<td height="19">
Cash
</td>
<td align="right" class="long">
6
</td>
<td align="right" class="short">
-1
</td>
<td align="right">
4
</td>
</tr>
<tr class="TextData">
<td>
<img src="//im.mstar.com/im/pm/xray/dot_dkblue.gif">
</td>
<td>
</td>
<td height="19">
U.S. Stocks
</td>
<td align="right" class="long">
79
</td>
<td align="right" class="short">
0
</td>
<td align="right">
79
</td>
</tr>
<tr class="TextData">
<td>
<img src="//im.mstar.com/im/pm/xray/dot_red.gif">
</td>
<td>
</td>
<td height="19">
Foreign Stocks
</td>
<td align="right" class="long">
12
</td>
<td align="right" class="short">
0
</td>
<td align="right">
12
</td>
</tr>
<tr class="TextData">
<td>
<img src="//im.mstar.com/im/pm/xray/dot_orange.gif">
</td>
<td>
</td>
<td height="19">
Bonds
</td>
<td align="right" class="long">
4
</td>
<td align="right" class="short">
0
</td>
<td align="right">
4
</td>
</tr>
<tr class="TextData">
<td>
<img src="//im.mstar.com/im/pm/xray/dot_blue.gif">
</td>
<td>
</td>
<td height="19">
Other
</td>
<td align="right" class="long">
2
</td>
<td align="right" class="short">
0
</td>
<td align="right">
2
</td>
</tr>
<tr class="TextData">
<td>
<img src="//im.mstar.com/im/pm/xray/dot_gray.gif">
</td>
<td>
</td>
<td height="19">
Not Classified
</td>
<td align="right" class="long">
0
</td>
<td align="right" class="short">
0
</td>
<td align="right">
0
</td>
</tr>
--- In smf_addin@yahoogroups.com , "Kermit W. Prather" <kermitp@...> wrote:
>
> What do you get with this =RCHGetElementNumber("Version")
>
> This will confirm you have the addin PROPERLY INSTALLED.
>
> Here is what I get:
>
> Stock Market Functions add-in, Version 2.1.2013.06.03 (C:\SMFADDIN; 1)
>
> -----Original Message-----
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
> Of waterboy5555
> Sent: Wednesday, July 24, 2013 1:51 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: Help Importing data from Morningstar to Excel
>
> Ahh. I tried both of those steps, but still am getting an error. When I
> enter the smfforcerecalculation in F8, am I supposed to see something pop up
> in the blank window? Because I just clicked run, but there were no changes.
>
> --- In <mailto:smf_addin@yahoogroups.com > smf_addin@yahoogroups.com , Randy
> Harmelink < <mailto:rharmelink@> rharmelink@> wrote:
> >
> > Did you visit MorningStar with the EXCEL Web Query process (preferred)
> > or with IE? They have a redirection process they go through on the
> > first visit of the day, so you need to have a cookie updated before
> > the add-in can access data.
> >
> > Be sure to run the smfForceRecalculation after that, because you would
> > need to purge the add-in's saved copy of the web page (the once
> > causing the error). For more information on that macro, see the LINKS area
> of the group.
> >
> > On Wed, Jul 24, 2013 at 10:31 AM, waterboy5555 < <mailto:bopha99@>
> bopha99@> wrote:
> >
> > > I believe I have added the add in now to excel. I am getting an
> > > error value in the cell I am using. The error value is linked to
> > > the webpage I want to get the information from. What can I try to
> > > not get the error value? I am using Excel 2010. Thanks.
> > >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
> (Yahoo! ID required)
>
> <mailto:smf_addin-fullfeatured@yahoogroups.com >
> smf_addin-fullfeatured@yahoogroups.com
>
Stock Market Functions add-in, Version 2.1.2012.12.
If the source code is this where I want to extract the numbers like 79 and 12 and 0, what is the excel function that I should have?
<table class="
<tbody>
<tr class="
<td>
<img src="..
</td>
<td>
<img src="..
</td>
<td>
<img src="..
</td>
<td class="
<img src="..
</td>
<td class="
<img src="..
</td>
<td>
<img src="..
</td>
</tr>
<tr class="
<td>
</td>
<td>
</td>
<td>
</td>
<td class="
Long%
</td>
<td class="
Short%
</td>
<td class="
Net%
</td>
</tr>
<tr class="
<td>
<img src="//
</td>
<td>
</td>
<td height="
Cash
</td>
<td align="
6
</td>
<td align="
-1
</td>
<td align="
4
</td>
</tr>
<tr class="
<td>
<img src="//
</td>
<td>
</td>
<td height="
U.S. Stocks
</td>
<td align="
79
</td>
<td align="
0
</td>
<td align="
79
</td>
</tr>
<tr class="
<td>
<img src="//
</td>
<td>
</td>
<td height="
Foreign Stocks
</td>
<td align="
12
</td>
<td align="
0
</td>
<td align="
12
</td>
</tr>
<tr class="
<td>
<img src="//
</td>
<td>
</td>
<td height="
Bonds
</td>
<td align="
4
</td>
<td align="
0
</td>
<td align="
4
</td>
</tr>
<tr class="
<td>
<img src="//
</td>
<td>
</td>
<td height="
Other
</td>
<td align="
2
</td>
<td align="
0
</td>
<td align="
2
</td>
</tr>
<tr class="
<td>
<img src="//
</td>
<td>
</td>
<td height="
Not Classified
</td>
<td align="
0
</td>
<td align="
0
</td>
<td align="
0
</td>
</tr>
--- In smf_addin@yahoogrou
>
> What do you get with this =RCHGetElementNumbe
>
> This will confirm you have the addin PROPERLY INSTALLED.
>
> Here is what I get:
>
> Stock Market Functions add-in, Version 2.1.2013.06.
>
> -----Original Message-----
> From: smf_addin@yahoogrou
> Of waterboy5555
> Sent: Wednesday, July 24, 2013 1:51 PM
> To: smf_addin@yahoogrou
> Subject: [smf_addin] Re: Help Importing data from Morningstar to Excel
>
> Ahh. I tried both of those steps, but still am getting an error. When I
> enter the smfforcerecalculati
> in the blank window? Because I just clicked run, but there were no changes.
>
> --- In <mailto:smf_addin@yahoogrou
> Harmelink < <mailto:rharmeli
> >
> > Did you visit MorningStar with the EXCEL Web Query process (preferred)
> > or with IE? They have a redirection process they go through on the
> > first visit of the day, so you need to have a cookie updated before
> > the add-in can access data.
> >
> > Be sure to run the smfForceRecalculati
> > need to purge the add-in's saved copy of the web page (the once
> > causing the error). For more information on that macro, see the LINKS area
> of the group.
> >
> > On Wed, Jul 24, 2013 at 10:31 AM, waterboy5555 < <mailto:bopha99@
> bopha99@> wrote:
> >
> > > I believe I have added the add in now to excel. I am getting an
> > > error value in the cell I am using. The error value is linked to
> > > the webpage I want to get the information from. What can I try to
> > > not get the error value? I am using Excel 2010. Thanks.
> > >
> >
>
>
>
>
> ------------
>
> Yahoo! Groups Links
>
>
> (Yahoo! ID required)
>
> <mailto:smf_addin-fullfeatu
> smf_addin-fullfeatu
>
Wed Jul 24, 2013 11:26 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The 79 and 12 I would get with something like this:
=RCHGetTableCell("http://ogres-crypt.com/tmp/test.html ",1,"Long%","U.S.
Stocks")
=RCHGetTableCell("http://ogres-crypt.com/tmp/test.html ",1,"Long%","Foreign
Stocks")
On Wed, Jul 24, 2013 at 11:18 AM, waterboy5555 <bopha99@aol.com > wrote:
>
> If the source code is this where I want to extract the numbers like 79 and
> 12 and 0, what is the excel function that I should have?
>
=RCHGetTableCell(
Stocks"
=RCHGetTableCell(
Stocks"
On Wed, Jul 24, 2013 at 11:18 AM, waterboy5555 <bopha99@aol.
>
> If the source code is this where I want to extract the numbers like 79 and
> 12 and 0, what is the excel function that I should have?
>
Wed Jul 24, 2013 11:40 am (PDT) . Posted by:
"waterboy5555" waterboy5555
I am using that formula with the morningstar website, but I am still getting an error value that is linked to the ogres-crypt website. I have also ran the smfforce macro, but still the error value. What do you think I'm doing wrong?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The 79 and 12 I would get with something like this:
>
> =RCHGetTableCell("http://ogres-crypt.com/tmp/test.html ",1,"Long%","U.S.
> Stocks")
> =RCHGetTableCell("http://ogres-crypt.com/tmp/test.html ",1,"Long%","Foreign
> Stocks")
>
> On Wed, Jul 24, 2013 at 11:18 AM, waterboy5555 <bopha99@...> wrote:
>
> >
> > If the source code is this where I want to extract the numbers like 79 and
> > 12 and 0, what is the excel function that I should have?
> >
>
--- In smf_addin@yahoogrou
>
> The 79 and 12 I would get with something like this:
>
> =RCHGetTableCell(
> Stocks"
> =RCHGetTableCell(
> Stocks"
>
> On Wed, Jul 24, 2013 at 11:18 AM, waterboy5555 <bopha99@
>
> >
> > If the source code is this where I want to extract the numbers like 79 and
> > 12 and 0, what is the excel function that I should have?
> >
>
Wed Jul 24, 2013 11:51 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I have no idea what you mean when you say something is linked, as in: "I am
still getting an error value that is linked to the ogres-crypt website".
But, we can try a few things:
Exit EXCEL, restart it, and then use the
smfGetTagContent-Quick-Webpage-Examination.xls workbook to try a couple of
tests. First, try the "By HTML Tag" worksheet, entering:
Web Page: http://ogres-crypt.com/tmp/test.html
HTML Tag: tr
...and you should see eight rows of data displayed, followed by a bunch of
"Error" results. Then, try the "Table Extract" worksheet, entering:
Web Page: http://ogres-crypt.com/tmp/test.html
Begin String:
Begin Direction: 0
End String:
End Direction: 1
...and that table should be displayed. Last resort, go to the "By Fixed
Length" worksheet, entering:
Web Page: http://ogres-crypt.com/tmp/test.html
Length: 150
...which should display the contents of the web page 150 bytes at a time.
If you get "Error" on every line, it means the web page was not retrieved.
You may have a firewall preventing EXCEL from accessing the Internet?
Beyond that, I haven't a clue.
On Wed, Jul 24, 2013 at 11:40 AM, waterboy5555 <bopha99@aol.com > wrote:
> I am using that formula with the morningstar website, but I am still
> getting an error value that is linked to the ogres-crypt website. I have
> also ran the smfforce macro, but still the error value. What do you think
> I'm doing wrong?
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > The 79 and 12 I would get with something like this:
> >
> > =RCHGetTableCell("http://ogres-crypt.com/tmp/test.html ",1,"Long%","U.S.
> > Stocks")
> > =RCHGetTableCell("http://ogres-crypt.com/tmp/test.html
> ",1,"Long%","Foreign
> > Stocks")
> >
> > On Wed, Jul 24, 2013 at 11:18 AM, waterboy5555 <bopha99@...> wrote:
> >
> > >
> > > If the source code is this where I want to extract the numbers like 79
> and
> > > 12 and 0, what is the excel function that I should have?
> > >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
still getting an error value that is linked to the ogres-crypt website"
But, we can try a few things:
Exit EXCEL, restart it, and then use the
smfGetTagContent-
tests. First, try the "By HTML Tag" worksheet, entering:
Web Page: http://ogres-
HTML Tag: tr
...and you should see eight rows of data displayed, followed by a bunch of
"Error" results. Then, try the "Table Extract" worksheet, entering:
Web Page: http://ogres-
Begin String:
Begin Direction: 0
End String:
End Direction: 1
...and that table should be displayed. Last resort, go to the "By Fixed
Length" worksheet, entering:
Web Page: http://ogres-
Length: 150
...which should display the contents of the web page 150 bytes at a time.
If you get "Error" on every line, it means the web page was not retrieved.
You may have a firewall preventing EXCEL from accessing the Internet?
Beyond that, I haven't a clue.
On Wed, Jul 24, 2013 at 11:40 AM, waterboy5555 <bopha99@aol.
> I am using that formula with the morningstar website, but I am still
> getting an error value that is linked to the ogres-crypt website. I have
> also ran the smfforce macro, but still the error value. What do you think
> I'm doing wrong?
>
> --- In smf_addin@yahoogrou
> >
> > The 79 and 12 I would get with something like this:
> >
> > =RCHGetTableCell(
> > Stocks"
> > =RCHGetTableCell(
> ",1,"
> > Stocks"
> >
> > On Wed, Jul 24, 2013 at 11:18 AM, waterboy5555 <bopha99@
> >
> > >
> > > If the source code is this where I want to extract the numbers like 79
> and
> > > 12 and 0, what is the excel function that I should have?
> > >
> >
>
>
>
>
> ------------
>
> Yahoo! Groups Links
>
>
>
>
Wed Jul 24, 2013 9:54 am (PDT) . Posted by:
"Steven" stevenletzer
I am using this formula to capture bond information from an internal web site. In he formula "Project Name" is an example of a cell label on the web page.
RCHGetTableCell("https://www.bonddesk.com/hrbfa/servlet/issuedesc/issuedesc.htm?p_id_type=C&p_cusip= "&$A2,1,"Project Name")
My problem is the ratings information. Below, "Moodys Rating Information" and "S&P Ratings Information" are sub-headers, in the same column to the left of the data information. The sub-headers are below the header. My problem is that the cell labels below the header are not unique and are repeated. The "Long Term Rating" is repeated under both of the headers. As you can see below, the other cell labels are repeated beow the header.
Moodys Rating Information
Long Term Rating Aa3 effective 01/17/2013
Short Term Rating
Creditwatch
S&P Rating Information
Long Term Rating AA- effective 11/30/2011 18:54:04
Short Term Rating -
Outlook STABLE effective 11/30/2011 18:54:04
Creditwatch
I changed the formula and was successful of getting the first line under the header. However, I am unable to write the formula to get "Short Term Rating", "Outlook", and "Credit Watch". The data is 1 cell to the right of the cell label.
This is the formula I used to get the data 1 line below the header.
RCHGetTableCell("https://www.bonddesk.com/hrbfa/servlet/issuedesc/issuedesc.htm?p_id_type=C&p_cusip= "&$A2,1,"S&P Rating Information",,,1)
How can I adjust the formula above to get the data I need?
RCHGetTableCell(
My problem is the ratings information. Below, "Moodys Rating Information" and "S&P Ratings Information" are sub-headers, in the same column to the left of the data information. The sub-headers are below the header. My problem is that the cell labels below the header are not unique and are repeated. The "Long Term Rating" is repeated under both of the headers. As you can see below, the other cell labels are repeated beow the header.
Moodys Rating Information
Long Term Rating Aa3 effective 01/17/2013
Short Term Rating
Creditwatch
S&P Rating Information
Long Term Rating AA- effective 11/30/2011 18:54:04
Short Term Rating -
Outlook STABLE effective 11/30/2011 18:54:04
Creditwatch
I changed the formula and was successful of getting the first line under the header. However, I am unable to write the formula to get "Short Term Rating"
This is the formula I used to get the data 1 line below the header.
RCHGetTableCell(
How can I adjust the formula above to get the data I need?
Wed Jul 24, 2013 9:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'll need a sample URL. The ones you have below all use a cell reference,
and I have no idea what to use for it.
On Wed, Jul 24, 2013 at 9:54 AM, Steven <stevenletzer@yahoo.com > wrote:
> I am using this formula to capture bond information from an internal web
> site. In he formula "Project Name" is an example of a cell label on the web
> page.
>
> RCHGetTableCell("
> https://www.bonddesk.com/hrbfa/servlet/issuedesc/issuedesc.htm?p_id_type=C&p_cusip= "&$A2,1,"Project
> Name")
>
> My problem is the ratings information. Below, "Moodys Rating Information"
> and "S&P Ratings Information" are sub-headers, in the same column to the
> left of the data information. The sub-headers are below the header. My
> problem is that the cell labels below the header are not unique and are
> repeated. The "Long Term Rating" is repeated under both of the headers. As
> you can see below, the other cell labels are repeated beow the header.
>
> Moodys Rating Information
> Long Term Rating Aa3 effective 01/17/2013
> Short Term Rating
> Creditwatch
>
> S&P Rating Information
> Long Term Rating AA- effective 11/30/2011 18:54:04
> Short Term Rating -
> Outlook STABLE effective 11/30/2011 18:54:04
> Creditwatch
>
> I changed the formula and was successful of getting the first line under
> the header. However, I am unable to write the formula to get "Short Term
> Rating", "Outlook", and "Credit Watch". The data is 1 cell to the right of
> the cell label.
>
> This is the formula I used to get the data 1 line below the header.
>
> RCHGetTableCell("
> https://www.bonddesk.com/hrbfa/servlet/issuedesc/issuedesc.htm?p_id_type=C&p_cusip= "&$A2,1,"S&P
> Rating Information",,,1)
>
> How can I adjust the formula above to get the data I need?
>
and I have no idea what to use for it.
On Wed, Jul 24, 2013 at 9:54 AM, Steven <stevenletzer@
> I am using this formula to capture bond information from an internal web
> site. In he formula "Project Name" is an example of a cell label on the web
> page.
>
> RCHGetTableCell(
> https://www.
> Name")
>
> My problem is the ratings information. Below, "Moodys Rating Information"
> and "S&P Ratings Information" are sub-headers, in the same column to the
> left of the data information. The sub-headers are below the header. My
> problem is that the cell labels below the header are not unique and are
> repeated. The "Long Term Rating" is repeated under both of the headers. As
> you can see below, the other cell labels are repeated beow the header.
>
> Moodys Rating Information
> Long Term Rating Aa3 effective 01/17/2013
> Short Term Rating
> Creditwatch
>
> S&P Rating Information
> Long Term Rating AA- effective 11/30/2011 18:54:04
> Short Term Rating -
> Outlook STABLE effective 11/30/2011 18:54:04
> Creditwatch
>
> I changed the formula and was successful of getting the first line under
> the header. However, I am unable to write the formula to get "Short Term
> Rating"
> the cell label.
>
> This is the formula I used to get the data 1 line below the header.
>
> RCHGetTableCell(
> https://www.
> Rating Information"
>
> How can I adjust the formula above to get the data I need?
>
Wed Jul 24, 2013 10:02 am (PDT) . Posted by:
"Steven" stevenletzer
How do I send you a spread sheet?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I'll need a sample URL. The ones you have below all use a cell reference,
> and I have no idea what to use for it.
>
> On Wed, Jul 24, 2013 at 9:54 AM, Steven <stevenletzer@...> wrote:
>
> > I am using this formula to capture bond information from an internal web
> > site. In he formula "Project Name" is an example of a cell label on the web
> > page.
> >
> > RCHGetTableCell("
> > https://www.bonddesk.com/hrbfa/servlet/issuedesc/issuedesc.htm?p_id_type=C&p_cusip= "&$A2,1,"Project
> > Name")
> >
> > My problem is the ratings information. Below, "Moodys Rating Information"
> > and "S&P Ratings Information" are sub-headers, in the same column to the
> > left of the data information. The sub-headers are below the header. My
> > problem is that the cell labels below the header are not unique and are
> > repeated. The "Long Term Rating" is repeated under both of the headers. As
> > you can see below, the other cell labels are repeated beow the header.
> >
> > Moodys Rating Information
> > Long Term Rating Aa3 effective 01/17/2013
> > Short Term Rating
> > Creditwatch
> >
> > S&P Rating Information
> > Long Term Rating AA- effective 11/30/2011 18:54:04
> > Short Term Rating -
> > Outlook STABLE effective 11/30/2011 18:54:04
> > Creditwatch
> >
> > I changed the formula and was successful of getting the first line under
> > the header. However, I am unable to write the formula to get "Short Term
> > Rating", "Outlook", and "Credit Watch". The data is 1 cell to the right of
> > the cell label.
> >
> > This is the formula I used to get the data 1 line below the header.
> >
> > RCHGetTableCell("
> > https://www.bonddesk.com/hrbfa/servlet/issuedesc/issuedesc.htm?p_id_type=C&p_cusip= "&$A2,1,"S&P
> > Rating Information",,,1)
> >
> > How can I adjust the formula above to get the data I need?
> >
>
--- In smf_addin@yahoogrou
>
> I'll need a sample URL. The ones you have below all use a cell reference,
> and I have no idea what to use for it.
>
> On Wed, Jul 24, 2013 at 9:54 AM, Steven <stevenletzer@
>
> > I am using this formula to capture bond information from an internal web
> > site. In he formula "Project Name" is an example of a cell label on the web
> > page.
> >
> > RCHGetTableCell(
> > https://www.
> > Name")
> >
> > My problem is the ratings information. Below, "Moodys Rating Information"
> > and "S&P Ratings Information" are sub-headers, in the same column to the
> > left of the data information. The sub-headers are below the header. My
> > problem is that the cell labels below the header are not unique and are
> > repeated. The "Long Term Rating" is repeated under both of the headers. As
> > you can see below, the other cell labels are repeated beow the header.
> >
> > Moodys Rating Information
> > Long Term Rating Aa3 effective 01/17/2013
> > Short Term Rating
> > Creditwatch
> >
> > S&P Rating Information
> > Long Term Rating AA- effective 11/30/2011 18:54:04
> > Short Term Rating -
> > Outlook STABLE effective 11/30/2011 18:54:04
> > Creditwatch
> >
> > I changed the formula and was successful of getting the first line under
> > the header. However, I am unable to write the formula to get "Short Term
> > Rating"
> > the cell label.
> >
> > This is the formula I used to get the data 1 line below the header.
> >
> > RCHGetTableCell(
> > https://www.
> > Rating Information"
> >
> > How can I adjust the formula above to get the data I need?
> >
>
Wed Jul 24, 2013 10:03 am (PDT) . Posted by:
"gbullr" gbullr
Not directly answering your question but take a look at
SMF Bond Price file on user forum for ratings from S&P & Moodys.
--- In smf_addin@yahoogroups.com , "Steven" <stevenletzer@...> wrote:
>
> I am using this formula to capture bond information from an internal web site. In he formula "Project Name" is an example of a cell label on the web page.
>
> RCHGetTableCell("https://www.bonddesk.com/hrbfa/servlet/issuedesc/issuedesc.htm?p_id_type=C&p_cusip= "&$A2,1,"Project Name")
>
> My problem is the ratings information. Below, "Moodys Rating Information" and "S&P Ratings Information" are sub-headers, in the same column to the left of the data information. The sub-headers are below the header. My problem is that the cell labels below the header are not unique and are repeated. The "Long Term Rating" is repeated under both of the headers. As you can see below, the other cell labels are repeated beow the header.
>
> Moodys Rating Information
> Long Term Rating Aa3 effective 01/17/2013
> Short Term Rating
> Creditwatch
>
> S&P Rating Information
> Long Term Rating AA- effective 11/30/2011 18:54:04
> Short Term Rating -
> Outlook STABLE effective 11/30/2011 18:54:04
> Creditwatch
>
> I changed the formula and was successful of getting the first line under the header. However, I am unable to write the formula to get "Short Term Rating", "Outlook", and "Credit Watch". The data is 1 cell to the right of the cell label.
>
> This is the formula I used to get the data 1 line below the header.
>
> RCHGetTableCell("https://www.bonddesk.com/hrbfa/servlet/issuedesc/issuedesc.htm?p_id_type=C&p_cusip= "&$A2,1,"S&P Rating Information",,,1)
>
> How can I adjust the formula above to get the data I need?
>
SMF Bond Price file on user forum for ratings from S&P & Moodys.
--- In smf_addin@yahoogrou
>
> I am using this formula to capture bond information from an internal web site. In he formula "Project Name" is an example of a cell label on the web page.
>
> RCHGetTableCell(
>
> My problem is the ratings information. Below, "Moodys Rating Information" and "S&P Ratings Information" are sub-headers, in the same column to the left of the data information. The sub-headers are below the header. My problem is that the cell labels below the header are not unique and are repeated. The "Long Term Rating" is repeated under both of the headers. As you can see below, the other cell labels are repeated beow the header.
>
> Moodys Rating Information
> Long Term Rating Aa3 effective 01/17/2013
> Short Term Rating
> Creditwatch
>
> S&P Rating Information
> Long Term Rating AA- effective 11/30/2011 18:54:04
> Short Term Rating -
> Outlook STABLE effective 11/30/2011 18:54:04
> Creditwatch
>
> I changed the formula and was successful of getting the first line under the header. However, I am unable to write the formula to get "Short Term Rating"
>
> This is the formula I used to get the data 1 line below the header.
>
> RCHGetTableCell(
>
> How can I adjust the formula above to get the data I need?
>
Tidak ada komentar:
Posting Komentar