15 New Messages
Digest #2370
1a
Re: problem with RCHGetHTMLTable for reuters.com and market.ft.com by "Randy Harmelink" rharmelink
Messages
Wed Oct 10, 2012 7:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's probably because the website has some type of redirection upon your
first visit of the day. So a cookie needs to be updated to indicate that
visit has been completed -- that requires a visit to the website with the
IE object so the cookie can be updated. You probably replace the query with
a manual visit to the website.
On Wed, Oct 10, 2012 at 2:41 AM, p²n <dlx_0lb@yahoo.com > wrote:
> everything works fine after adding QueryTables Connection to the target
> web page. Thx Randy
>
first visit of the day. So a cookie needs to be updated to indicate that
visit has been completed -- that requires a visit to the website with the
IE object so the cookie can be updated. You probably replace the query with
a manual visit to the website.
On Wed, Oct 10, 2012 at 2:41 AM, p²n <dlx_0lb@yahoo.
> everything works fine after adding QueryTables Connection to the target
> web page. Thx Randy
>
Wed Oct 10, 2012 7:57 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
See the "Location errors" item in the LINKS area of the group -- this is an
EXCEL issue when workbooks get shared.
On Wed, Oct 10, 2012 at 7:26 AM, Chris Ball <crball02@gmail.com > wrote:
>
> Ok I downloaded the new element definition the Add-In seemed to be running
> correctly, but now excel keeps asking me to edit links and the Add-In wont
> run. Any ideas?
>
EXCEL issue when workbooks get shared.
On Wed, Oct 10, 2012 at 7:26 AM, Chris Ball <crball02@gmail.
>
> Ok I downloaded the new element definition the Add-In seemed to be running
> correctly, but now excel keeps asking me to edit links and the Add-In wont
> run. Any ideas?
>
Wed Oct 10, 2012 9:01 am (PDT) . Posted by:
"Chris Ball" peggysue281
So I tried doing the find and replace ='C:\Program Files\SMF Add
In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber(Ticker,25) and
replacing the ='C:\Program Files\SMF Add
In\RCH_Stock_Market_Functions.xla'! with nothing so that it is just
=RCHGetElementNumber(Ticker,25). When I do that and then try to run the
model I still recieve the same errors as before for the formulas I was
having issues with before I downloaded the new element definition.
On Wed, Oct 10, 2012 at 9:57 AM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> See the "Location errors" item in the LINKS area of the group -- this is
> an EXCEL issue when workbooks get shared.
>
>
> On Wed, Oct 10, 2012 at 7:26 AM, Chris Ball <crball02@gmail.com > wrote:
>
>>
>> Ok I downloaded the new element definition the Add-In seemed to be
>> running correctly, but now excel keeps asking me to edit links and the
>> Add-In wont run. Any ideas?
>>
>
>
>
--
Thanks,
Chris Ball
In\RCH_Stock_
replacing the ='C:\Program Files\SMF Add
In\RCH_Stock_
=RCHGetElementNumbe
model I still recieve the same errors as before for the formulas I was
having issues with before I downloaded the new element definition.
On Wed, Oct 10, 2012 at 9:57 AM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> See the "Location errors" item in the LINKS area of the group -- this is
> an EXCEL issue when workbooks get shared.
>
>
> On Wed, Oct 10, 2012 at 7:26 AM, Chris Ball <crball02@gmail.
>
>>
>> Ok I downloaded the new element definition the Add-In seemed to be
>> running correctly, but now excel keeps asking me to edit links and the
>> Add-In wont run. Any ideas?
>>
>
>
>
--
Thanks,
Chris Ball
Wed Oct 10, 2012 9:23 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Exit and restart EXCEL, and tell me what you get with these formulas in a
new workbook:
=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM",25)
=smfGetAParms(25)
By the way, element #25 hasn't been populated correctly by MSN since they
changed their web pages back in April. I would recommend the
RCHGetYahooQuotes() function to get current quotes data.
On Wed, Oct 10, 2012 at 9:01 AM, Chris Ball <crball02@gmail.com > wrote:
>
> So I tried doing the find and replace ='C:\Program Files\SMF Add
> In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber(Ticker,25) and
> replacing the ='C:\Program Files\SMF Add
> In\RCH_Stock_Market_Functions.xla'! with nothing so that it is just
> =RCHGetElementNumber(Ticker,25). When I do that and then try to run the
> model I still recieve the same errors as before for the formulas I was
> having issues with before I downloaded the new element definition.
>
new workbook:
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfGetAParms(
By the way, element #25 hasn't been populated correctly by MSN since they
changed their web pages back in April. I would recommend the
RCHGetYahooQuotes(
On Wed, Oct 10, 2012 at 9:01 AM, Chris Ball <crball02@gmail.
>
> So I tried doing the find and replace ='C:\Program Files\SMF Add
> In\RCH_Stock_
> replacing the ='C:\Program Files\SMF Add
> In\RCH_Stock_
> =RCHGetElementNumbe
> model I still recieve the same errors as before for the formulas I was
> having issues with before I downloaded the new element definition.
>
Wed Oct 10, 2012 9:44 am (PDT) . Posted by:
"Chris Ball" peggysue281
This is what I get when i rerun a workbook with those formulas.
Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program Files\SMF
Add-In; 1)
Error MSN;Last Price;
http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCKACTIVITY;LAST
PRICE; ; ;0;0;0;0
I have windows 7 home premium and office 2010 if that helps as well.
On Wed, Oct 10, 2012 at 11:23 AM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> Exit and restart EXCEL, and tell me what you get with these formulas in a
> new workbook:
>
> =RCHGetElementNumber("Version")
> =RCHGetElementNumber("MMM",25)
> =smfGetAParms(25)
>
> By the way, element #25 hasn't been populated correctly by MSN since they
> changed their web pages back in April. I would recommend the
> RCHGetYahooQuotes() function to get current quotes data.
>
>
> On Wed, Oct 10, 2012 at 9:01 AM, Chris Ball <crball02@gmail.com > wrote:
>
>>
>> So I tried doing the find and replace ='C:\Program Files\SMF Add
>> In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber(Ticker,25) and
>> replacing the ='C:\Program Files\SMF Add
>> In\RCH_Stock_Market_Functions.xla'! with nothing so that it is just
>> =RCHGetElementNumber(Ticker,25). When I do that and then try to run the
>> model I still recieve the same errors as before for the formulas I was
>> having issues with before I downloaded the new element definition.
>>
>
>
>
--
Thanks,
Chris Ball
Stock Market Functions add-in, Version 2.1.2012.04.
Add-In; 1)
Error MSN;Last Price;
http://moneycentral
PRICE; ; ;0;0;0;0
I have windows 7 home premium and office 2010 if that helps as well.
On Wed, Oct 10, 2012 at 11:23 AM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> Exit and restart EXCEL, and tell me what you get with these formulas in a
> new workbook:
>
> =RCHGetElementNumbe
> =RCHGetElementNumbe
> =smfGetAParms(
>
> By the way, element #25 hasn't been populated correctly by MSN since they
> changed their web pages back in April. I would recommend the
> RCHGetYahooQuotes(
>
>
> On Wed, Oct 10, 2012 at 9:01 AM, Chris Ball <crball02@gmail.
>
>>
>> So I tried doing the find and replace ='C:\Program Files\SMF Add
>> In\RCH_Stock_
>> replacing the ='C:\Program Files\SMF Add
>> In\RCH_Stock_
>> =RCHGetElementNumbe
>> model I still recieve the same errors as before for the formulas I was
>> having issues with before I downloaded the new element definition.
>>
>
>
>
--
Thanks,
Chris Ball
Wed Oct 10, 2012 10:28 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Element #25 won't work because you still have the old element definition...
On Wed, Oct 10, 2012 at 9:44 AM, Chris Ball <crball02@gmail.com > wrote:
>
> This is what I get when i rerun a workbook with those formulas.
>
> Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program
> Files\SMF Add-In; 1)
> Error MSN;Last Price;
> http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCKACTIVITY;LAST PRICE; ; ;0;0;0;0
> I have windows 7 home premium and office 2010 if that helps as well.
>
On Wed, Oct 10, 2012 at 9:44 AM, Chris Ball <crball02@gmail.
>
> This is what I get when i rerun a workbook with those formulas.
>
> Stock Market Functions add-in, Version 2.1.2012.04.
> Files\SMF Add-In; 1)
> Error MSN;Last Price;
> http://moneycentral
> I have windows 7 home premium and office 2010 if that helps as well.
>
Wed Oct 10, 2012 8:44 am (PDT) . Posted by:
"David" copthornelabs
Randy,
Stock Price Sector Industry
ABX 0 Barrick Gold Corp $40.80 Basic Materials Gold
Would you kindly show me how to add a column to the right of the above that will get me a quick pop-up chart (maybe through rch createcomment fn) for a list of symbols in col A. Plz reccommend the easiest place to go (Yahoo,Zacks,MSN?).
Thanks
Dave C.
Stock Price Sector Industry
ABX 0 Barrick Gold Corp $40.80 Basic Materials Gold
Would you kindly show me how to add a column to the right of the above that will get me a quick pop-up chart (maybe through rch createcomment fn) for a list of symbols in col A. Plz reccommend the easiest place to go (Yahoo,Zacks,
Thanks
Dave C.
Wed Oct 10, 2012 8:48 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=RCHCreateComment(A1,1)
On Wed, Oct 10, 2012 at 8:44 AM, David <davecharlaff@hotmail.com > wrote:
> Randy,
>
> Stock Price Sector Industry
>
> ABX 0 Barrick Gold Corp $40.80 Basic Materials Gold
>
> Would you kindly show me how to add a column to the right of the above
> that will get me a quick pop-up chart (maybe through rch createcomment fn)
> for a list of symbols in col A. Plz reccommend the easiest place to go
> (Yahoo,Zacks,MSN?).
>
=RCHCreateComment(
On Wed, Oct 10, 2012 at 8:44 AM, David <davecharlaff@
> Randy,
>
> Stock Price Sector Industry
>
> ABX 0 Barrick Gold Corp $40.80 Basic Materials Gold
>
> Would you kindly show me how to add a column to the right of the above
> that will get me a quick pop-up chart (maybe through rch createcomment fn)
> for a list of symbols in col A. Plz reccommend the easiest place to go
> (Yahoo,Zacks,
>
Wed Oct 10, 2012 8:46 am (PDT) . Posted by:
"simona4051" simona4051
HI
I am new to this group and I was actually looking for a stockscreener with backtesting capabilities and excel export functionality. Do you actually know of such screener, could somebody help me with this?
many thanks and kind regards,
Simona
I am new to this group and I was actually looking for a stockscreener with backtesting capabilities and excel export functionality. Do you actually know of such screener, could somebody help me with this?
many thanks and kind regards,
Simona
Wed Oct 10, 2012 8:49 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I use StockScreen123.com
On Wed, Oct 10, 2012 at 8:32 AM, simona4051 <simona4051@yahoo.com > wrote:
> I am new to this group and I was actually looking for a stockscreener with
> backtesting capabilities and excel export functionality. Do you actually
> know of such screener, could somebody help me with this?
>
On Wed, Oct 10, 2012 at 8:32 AM, simona4051 <simona4051@yahoo.
> I am new to this group and I was actually looking for a stockscreener with
> backtesting capabilities and excel export functionality. Do you actually
> know of such screener, could somebody help me with this?
>
Wed Oct 10, 2012 10:23 am (PDT) . Posted by:
"Jacob Jose" pepecan47
I am trying to get the "p/e 5years average" from M*. Element 13946 give me "obsolete" as a value.
Is there any way I can get the p/e 5y avg?
Why other values like p/e ttm are ok eventhough they are in the same page?
Thx a lot.
Regards,
Jose L. Jacob
Is there any way I can get the p/e 5y avg?
Why other values like p/e ttm are ok eventhough they are in the same page?
Thx a lot.
Regards,
Jose L. Jacob
Wed Oct 10, 2012 10:33 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Probably because the 5-year average is on a dynamically generated web page
and the P/E ttm is coming from a different web page...
I don't know what element and web page you're looking at, so can't speak to
specifics.
On Wed, Oct 10, 2012 at 10:22 AM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
> I am trying to get the "p/e 5years average" from M*. Element 13946 give me
> "obsolete" as a value.
> Is there any way I can get the p/e 5y avg?
> Why other values like p/e ttm are ok eventhough they are in the same page?
>
>
and the P/E ttm is coming from a different web page...
I don't know what element and web page you're looking at, so can't speak to
specifics.
On Wed, Oct 10, 2012 at 10:22 AM, Jacob Jose <pepecan47@yahoo.
>
> I am trying to get the "p/e 5years average" from M*. Element 13946 give me
> "obsolete" as a value.
> Is there any way I can get the p/e 5y avg?
> Why other values like p/e ttm are ok eventhough they are in the same page?
>
>
Wed Oct 10, 2012 11:14 am (PDT) . Posted by:
"Jacob Jose" pepecan47
This is the page I am looking at :
http://financials.morningstar.com/valuation/price-ratio.html?t=MCD®ion=USA&culture=en-US
Element 13971 (TTM p/e) works.
Element 13946 (5y avg p/e) gives "obsolete".
Both are in the same above web page.
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Wednesday, October 10, 2012 1:33:36 PM
Subject: Re: [smf_addin] MorningStar p/e values
Probably because the 5-year average is on a dynamically generated web page and the P/E ttm is coming from a different web page...
I don't know what element and web page you're looking at, so can't speak to specifics.
On Wed, Oct 10, 2012 at 10:22 AM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
>I am trying to get the "p/e 5years average" from M*. Element 13946 give me "obsolete" as a value.
>Is there any way I can get the p/e 5y avg?
>Why other values like p/e ttm are ok eventhough they are in the same page?
http://financials.
Element 13971 (TTM p/e) works.
Element 13946 (5y avg p/e) gives "obsolete".
Both are in the same above web page.
Regards,
Jose L. Jacob
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Wednesday, October 10, 2012 1:33:36 PM
Subject: Re: [smf_addin] MorningStar p/e values
Probably because the 5-year average is on a dynamically generated web page and the P/E ttm is coming from a different web page...
I don't know what element and web page you're looking at, so can't speak to specifics.
On Wed, Oct 10, 2012 at 10:22 AM, Jacob Jose <pepecan47@yahoo.
>
>I am trying to get the "p/e 5years average" from M*. Element 13946 give me "obsolete" as a value.
>Is there any way I can get the p/e 5y avg?
>Why other values like p/e ttm are ok eventhough they are in the same page?
Wed Oct 10, 2012 11:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The web page you cite has data placed on it dynamically, so the add-in
can't extract data from it.
Element #13971 comes from this web page:
http://quicktake.morningstar.com/stocknet/Valuation10.aspx?Symbol=MCD
You could compute your own 5-year average from the data there.
On Wed, Oct 10, 2012 at 11:13 AM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
> This is the page I am looking at :
>
> http://financials.morningstar.com/valuation/price-ratio.html?t=MCD®ion=USA&culture=en-US
>
> Element 13971 (TTM p/e) works.
> Element 13946 (5y avg p/e) gives "obsolete".
> Both are in the same above web page.
>
can't extract data from it.
Element #13971 comes from this web page:
http://quicktake.
You could compute your own 5-year average from the data there.
On Wed, Oct 10, 2012 at 11:13 AM, Jacob Jose <pepecan47@yahoo.
>
> This is the page I am looking at :
>
> http://financials.
>
> Element 13971 (TTM p/e) works.
> Element 13946 (5y avg p/e) gives "obsolete".
> Both are in the same above web page.
>
Wed Oct 10, 2012 11:50 am (PDT) . Posted by:
"Ray Hitt" urracaplace
Thanks for the reply. It motivated me to do some research. Google does historical price quotes for individual stocks, but not for mutual funds. As far as I can tell, there's no easy way to get historical information on dividends and splits, even though if you look at the summary page's, all that information is there.
What I didn't know was Google was shutting down it's financial API entirely as of 10/20. The only useful functionality will be limited to Google Docs. According to Google, their data providers requested that they limit functionality to end-users.
I'm not sure what you mean by "the cleanest". What I want is accurate data. Currently, data is missing from the Yahoo! database. If that's not bad enough, various parameters calculated from that data such as rate of return measures as reported on Yahoo!'s web site are just wrong.
What I didn't know was Google was shutting down it's financial API entirely as of 10/20. The only useful functionality will be limited to Google Docs. According to Google, their data providers requested that they limit functionality to end-users.
I'm not sure what you mean by "the cleanest". What I want is accurate data. Currently, data is missing from the Yahoo! database. If that's not bad enough, various parameters calculated from that data such as rate of return measures as reported on Yahoo!'s web site are just wrong.
Tidak ada komentar:
Posting Komentar