9 New Messages
Digest #2708
3b
Re: Problem reading ticker symbol for Indian stocks in Morningstar by "Randy Harmelink" rharmelink
Messages
Wed Jul 24, 2013 11:52 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
That's a fairy old version. You might want to go to the files section and
get the latest version. I just did after responding earlier
I now have this version:
Stock Market Functions add-in, Version 2.1.2013.06.28 (C:\SMFADDIN; 1)
Make sure you copy the version you have installed now to another
subdirectory for insurance. I always keep several version as backup.
The folder I save the current version I name Replaced-07-24-13 that way I
know the exact date I replaced it. Also, if something goes wrong it only
take a few minutes to swap the versions.
This may or may not fix your problem.
Is anything working with the SMF ADDin?
I'm really confused as to what it is you are trying to retrieve.
Is the data you are trying to retrieve from Morningstar FREE data or does it
require you to sign in first?
What is the actual URL of the page you are extracting the data from?
=RCHGetTableCell("http://dividata.com/stock/AGNC ",1,"Dividend Yield:")
You should get 0.1897 or 18.97%
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of waterboy5555
Sent: Wednesday, July 24, 2013 2:18 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Help Importing data from Morningstar to Excel
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 <mailto:smf_addin@yahoogroups.com > smf_addin@yahoogroups.com ,
"Kermit W. Prather" < <mailto:kermitp@...> 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: <mailto:smf_addin@yahoogroups.com > smf_addin@yahoogroups.com [
<mailto:smf_addin@yahoogroups.com > mailto:smf_addin@yahoogroups.com ] On
> Behalf Of waterboy5555
> Sent: Wednesday, July 24, 2013 1:51 PM
> To: <mailto:smf_addin@yahoogroups.com > 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 >
mailto:smf_addin@yahoogroups.com > <mailto:smf_addin@yahoogroups.com >
smf_addin@yahoogroups.com ,
> Randy Harmelink < < <mailto:rharmelink@> 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@>
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 >
mailto:smf_addin-fullfeatured@yahoogroups.com >
> <mailto:smf_addin-fullfeatured@yahoogroups.com >
smf_addin-fullfeatured@yahoogroups.com
>
------------------------------------
Yahoo! Groups Links
(Yahoo! ID required)
<mailto:smf_addin-fullfeatured@yahoogroups.com >
smf_addin-fullfeatured@yahoogroups.com
get the latest version. I just did after responding earlier
I now have this version:
Stock Market Functions add-in, Version 2.1.2013.06.
Make sure you copy the version you have installed now to another
subdirectory for insurance. I always keep several version as backup.
The folder I save the current version I name Replaced-07-
know the exact date I replaced it. Also, if something goes wrong it only
take a few minutes to swap the versions.
This may or may not fix your problem.
Is anything working with the SMF ADDin?
I'm really confused as to what it is you are trying to retrieve.
Is the data you are trying to retrieve from Morningstar FREE data or does it
require you to sign in first?
What is the actual URL of the page you are extracting the data from?
=RCHGetTableCell(
You should get 0.1897 or 18.97%
-----Original Message-----
From: smf_addin@yahoogrou
Of waterboy5555
Sent: Wednesday, July 24, 2013 2:18 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: Help Importing data from Morningstar to Excel
I get
Stock Market Functions add-in, Version 2.1.2012.12.
(C:\Users&#
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="
width="
<tbody>
<tr class="
<td>
<img src="..
width="
</td>
<td>
<img src="..
width="
</td>
<td>
<img src="..
width="
</td>
<td class="
<img src="..
width="
</td>
<td class="
<img src="..
width="
</td>
<td>
<img src="..
width="
</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 <mailto:smf_addin@yahoogrou
"Kermit W. Prather" < <mailto:kermitp@
>
> 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: <mailto:smf_addin@yahoogrou
<mailto:smf_addin@yahoogrou
> Behalf Of waterboy5555
> Sent: Wednesday, July 24, 2013 1:51 PM
> To: <mailto: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
> something pop up in the blank window? Because I just clicked run, but
there were no changes.
>
> --- In < <mailto:smf_addin@yahoogrou
mailto:smf_addin@yahoogrou
smf_addin@yahoogrou
> Randy Harmelink < < <mailto:rharmeli
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 smfForceRecalculati
> > 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@
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
mailto:smf_addin-fullfeatu
> <mailto:smf_addin-fullfeatu
smf_addin-fullfeatu
>
------------
Yahoo! Groups Links
(Yahoo! ID required)
<mailto:smf_addin-fullfeatu
smf_addin-fullfeatu
Wed Jul 24, 2013 11:57 am (PDT) . Posted by:
"waterboy5555" waterboy5555
Guys,
Thanks alot for you help! I just found my problem. It was because I did not login to Morningstar via Internet Explorer, but rather Chrome. Once I logged in to Morningstar via IE, Bingo! From there, I am able to retrieve the numbers in the table. Thanks!
--- In smf_addin@yahoogroups.com , "Kermit W. Prather" <kermitp@...> wrote:
>
> That's a fairy old version. You might want to go to the files section and
> get the latest version. I just did after responding earlier
>
> I now have this version:
>
> Stock Market Functions add-in, Version 2.1.2013.06.28 (C:\SMFADDIN; 1)
>
> Make sure you copy the version you have installed now to another
> subdirectory for insurance. I always keep several version as backup.
> The folder I save the current version I name Replaced-07-24-13 that way I
> know the exact date I replaced it. Also, if something goes wrong it only
> take a few minutes to swap the versions.
>
> This may or may not fix your problem.
>
> Is anything working with the SMF ADDin?
>
> I'm really confused as to what it is you are trying to retrieve.
>
> Is the data you are trying to retrieve from Morningstar FREE data or does it
> require you to sign in first?
>
> What is the actual URL of the page you are extracting the data from?
>
> =RCHGetTableCell("http://dividata.com/stock/AGNC ",1,"Dividend Yield:")
> You should get 0.1897 or 18.97%
>
>
>
> -----Original Message-----
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
> Of waterboy5555
> Sent: Wednesday, July 24, 2013 2:18 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: Help Importing data from Morningstar to Excel
>
> 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 <mailto:smf_addin@yahoogroups.com > smf_addin@yahoogroups.com ,
> "Kermit W. Prather" < <mailto:kermitp@> 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: <mailto:smf_addin@yahoogroups.com > smf_addin@yahoogroups.com [
> <mailto:smf_addin@yahoogroups.com > mailto:smf_addin@yahoogroups.com ] On
> > Behalf Of waterboy5555
> > Sent: Wednesday, July 24, 2013 1:51 PM
> > To: <mailto:smf_addin@yahoogroups.com > 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 >
> mailto:smf_addin@yahoogroups.com > <mailto:smf_addin@yahoogroups.com >
> smf_addin@yahoogroups.com ,
> > Randy Harmelink < < <mailto:rharmelink@> 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@>
> 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 >
> mailto:smf_addin-fullfeatured@yahoogroups.com >
> > <mailto:smf_addin-fullfeatured@yahoogroups.com >
> smf_addin-fullfeatured@yahoogroups.com
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
> (Yahoo! ID required)
>
> <mailto:smf_addin-fullfeatured@yahoogroups.com >
> smf_addin-fullfeatured@yahoogroups.com
>
Thanks alot for you help! I just found my problem. It was because I did not login to Morningstar via Internet Explorer, but rather Chrome. Once I logged in to Morningstar via IE, Bingo! From there, I am able to retrieve the numbers in the table. Thanks!
--- In smf_addin@yahoogrou
>
> That's a fairy old version. You might want to go to the files section and
> get the latest version. I just did after responding earlier
>
> I now have this version:
>
> Stock Market Functions add-in, Version 2.1.2013.06.
>
> Make sure you copy the version you have installed now to another
> subdirectory for insurance. I always keep several version as backup.
> The folder I save the current version I name Replaced-07-
> know the exact date I replaced it. Also, if something goes wrong it only
> take a few minutes to swap the versions.
>
> This may or may not fix your problem.
>
> Is anything working with the SMF ADDin?
>
> I'm really confused as to what it is you are trying to retrieve.
>
> Is the data you are trying to retrieve from Morningstar FREE data or does it
> require you to sign in first?
>
> What is the actual URL of the page you are extracting the data from?
>
> =RCHGetTableCell(
> You should get 0.1897 or 18.97%
>
>
>
> -----Original Message-----
> From: smf_addin@yahoogrou
> Of waterboy5555
> Sent: Wednesday, July 24, 2013 2:18 PM
> To: smf_addin@yahoogrou
> Subject: [smf_addin] Re: Help Importing data from Morningstar to Excel
>
> I get
>
> Stock Market Functions add-in, Version 2.1.2012.12.
> (C:\Users&#
>
> 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="
> width="
>
> <tbody>
> <tr class="
> <td>
> <img src="..
> width="
> </td>
> <td>
> <img src="..
> width="
> </td>
> <td>
> <img src="..
> width="
> </td>
> <td class="
> <img src="..
> width="
> </td>
> <td class="
> <img src="..
> width="
> </td>
> <td>
> <img src="..
> width="
> </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 <mailto:smf_addin@yahoogrou
> "Kermit W. Prather" < <mailto:kermitp@
> >
> > 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: <mailto:smf_addin@yahoogrou
> <mailto:smf_addin@yahoogrou
> > Behalf Of waterboy5555
> > Sent: Wednesday, July 24, 2013 1:51 PM
> > To: <mailto: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
> > something pop up in the blank window? Because I just clicked run, but
> there were no changes.
> >
> > --- In < <mailto:smf_addin@yahoogrou
> mailto:smf_addin@yahoogrou
> smf_addin@yahoogrou
> > Randy Harmelink < < <mailto:rharmeli
> 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 smfForceRecalculati
> > > 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@
> 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
> mailto:smf_addin-fullfeatu
> > <mailto:smf_addin-fullfeatu
> smf_addin-fullfeatu
> >
>
>
>
>
> ------------
>
> Yahoo! Groups Links
>
>
> (Yahoo! ID required)
>
> <mailto:smf_addin-fullfeatu
> smf_addin-fullfeatu
>
Wed Jul 24, 2013 12:01 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Actually, 2.1.2012.12.29 is the latest official release of the add-in.
The 2.1.2013.06.28 is a beta version, with some additional changes since
then.
On Wed, Jul 24, 2013 at 11:52 AM, Kermit W. Prather <kermitp@tampabay.rr.com
> wrote:
> That's a fairy old version. You might want to go to the files section
> and get the latest version. I just did after responding earlier****
>
> I now have this version:****
>
> Stock Market Functions add-in, Version 2.1.2013.06.28 (C:\SMFADDIN; 1)
>
The 2.1.2013.06.
then.
On Wed, Jul 24, 2013 at 11:52 AM, Kermit W. Prather <kermitp@tampabay.
> wrote:
> That's a fairy old version. You might want to go to the files section
> and get the latest version. I just did after responding earlier****
>
> I now have this version:****
>
> Stock Market Functions add-in, Version 2.1.2013.06.
>
Wed Jul 24, 2013 3:00 pm (PDT) . Posted by:
"waterboy5555" waterboy5555
Is there a way to put the web link in a cell on excel and have the formula read the link from the cell? I have:
=RCHGetTableCell(AF4,1,"Long%","Foreign Stocks")
where A4 is http://portfolio.morningstar.com/Rtport/Reg/XRayOverview.aspx?ViewPage=11&dt=851
But, with the formula I have with AF4, I get an error readout. I would like to be able to put the link in a cell so I would not have to go back and manually re enter the links.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Actually, 2.1.2012.12.29 is the latest official release of the add-in.
>
> The 2.1.2013.06.28 is a beta version, with some additional changes since
> then.
>
> On Wed, Jul 24, 2013 at 11:52 AM, Kermit W. Prather <kermitp@...
> > wrote:
>
> > That's a fairy old version. You might want to go to the files section
> > and get the latest version. I just did after responding earlier****
> >
> > I now have this version:****
> >
> > Stock Market Functions add-in, Version 2.1.2013.06.28 (C:\SMFADDIN; 1)
> >
>
=RCHGetTableCell(
where A4 is http://portfolio.
But, with the formula I have with AF4, I get an error readout. I would like to be able to put the link in a cell so I would not have to go back and manually re enter the links.
--- In smf_addin@yahoogrou
>
> Actually, 2.1.2012.12.
>
> The 2.1.2013.06.
> then.
>
> On Wed, Jul 24, 2013 at 11:52 AM, Kermit W. Prather <kermitp@
> > wrote:
>
> > That's a fairy old version. You might want to go to the files section
> > and get the latest version. I just did after responding earlier****
> >
> > I now have this version:****
> >
> > Stock Market Functions add-in, Version 2.1.2013.06.
> >
>
Wed Jul 24, 2013 5:08 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
If A4 has your URL, why are you referring to cell AF4?
Cell references as parameters are fine. Just as in normal EXCEL formulas.
On Wed, Jul 24, 2013 at 3:00 PM, waterboy5555 <bopha99@aol.com > wrote:
> Is there a way to put the web link in a cell on excel and have the formula
> read the link from the cell? I have:
>
> =RCHGetTableCell(AF4,1,"Long%","Foreign Stocks")
>
> where A4 is
> http://portfolio.morningstar.com/Rtport/Reg/XRayOverview.aspx?ViewPage=11&dt=851
>
> But, with the formula I have with AF4, I get an error readout. I would
> like to be able to put the link in a cell so I would not have to go back
> and manually re enter the links.
>
Cell references as parameters are fine. Just as in normal EXCEL formulas.
On Wed, Jul 24, 2013 at 3:00 PM, waterboy5555 <bopha99@aol.
> Is there a way to put the web link in a cell on excel and have the formula
> read the link from the cell? I have:
>
> =RCHGetTableCell(
>
> where A4 is
> http://portfolio.
>
> But, with the formula I have with AF4, I get an error readout. I would
> like to be able to put the link in a cell so I would not have to go back
> and manually re enter the links.
>
Wed Jul 24, 2013 4:56 pm (PDT) . Posted by:
"rob_gries" rob_gries
Dear all,
I have a workbook organized in different sheets, every sheet represents
a specific symbol.
I am having a problem with some symbols, in some cases the complete
period of historic data is retrieved and in some cases the recent past
is not retrieved and the values start from some weeks ago only. The
parameters though do not change from sheet to sheet.
What might be the reason for this?
Please see the images within the Photos section (I have created a
specific Album for this), that should illustrate the formulas I am using
and the wrong result they bring.
The symbol PETR4.SA brings the right values and the screenshot is taken
for LAME4.SA, which shows the wrong history.
What shall I take care of?
Thanks a lot for your ideas!
RG
Wed Jul 24, 2013 5:07 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It appears to me to be a Yahoo problem. When I set up a worksheet to
retrieve data for those two symbols 35 times, each of them had about 5
occurrences that were not the correct date. It could be that one of Yahoo's
servers isn't getting updated properly.
On Wed, Jul 24, 2013 at 3:43 PM, rob_gries <r.gries@tuhh.de > wrote:
>
> I have a workbook organized in different sheets, every sheet represents
> a specific symbol.
>
> I am having a problem with some symbols, in some cases the complete
> period of historic data is retrieved and in some cases the recent past
> is not retrieved and the values start from some weeks ago only. The
> parameters though do not change from sheet to sheet.
>
> What might be the reason for this?
>
> Please see the images within the Photos section (I have created a
> specific Album for this), that should illustrate the formulas I am using
> and the wrong result they bring.
>
> The symbol PETR4.SA brings the right values and the screenshot is taken
> for LAME4.SA, which shows the wrong history.
>
> What shall I take care of?
>
> Thanks a lot for your ideas!
>
retrieve data for those two symbols 35 times, each of them had about 5
occurrences that were not the correct date. It could be that one of Yahoo's
servers isn't getting updated properly.
On Wed, Jul 24, 2013 at 3:43 PM, rob_gries <r.gries@tuhh.
>
> I have a workbook organized in different sheets, every sheet represents
> a specific symbol.
>
> I am having a problem with some symbols, in some cases the complete
> period of historic data is retrieved and in some cases the recent past
> is not retrieved and the values start from some weeks ago only. The
> parameters though do not change from sheet to sheet.
>
> What might be the reason for this?
>
> Please see the images within the Photos section (I have created a
> specific Album for this), that should illustrate the formulas I am using
> and the wrong result they bring.
>
> The symbol PETR4.SA brings the right values and the screenshot is taken
> for LAME4.SA, which shows the wrong history.
>
> What shall I take care of?
>
> Thanks a lot for your ideas!
>
Wed Jul 24, 2013 5:46 pm (PDT) . Posted by:
"Abe" gurujapan
I am using YIELD =RCHGetElementNumber(A2, 63) to capture data from morningstar.com
This works fine with ticker symbols HPQ, KO on the NYSE.
I tried with Indian stocks like WIPRO (morningstar.com uses XNSE:WIPRO as the ticker symbol on its site to refer to National Stock Exchange) but this doesn't seem to work.
SYMBOL YIELD
INFY 18.34
KO 8.45 THESE 3 NYSE TICKER SYMBOLS WORK FINE
HPQ 9.51
SYMBOL YIELD
XNSE.WIPRO Error
XNSE:WIPRO Error WHAT FORMAT OF TICKER SYMBOL SHOULD I USE?
507685 Error
XBOM:507685 Error
(NOTE: XBOM refers to BOMBAY STOCK EXCHANGE; XNSE TO INDIA NATIONAL STOCK EXCHANGE)
I am using EXCEL 2007 running under WINDOWS 2007.
The URLs for WIPRO in Morningstar:
http://quote.morningstar.com/TickerLookupResult.html?ticker=WIPRO&pageno=0&TLC=M
http://quotes.morningstar.com/stock/wipro/s?t=XNSE%3aWIPRO
Grateful for any advice/tips.
Thanks in advance,
Gururaj Rao
This works fine with ticker symbols HPQ, KO on the NYSE.
I tried with Indian stocks like WIPRO (morningstar.
SYMBOL YIELD
INFY 18.34
KO 8.45 THESE 3 NYSE TICKER SYMBOLS WORK FINE
HPQ 9.51
SYMBOL YIELD
XNSE.WIPRO Error
XNSE:WIPRO Error WHAT FORMAT OF TICKER SYMBOL SHOULD I USE?
507685 Error
XBOM:507685 Error
(NOTE: XBOM refers to BOMBAY STOCK EXCHANGE; XNSE TO INDIA NATIONAL STOCK EXCHANGE)
I am using EXCEL 2007 running under WINDOWS 2007.
The URLs for WIPRO in Morningstar:
http://quote.
http://quotes.
Grateful for any advice/tips.
Thanks in advance,
Gururaj Rao
Wed Jul 24, 2013 6:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Actually, element #63 is from MSN, not MorningStar. On the MSN company name
lookup, I don't see an option for a country of India. So I don't know if
they carry data on them.
You can get the yield from Morningstar with:
=smfConvertData(smfGetTagContent("
http://quotes.morningstar.com/stock/c-header?&t=XNSE:WIPRO ",
"span",0,"vkey=""ProjectedYield"""))
On Wed, Jul 24, 2013 at 5:38 PM, Abe <honyakusha@gmail.com > wrote:
> I am using YIELD =RCHGetElementNumber(A2, 63) to capture data from
> morningstar.com
> This works fine with ticker symbols HPQ, KO on the NYSE.
>
> I tried with Indian stocks like WIPRO (morningstar.com uses XNSE:WIPRO as
> the ticker symbol on its site to refer to National Stock Exchange) but this
> doesn't seem to work.
>
> SYMBOL YIELD
> INFY 18.34
> KO 8.45 THESE 3 NYSE TICKER SYMBOLS WORK FINE
> HPQ 9.51
>
>
> SYMBOL YIELD
> XNSE.WIPRO Error
> XNSE:WIPRO Error WHAT FORMAT OF TICKER SYMBOL SHOULD I USE?
> 507685 Error
> XBOM:507685 Error
>
> (NOTE: XBOM refers to BOMBAY STOCK EXCHANGE; XNSE TO INDIA NATIONAL STOCK
> EXCHANGE)
>
> I am using EXCEL 2007 running under WINDOWS 2007.
> The URLs for WIPRO in Morningstar:
>
>
> http://quote.morningstar.com/TickerLookupResult.html?ticker=WIPRO&pageno=0&TLC=M
>
> http://quotes.morningstar.com/stock/wipro/s?t=XNSE%3aWIPRO
>
> Grateful for any advice/tips.
>
lookup, I don't see an option for a country of India. So I don't know if
they carry data on them.
You can get the yield from Morningstar with:
=smfConvertData(
http://quotes.
"span"
On Wed, Jul 24, 2013 at 5:38 PM, Abe <honyakusha@gmail.
> I am using YIELD =RCHGetElementNumbe
> morningstar.
> This works fine with ticker symbols HPQ, KO on the NYSE.
>
> I tried with Indian stocks like WIPRO (morningstar.
> the ticker symbol on its site to refer to National Stock Exchange) but this
> doesn't seem to work.
>
> SYMBOL YIELD
> INFY 18.34
> KO 8.45 THESE 3 NYSE TICKER SYMBOLS WORK FINE
> HPQ 9.51
>
>
> SYMBOL YIELD
> XNSE.WIPRO Error
> XNSE:WIPRO Error WHAT FORMAT OF TICKER SYMBOL SHOULD I USE?
> 507685 Error
> XBOM:507685 Error
>
> (NOTE: XBOM refers to BOMBAY STOCK EXCHANGE; XNSE TO INDIA NATIONAL STOCK
> EXCHANGE)
>
> I am using EXCEL 2007 running under WINDOWS 2007.
> The URLs for WIPRO in Morningstar:
>
>
> http://quote.
>
> http://quotes.
>
> Grateful for any advice/tips.
>
Tidak ada komentar:
Posting Komentar