15 New Messages
Digest #2500
4a
Re: Any Excel macro file available for downloading all the real-time by "Randy Harmelink" rharmelink
Messages
Thu Feb 7, 2013 10:56 am (PST) . Posted by:
"mwalkup55" mwalkup55
Hi all,
I have a list of stocks that and I would like to retrieve their address, ideally their zip code. I have tried using this function for Morningstar:
=RCHGetTableCell("http://financials.morningstar.com/company-profile/c.action?t= "&$B2&"®ion=USA&culture=en-us",1,"Address")
Where B2 is the Ticker FCTY, and I get an error message. Any ideas for a solution or for an alternative?
Thanks!
Matt
I have a list of stocks that and I would like to retrieve their address, ideally their zip code. I have tried using this function for Morningstar:
=RCHGetTableCell(
Where B2 is the Ticker FCTY, and I get an error message. Any ideas for a solution or for an alternative?
Thanks!
Matt
Thu Feb 7, 2013 11:23 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, that web page is dynamically generated by MorningStar, so
there's no data in the source code of the web page for the add-in to
extract.
However, the JavaScript of that web page retrieves the contact information
from here:
http://financials.morningstar.com/company-profile/component.action?component=ContactInfo&t=FCTY®ion=usa&culture=en-US
So, try:
=RCHGetTableCell("
http://financials.morningstar.com/company-profile/component.action?component=ContactInfo&t=
"&$B2&"®ion=USA&culture=en-us",1,"Address")
On Thu, Feb 7, 2013 at 11:33 AM, mwalkup55 mwalkup55@yahoo.com > wrote:
>
> I have a list of stocks that and I would like to retrieve their address,
> ideally their zip code. I have tried using this function for Morningstar:
>
> =RCHGetTableCell("
> http://financials.morningstar.com/company-profile/c.action?t=
> "&$B2&"®ion=USA&culture=en-us",1,"Address")
>
> Where B2 is the Ticker FCTY, and I get an error message. Any ideas for a
> solution or for an alternative?
>
there's no data in the source code of the web page for the add-in to
extract.
However, the JavaScript of that web page retrieves the contact information
from here:
http://financials.
So, try:
=RCHGetTableCell(
http://financials.
"&$B2&"
On Thu, Feb 7, 2013 at 11:33 AM, mwalkup55 mwalkup55@yahoo.
>
> I have a list of stocks that and I would like to retrieve their address,
> ideally their zip code. I have tried using this function for Morningstar:
>
> =RCHGetTableCell(
> http://financials.
> "&$B2&"
>
> Where B2 is the Ticker FCTY, and I get an error message. Any ideas for a
> solution or for an alternative?
>
Thu Feb 7, 2013 10:57 am (PST) . Posted by:
"webz1984" webz1984
Hi,
I ran the following functions
=rchgetelementnumber("Version")
=rchgetelementnumber("MMM";,7)
=smfGetAParms(7)
=rchgetelementnumber("MMM";,989)
=smfGetAParms(989)
The results are
Stock Market Functions add-in, Version 2.1.2013.02.06 (C:\Program Files\SMF Add-in; 1)
Error
MSN;% Institutional Ownership;http://investing.money.msn.com/investments/stock-report?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;OWNERSHIP INFORMATION;INSTITUTIONAL OWNERSHIP; ; ;0;0;0;0
Error
YahooKS;Dividend;http://finance.yahoo.com/q/ks?s=~~~~~;2;FINANCIAL HIGHLIGHTS;FORWARD ANNUAL DIVIDEND RATE; ; ;2;
I ran the following functions
=rchgetelementnumbe
=rchgetelementnumbe
=smfGetAParms(
=rchgetelementnumbe
=smfGetAParms(
The results are
Stock Market Functions add-in, Version 2.1.2013.02.
Error
MSN;% Institutional Ownership;http://investing.
Error
YahooKS;Dividend;http://finance.
Thu Feb 7, 2013 11:01 am (PST) . Posted by:
"webz1984" webz1984
The message got truncated, here is the second part:
> As you can see, it always returns error when it should return a number.
>
> I am using office 2010 under Window 7. Tried other stocks as well such as "GOOG","IBM", none of them is working (all return "error"). Have worked on this for days now and it's really frustrating.Really appreciate any suggestions.
>
> Regards,
>
> Wz
>
--- In smf_addin@yahoogroups.com , "webz1984"; wrote:
>
> Hi,
>
> I ran the following functions
>
> =rchgetelementnumber("Version")
> =rchgetelementnumber("MMM";,7)
> =smfGetAParms(7)
> =rchgetelementnumber("MMM";,989)
> =smfGetAParms(989)
>
> The results are
>
> Stock Market Functions add-in, Version 2.1.2013.02.06 (C:\Program Files\SMF Add-in; 1)
> Error
> MSN;% Institutional Ownership;http://investing.money.msn.com/investments/stock-report?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;OWNERSHIP INFORMATION;INSTITUTIONAL OWNERSHIP; ; ;0;0;0;0
> Error
> YahooKS;Dividend;http://finance.yahoo.com/q/ks?s=~~~~~;2;FINANCIAL HIGHLIGHTS;FORWARD ANNUAL DIVIDEND RATE; ; ;2;
> As you can see, it always returns error when it should return a number.
>
> I am using office 2010 under Window 7. Tried other stocks as well such as "GOOG","IBM", none of them is working. Have worked on this for days now, and it's really frustrating.Really appreciate any suggestions.
>
> Regards,
>
> Wz
>
> As you can see, it always returns error when it should return a number.
>
> I am using office 2010 under Window 7. Tried other stocks as well such as "GOOG"
>
> Regards,
>
> Wz
>
--- In smf_addin@yahoogrou
>
> Hi,
>
> I ran the following functions
>
> =rchgetelementnumbe
> =rchgetelementnumbe
> =smfGetAParms(
> =rchgetelementnumbe
> =smfGetAParms(
>
> The results are
>
> Stock Market Functions add-in, Version 2.1.2013.02.
> Error
> MSN;% Institutional Ownership;http://investing.
> Error
> YahooKS;Dividend;http://finance.
> As you can see, it always returns error when it should return a number.
>
> I am using office 2010 under Window 7. Tried other stocks as well such as "GOOG"
>
> Regards,
>
> Wz
>
Thu Feb 7, 2013 11:26 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You're using an older version of the add-in, which has outdated element
definitions for MSN. MSN changed their website structure last year, and all
of their elements had to be redefined.
On Thu, Feb 7, 2013 at 11:28 AM, webz1984 bozi1984@gmail.com > wrote:
> Hi,
>
> I ran the following functions
>
> =rchgetelementnumber("Version")
> =rchgetelementnumber("MMM";,7)
> =smfGetAParms(7)
> =rchgetelementnumber("MMM";,989)
> =smfGetAParms(989)
>
> The results are
>
> Stock Market Functions add-in, Version 2.1.2013.02.06 (C:\Program
> Files\SMF Add-in; 1)
> Error
> MSN;% Institutional Ownership;
> http://investing.money.msn.com/investments/stock-report?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;OWNERSHIPINFORMATION;INSTITUTIONAL OWNERSHIP; ; ;0;0;0;0
> Error
> YahooKS;Dividend;http://finance.yahoo.com/q/ks?s=~~~~~;2;FINANCIALHIGHLIGHTS;FORWARD ANNUAL DIVIDEND RATE; ; ;2;
> As you can see, it always returns error when it should return a number.
>
> I am using office 2010 under Window 7. Tried other stocks as well such as
> "GOOG","IBM", none of them is working. Have worked on this for days now,
> and it's really frustrating.Really appreciate any suggestions.
>
definitions for MSN. MSN changed their website structure last year, and all
of their elements had to be redefined.
On Thu, Feb 7, 2013 at 11:28 AM, webz1984 bozi1984@gmail.
> Hi,
>
> I ran the following functions
>
> =rchgetelementnumbe
> =rchgetelementnumbe
> =smfGetAParms(
> =rchgetelementnumbe
> =smfGetAParms(
>
> The results are
>
> Stock Market Functions add-in, Version 2.1.2013.02.
> Files\SMF Add-in; 1)
> Error
> MSN;% Institutional Ownership;
> http://investing.
> Error
> YahooKS;Dividend;http://finance.
> As you can see, it always returns error when it should return a number.
>
> I am using office 2010 under Window 7. Tried other stocks as well such as
> "GOOG"
> and it's really frustrating.
>
Thu Feb 7, 2013 11:36 am (PST) . Posted by:
"webz1984" webz1984
Thanks Randy,
Is there a separate file for MSN? Because I downloaded the most updated version of the add-in file from Files -> Work-in-process (version 2.1.2013.02.
Regards,
Wz
--- In smf_addin@yahoogrou
>
> You're using an older version of the add-in, which has outdated element
> definitions for MSN. MSN changed their website structure last year, and all
> of their elements had to be redefined.
>
> On Thu, Feb 7, 2013 at 11:28 AM, webz1984 wrote:
>
> > Hi,
> >
> > I ran the following functions
> >
> > =rchgetelementnumbe
> > =rchgetelementnumbe
> > =smfGetAParms(
> > =rchgetelementnumbe
> > =smfGetAParms(
> >
> > The results are
> >
> > Stock Market Functions add-in, Version 2.1.2013.02.
> > Files\SMF Add-in; 1)
> > Error
> > MSN;% Institutional Ownership;
> > http://investing.
> > Error
> > YahooKS;Dividend;http://finance.
>
> > As you can see, it always returns error when it should return a number.
> >
> > I am using office 2010 under Window 7. Tried other stocks as well such as
> > "GOOG"
> > and it's really frustrating.
> >
>
Thu Feb 7, 2013 11:47 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Oops, sorry. For some reason, I saw 2012 in the version number instead of
2013. Yes, you are using the most recent beta version of the add-in.
Do you have some type of firewall that is preventing EXCEL from accessing
the Internet? Can you do an EXCEL Web Query?
What do you get for these functions:
=RCHGetTableCell("http://finance.yahoo.com/q/ks?s=MMM ",1,"Financial
Highlights","Forward Annual Dividend Rate")
=RCHGetWebData("http://finance.yahoo.com/q/ks?s=MMM ",1,10)
On Thu, Feb 7, 2013 at 12:36 PM, webz1984 bozi1984@gmail.com > wrote:
>
> Thanks Randy,
>
> Is there a separate file for MSN? Because I downloaded the most updated
> version of the add-in file from Files -> Work-in-process (version
> 2.1.2013.02.06).Can you provide a link for the up-to-date add-in?
>
> Regards,
>
> Wz
> --- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
> >
> > You're using an older version of the add-in, which has outdated element
> > definitions for MSN. MSN changed their website structure last year, and
> all
> > of their elements had to be redefined.
> >
> > On Thu, Feb 7, 2013 at 11:28 AM, webz1984 wrote:
> >
> > > Hi,
> > >
> > > I ran the following functions
> > >
> > > =rchgetelementnumber("Version")
> > > =rchgetelementnumber("MMM";,7)
> > > =smfGetAParms(7)
> > > =rchgetelementnumber("MMM";,989)
> > > =smfGetAParms(989)
> > >
> > > The results are
> > >
> > > Stock Market Functions add-in, Version 2.1.2013.02.06 (C:\Program
> > > Files\SMF Add-in; 1)
> > > Error
> > > MSN;% Institutional Ownership;
> > >
> http://investing.money.msn.com/investments/stock-report?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;OWNERSHIPINFORMATION;INSTITUTIONALOWNERSHIP; ; ;0;0;0;0
> > > Error
> > > YahooKS;Dividend;
> http://finance.yahoo.com/q/ks?s=~~~~~;2;FINANCIALHIGHLIGHTS;FORWARDANNUAL DIVIDEND RATE; ; ;2;
> >
> > > As you can see, it always returns error when it should return a number.
> > >
> > > I am using office 2010 under Window 7. Tried other stocks as well such
> as
> > > "GOOG","IBM", none of them is working. Have worked on this for days
> now,
> > > and it's really frustrating.Really appreciate any suggestions.
>
2013. Yes, you are using the most recent beta version of the add-in.
Do you have some type of firewall that is preventing EXCEL from accessing
the Internet? Can you do an EXCEL Web Query?
What do you get for these functions:
=RCHGetTableCell(
Highlights"
=RCHGetWebData(
On Thu, Feb 7, 2013 at 12:36 PM, webz1984 bozi1984@gmail.
>
> Thanks Randy,
>
> Is there a separate file for MSN? Because I downloaded the most updated
> version of the add-in file from Files -> Work-in-process (version
> 2.1.2013.02.
>
> Regards,
>
> Wz
> --- In smf_addin@yahoogrou
> >
> > You're using an older version of the add-in, which has outdated element
> > definitions for MSN. MSN changed their website structure last year, and
> all
> > of their elements had to be redefined.
> >
> > On Thu, Feb 7, 2013 at 11:28 AM, webz1984 wrote:
> >
> > > Hi,
> > >
> > > I ran the following functions
> > >
> > > =rchgetelementnumbe
> > > =rchgetelementnumbe
> > > =smfGetAParms(
> > > =rchgetelementnumbe
> > > =smfGetAParms(
> > >
> > > The results are
> > >
> > > Stock Market Functions add-in, Version 2.1.2013.02.
> > > Files\SMF Add-in; 1)
> > > Error
> > > MSN;% Institutional Ownership;
> > >
> http://investing.
> > > Error
> > > YahooKS;Dividend;
> http://finance.
> >
> > > As you can see, it always returns error when it should return a number.
> > >
> > > I am using office 2010 under Window 7. Tried other stocks as well such
> as
> > > "GOOG"
> now,
> > > and it's really frustrating.
>
Thu Feb 7, 2013 1:19 pm (PST) . Posted by:
"webz1984" webz1984
Hi Randy,
No worries, here are what I got,
smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Oops, sorry. For some reason, I saw 2012 in the version number instead of
> 2013. Yes, you are using the most recent beta version of the add-in.
>
> Do you have some type of firewall that is preventing EXCEL from accessing
> the Internet? Can you do an EXCEL Web Query?
>
> What do you get for these functions:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/ks?s=MMM ",1,"Financial
> Highlights","Forward Annual Dividend Rate")
> =RCHGetWebData("http://finance.yahoo.com/q/ks?s=MMM ",1,10)
>
> On Thu, Feb 7, 2013 at 12:36 PM, webz1984 wrote:
>
> >
> > Thanks Randy,
> >
> > Is there a separate file for MSN? Because I downloaded the most updated
> > version of the add-in file from Files -> Work-in-process (version
> > 2.1.2013.02.06).Can you provide a link for the up-to-date add-in?
> >
> > Regards,
> >
> > Wz
> > --- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
> > >
> > > You're using an older version of the add-in, which has outdated element
> > > definitions for MSN. MSN changed their website structure last year, and
> > all
> > > of their elements had to be redefined.
> > >
> > > On Thu, Feb 7, 2013 at 11:28 AM, webz1984 wrote:
> > >
> > > > Hi,
> > > >
> > > > I ran the following functions
> > > >
> > > > =rchgetelementnumber("Version")
> > > > =rchgetelementnumber("MMM";,7)
> > > > =smfGetAParms(7)
> > > > =rchgetelementnumber("MMM";,989)
> > > > =smfGetAParms(989)
> > > >
> > > > The results are
> > > >
> > > > Stock Market Functions add-in, Version 2.1.2013.02.06 (C:\Program
> > > > Files\SMF Add-in; 1)
> > > > Error
> > > > MSN;% Institutional Ownership;
> > > >
> > http://investing.money.msn.com/investments/stock-report?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;OWNERSHIPINFORMATION;INSTITUTIONALOWNERSHIP; ; ;0;0;0;0
> > > > Error
> > > > YahooKS;Dividend;
> > http://finance.yahoo.com/q/ks?s=~~~~~;2;FINANCIALHIGHLIGHTS;FORWARDANNUAL DIVIDEND RATE; ; ;2;
> > >
> > > > As you can see, it always returns error when it should return a number.
> > > >
> > > > I am using office 2010 under Window 7. Tried other stocks as well such
> > as
> > > > "GOOG","IBM", none of them is working. Have worked on this for days
> > now,
> > > > and it's really frustrating.Really appreciate any suggestions.
> >
>
No worries, here are what I got,
smf_addin@yahoogrou
>
> Oops, sorry. For some reason, I saw 2012 in the version number instead of
> 2013. Yes, you are using the most recent beta version of the add-in.
>
> Do you have some type of firewall that is preventing EXCEL from accessing
> the Internet? Can you do an EXCEL Web Query?
>
> What do you get for these functions:
>
> =RCHGetTableCell(
> Highlights"
> =RCHGetWebData(
>
> On Thu, Feb 7, 2013 at 12:36 PM, webz1984 wrote:
>
> >
> > Thanks Randy,
> >
> > Is there a separate file for MSN? Because I downloaded the most updated
> > version of the add-in file from Files -> Work-in-process (version
> > 2.1.2013.02.
> >
> > Regards,
> >
> > Wz
> > --- In smf_addin@yahoogrou
> > >
> > > You're using an older version of the add-in, which has outdated element
> > > definitions for MSN. MSN changed their website structure last year, and
> > all
> > > of their elements had to be redefined.
> > >
> > > On Thu, Feb 7, 2013 at 11:28 AM, webz1984 wrote:
> > >
> > > > Hi,
> > > >
> > > > I ran the following functions
> > > >
> > > > =rchgetelementnumbe
> > > > =rchgetelementnumbe
> > > > =smfGetAParms(
> > > > =rchgetelementnumbe
> > > > =smfGetAParms(
> > > >
> > > > The results are
> > > >
> > > > Stock Market Functions add-in, Version 2.1.2013.02.
> > > > Files\SMF Add-in; 1)
> > > > Error
> > > > MSN;% Institutional Ownership;
> > > >
> > http://investing.
> > > > Error
> > > > YahooKS;Dividend;
> > http://finance.
> > >
> > > > As you can see, it always returns error when it should return a number.
> > > >
> > > > I am using office 2010 under Window 7. Tried other stocks as well such
> > as
> > > > "GOOG"
> > now,
> > > > and it's really frustrating.
> >
>
Thu Feb 7, 2013 1:29 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It doesn't make sense to me that:
=RCHGetElementNumber("MMM";,989)
...would return "Error", while:
=RCHGetTableCell("http://finance.yahoo.com/q/ks?s=MMM ",1,"Financial
Highlights","Forward Annual Dividend Rate")
...works. The first function is more or less executing a saved version of
the second function.
3000-4000 range are Google and MorningStar items. 5000+ is mainly AdvFN
(have you tried implementing the AdvFN "fix" mention in the LINKS area of
the Yahoo group?).
But the 989 element above really worries me, because Yahoo is a fairly
standard source.
Do previous functions work if you exit EXCEL and try them again? It could
be you had no access to the Internet temporarily and then saved some
errored out copies of web pages. The add-in saves copies of web pages, and
then extracts the data from those saved web pages. Exiting EXCEL purges all
of those saved web pages, as would the smfForceRecalculation macro (see the
LINKS area of the group for more info).
On Thu, Feb 7, 2013 at 2:19 PM, webz1984 bozi1984@gmail.com > wrote:
>
> No worries, here are what I got,
>
> 2.36
>
> I am working in my company network, not sure if there is any firewall.
> After returning from Lunch, it looks like I can get values from 3000-4000
> range , but still have value in 5000+ , e.g.
>
> =rchgetelementnumber($C2,5526)
>
> Any idea why?
>
=RCHGetElementNumbe
...would return "Error"
=RCHGetTableCell(
Highlights"
...works. The first function is more or less executing a saved version of
the second function.
3000-4000 range are Google and MorningStar items. 5000+ is mainly AdvFN
(have you tried implementing the AdvFN "fix" mention in the LINKS area of
the Yahoo group?).
But the 989 element above really worries me, because Yahoo is a fairly
standard source.
Do previous functions work if you exit EXCEL and try them again? It could
be you had no access to the Internet temporarily and then saved some
errored out copies of web pages. The add-in saves copies of web pages, and
then extracts the data from those saved web pages. Exiting EXCEL purges all
of those saved web pages, as would the smfForceRecalculati
LINKS area of the group for more info).
On Thu, Feb 7, 2013 at 2:19 PM, webz1984 bozi1984@gmail.
>
> No worries, here are what I got,
>
> 2.36
>
> I am working in my company network, not sure if there is any firewall.
> After returning from Lunch, it looks like I can get values from 3000-4000
> range , but still have value in 5000+ , e.g.
>
> =rchgetelementnumbe
>
> Any idea why?
>
Thu Feb 7, 2013 1:54 pm (PST) . Posted by:
"webz1984" webz1984
Sorry, I changed the order, so the first function returned 2.36, while the second returned http://imgur.com/9HIATXQ
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> It doesn't make sense to me that:
>
> =RCHGetElementNumber("MMM";,989)
>
> ...would return "Error", while:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/ks?s=MMM ",1,"Financial
> Highlights","Forward Annual Dividend Rate")
>
> ...works. The first function is more or less executing a saved version of
> the second function.
>
> 3000-4000 range are Google and MorningStar items. 5000+ is mainly AdvFN
> (have you tried implementing the AdvFN "fix" mention in the LINKS area of
> the Yahoo group?).
>
> But the 989 element above really worries me, because Yahoo is a fairly
> standard source.
>
> Do previous functions work if you exit EXCEL and try them again? It could
> be you had no access to the Internet temporarily and then saved some
> errored out copies of web pages. The add-in saves copies of web pages, and
> then extracts the data from those saved web pages. Exiting EXCEL purges all
> of those saved web pages, as would the smfForceRecalculation macro (see the
> LINKS area of the group for more info).
>
> On Thu, Feb 7, 2013 at 2:19 PM, webz1984 wrote:
>
> >
> > No worries, here are what I got,
> >
> > > 2.36
> >
> > I am working in my company network, not sure if there is any firewall.
> > After returning from Lunch, it looks like I can get values from 3000-4000
> > range , but still have value in 5000+ , e.g.
> >
> > =rchgetelementnumber($C2,5526)
> >
> > Any idea why?
> >
>
--- In smf_addin@yahoogrou
>
> It doesn't make sense to me that:
>
> =RCHGetElementNumbe
>
> ...would return "Error"
>
> =RCHGetTableCell(
> Highlights"
>
> ...works. The first function is more or less executing a saved version of
> the second function.
>
> 3000-4000 range are Google and MorningStar items. 5000+ is mainly AdvFN
> (have you tried implementing the AdvFN "fix" mention in the LINKS area of
> the Yahoo group?).
>
> But the 989 element above really worries me, because Yahoo is a fairly
> standard source.
>
> Do previous functions work if you exit EXCEL and try them again? It could
> be you had no access to the Internet temporarily and then saved some
> errored out copies of web pages. The add-in saves copies of web pages, and
> then extracts the data from those saved web pages. Exiting EXCEL purges all
> of those saved web pages, as would the smfForceRecalculati
> LINKS area of the group for more info).
>
> On Thu, Feb 7, 2013 at 2:19 PM, webz1984 wrote:
>
> >
> > No worries, here are what I got,
> >
> > > 2.36
> >
> > I am working in my company network, not sure if there is any firewall.
> > After returning from Lunch, it looks like I can get values from 3000-4000
> > range , but still have value in 5000+ , e.g.
> >
> > =rchgetelementnumbe
> >
> > Any idea why?
> >
>
Thu Feb 7, 2013 2:00 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Not good. Someone else reported that issue with the latest release...
But I haven't changed any reference libraries.
On Thu, Feb 7, 2013 at 2:54 PM, webz1984 bozi1984@gmail.com > wrote:
>
> Also, sometimes when I open the spreadsheet, it gave me an error of "Can't
> find project or Library"
>
But I haven't changed any reference libraries.
On Thu, Feb 7, 2013 at 2:54 PM, webz1984 bozi1984@gmail.
>
> Also, sometimes when I open the spreadsheet, it gave me an error of "Can'
> find project or Library"
>
Thu Feb 7, 2013 10:57 am (PST) . Posted by:
"Joseph King" joeking555
Is there a options equity trading journal template out there? Thank you!
Joseph
Sent from my iPhone
On Feb 7, 2013, at 6:47, "raniersfury" cburkhalterjr@yahoo.com > wrote:
> First off, thanks for putting this group together and to the members who have posted templates - it's saved countless hours of data pulling.
>
> Is there a template out there that tracks historic PE (high, low) by year, for the past 10 years?
>
> Also, I can't seem to get the 10 Year Financial Summary workbook to pull complete data for Berkshire Hathaway, either the BRK.A or the BRK.B tickers. Using "BRK" appears to pull about 5 years of data, but even that seems to have a few errors.
>
> Thanks in advance for any help with one or both of the above.
>
>
Joseph
Sent from my iPhone
On Feb 7, 2013, at 6:47, "raniersfury&q
> First off, thanks for putting this group together and to the members who have posted templates - it's saved countless hours of data pulling.
>
> Is there a template out there that tracks historic PE (high, low) by year, for the past 10 years?
>
> Also, I can't seem to get the 10 Year Financial Summary workbook to pull complete data for Berkshire Hathaway, either the BRK.A or the BRK.B tickers. Using "BRK" appears to pull about 5 years of data, but even that seems to have a few errors.
>
> Thanks in advance for any help with one or both of the above.
>
>
Thu Feb 7, 2013 11:10 am (PST) . Posted by:
"Randy Harmelink" rharmelink
For historical P/E ratios, try these element numbers with
RCHGetElementNumber:
# Source Element 7156 AdvFN-A Annual Financial Ratios -- Profit Margins
-- High PE Ratio -- FY1 7157 AdvFN-A Annual Financial Ratios -- Profit
Margins -- High PE Ratio -- FY2 7158 AdvFN-A Annual Financial Ratios --
Profit Margins -- High PE Ratio -- FY3 7159 AdvFN-A Annual Financial
Ratios -- Profit Margins -- High PE Ratio -- FY4 7160 AdvFN-A Annual
Financial Ratios -- Profit Margins -- High PE Ratio -- FY5 7161 AdvFN-A Annual
Financial Ratios -- Profit Margins -- High PE Ratio -- FY6 7162 AdvFN-A Annual
Financial Ratios -- Profit Margins -- High PE Ratio -- FY7 7163 AdvFN-A Annual
Financial Ratios -- Profit Margins -- High PE Ratio -- FY8 7164 AdvFN-A Annual
Financial Ratios -- Profit Margins -- High PE Ratio -- FY9 7165 AdvFN-A Annual
Financial Ratios -- Profit Margins -- High PE Ratio -- FY10 7166
AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY1 7167 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY2 7168 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY3 7169 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY4 7170 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY5 7171 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY6 7172 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY7 7173 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY8 7174 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY9 7175 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY10
BRK.A works fine for me in the SMF-Template-MSN-10-Year-Summaries.xls
workbook. You'll need to give me more details on what problem you're
having...
*BRK.A* *12/11* *12/10* *…* *
12/03* *Error* *Key Ratios* *Price/Earnings* 18.7 14.9 … 13.8 Error
*Price/Sales* 1.3 1.5 … 2.0 Error *Price/Book* 1.2 1.3 … 1.7 Error
*Book Value/Share* 99645.18 95250.72 … 50455.82 Error *% Net Profit
Margin* 7.1% 9.5% … 12.8% #VALUE! *% Return on Equity* 6.2% 8.2% …
10.5% #VALUE! *% Return on Assets* 2.6% 3.5% … 4.5% #VALUE! *
Debt/Equity* 0.37 0.37 … 0.12 Error *Interest Coverage* 5.7 7.4 … 24.6
Error *Balance Sheet* *Current Assets* 392,650,000,000 372,230,000,000
… 180,560,000,000 Error *Current Liabilities* 227,800,000,000
214,910,000,000 … 102,960,000,000 Error *Long Term Debt* 58,890,000,000
56,890,000,000 … 9,120,000,000 Error *Shares Outstanding* 1,650,000
1,650,000 … 1,540,000 Error *Income Statement* *Sales* 143,690,000,000
136,190,000,000 … 63,860,000,000 Error *EBIT* 15,310,000,000
19,050,000,000 … 12,020,000,000 Error *Depreciation* 5,490,000,000
4,970,000,000 … 829,000,000 Error *Total Net Income* 10,250,000,000
12,970,000,000 … 8,150,000,000 Error *Earnings Per Share* 6214.96
7927.68 … 5308.68 Error *% Tax Rate* 29.8% 29.4% … 31.7% #VALUE!
The 10th year has errors because MSN only has 9 years of data on BRK.A.
On Thu, Feb 7, 2013 at 7:47 AM, raniersfury cburkhalterjr@yahoo.com > wrote:
> First off, thanks for putting this group together and to the members who
> have posted templates - it's saved countless hours of data pulling.
>
> Is there a template out there that tracks historic PE (high, low) by year,
> for the past 10 years?
>
> Also, I can't seem to get the 10 Year Financial Summary workbook to pull
> complete data for Berkshire Hathaway, either the BRK.A or the BRK.B
> tickers. Using "BRK" appears to pull about 5 years of data, but even that
> seems to have a few errors.
>
> Thanks in advance for any help with one or both of the above.
>
RCHGetElementNumber
# Source Element 7156 AdvFN-A Annual Financial Ratios -- Profit Margins
-- High PE Ratio -- FY1 7157 AdvFN-A Annual Financial Ratios -- Profit
Margins -- High PE Ratio -- FY2 7158 AdvFN-A Annual Financial Ratios --
Profit Margins -- High PE Ratio -- FY3 7159 AdvFN-A Annual Financial
Ratios -- Profit Margins -- High PE Ratio -- FY4 7160 AdvFN-A Annual
Financial Ratios -- Profit Margins -- High PE Ratio -- FY5 7161 AdvFN-A Annual
Financial Ratios -- Profit Margins -- High PE Ratio -- FY6 7162 AdvFN-A Annual
Financial Ratios -- Profit Margins -- High PE Ratio -- FY7 7163 AdvFN-A Annual
Financial Ratios -- Profit Margins -- High PE Ratio -- FY8 7164 AdvFN-A Annual
Financial Ratios -- Profit Margins -- High PE Ratio -- FY9 7165 AdvFN-A Annual
Financial Ratios -- Profit Margins -- High PE Ratio -- FY10 7166
AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY1 7167 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY2 7168 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY3 7169 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY4 7170 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY5 7171 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY6 7172 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY7 7173 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY8 7174 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY9 7175 AdvFN-A Annual
Financial Ratios -- Profit Margins -- Low PE Ratio -- FY10
BRK.A works fine for me in the SMF-Template-
workbook. You'll need to give me more details on what problem you're
having...
*BRK.A* *12/11* *12/10* *…* *
12/03* *Error* *Key Ratios* *Price/Earnings* 18.7 14.9 … 13.8 Error
*Price/Sales* 1.3 1.5 … 2.0 Error *Price/Book* 1.2 1.3 … 1.7 Error
*Book Value/Share* 99645.18 95250.72 … 50455.82 Error *% Net Profit
Margin* 7.1% 9.5% … 12.8% #VALUE! *% Return on Equity* 6.2% 8.2% …
10.5% #VALUE! *% Return on Assets* 2.6% 3.5% … 4.5% #VALUE! *
Debt/Equity* 0.37 0.37 … 0.12 Error *Interest Coverage* 5.7 7.4 … 24.6
Error *Balance Sheet* *Current Assets* 392,650,000,
… 180,560,000,
214,910,000,
56,890,000,000 … 9,120,000,000 Error *Shares Outstanding* 1,650,000
1,650,000 … 1,540,000 Error *Income Statement* *Sales* 143,690,000,
136,190,000,
19,050,000,000 … 12,020,000,000 Error *Depreciation* 5,490,000,000
4,970,000,000 … 829,000,000 Error *Total Net Income* 10,250,000,000
12,970,000,000 … 8,150,000,000 Error *Earnings Per Share* 6214.96
7927.68 … 5308.68 Error *% Tax Rate* 29.8% 29.4% … 31.7% #VALUE!
The 10th year has errors because MSN only has 9 years of data on BRK.A.
On Thu, Feb 7, 2013 at 7:47 AM, raniersfury cburkhalterjr@
> First off, thanks for putting this group together and to the members who
> have posted templates - it's saved countless hours of data pulling.
>
> Is there a template out there that tracks historic PE (high, low) by year,
> for the past 10 years?
>
> Also, I can't seem to get the 10 Year Financial Summary workbook to pull
> complete data for Berkshire Hathaway, either the BRK.A or the BRK.B
> tickers. Using "BRK" appears to pull about 5 years of data, but even that
> seems to have a few errors.
>
> Thanks in advance for any help with one or both of the above.
>
Thu Feb 7, 2013 11:14 am (PST) . Posted by:
"Randy Harmelink" rharmelink
If you have a real-time data source, the add-in might be able to get the
data. For example, using the RCHGetYahooQuotes() function to get the data
from Yahoo if you have a real-time account.
But something like "Next Earnings Date" is not a "real time" type of data
item.
The add-in is intended as an ad hoc data retrieval item, not a bulk
downloader.
Sounds like you should be looking for some type of stock screener...
On Thu, Feb 7, 2013 at 7:30 AM, Hari harishr30@yahoo.co.in > wrote:
>
>
> Sub: Any Excel macro file available for downloading all the real-time
> stock price data from yahoo finance****
>
> ** **
>
> Is there any excel macro file available to download all the important
> fields from yahoo finance like price, next earnings date etc. for all
> around 500 stock tickers.
>
>
data. For example, using the RCHGetYahooQuotes(
from Yahoo if you have a real-time account.
But something like "Next Earnings Date" is not a "real time" type of data
item.
The add-in is intended as an ad hoc data retrieval item, not a bulk
downloader.
Sounds like you should be looking for some type of stock screener...
On Thu, Feb 7, 2013 at 7:30 AM, Hari harishr30@yahoo.
>
>
> Sub: Any Excel macro file available for downloading all the real-time
> stock price data from yahoo finance****
>
> ** **
>
> Is there any excel macro file available to download all the important
> fields from yahoo finance like price, next earnings date etc. for all
> around 500 stock tickers.
>
>
Thu Feb 7, 2013 11:18 am (PST) . Posted by:
"RandCinv" randc_1yh
Olsoft makes several Excel macros, one of which may do what you are looking for: http://www.analyzerxl.com
On Feb 7, 2013, at 11:14 AM, Randy Harmelink rharmelink@gmail.com > wrote:
> If you have a real-time data source, the add-in might be able to get the data. For example, using the RCHGetYahooQuotes() function to get the data from Yahoo if you have a real-time account.
>
> But something like "Next Earnings Date" is not a "real time" type of data item.
>
> The add-in is intended as an ad hoc data retrieval item, not a bulk downloader.
>
> Sounds like you should be looking for some type of stock screener...
>
>
> On Thu, Feb 7, 2013 at 7:30 AM, Hari harishr30@yahoo.co.in > wrote:
>
> Sub: Any Excel macro file available for downloading all the real-time stock price data from yahoo finance
>
>
>
> Is there any excel macro file available to download all the important fields from yahoo finance like price, next earnings date etc. for all around 500 stock tickers.
>
>
>
>
>
On Feb 7, 2013, at 11:14 AM, Randy Harmelink rharmelink@gmail.
> If you have a real-time data source, the add-in might be able to get the data. For example, using the RCHGetYahooQuotes(
>
> But something like "Next Earnings Date" is not a "real time" type of data item.
>
> The add-in is intended as an ad hoc data retrieval item, not a bulk downloader.
>
> Sounds like you should be looking for some type of stock screener...
>
>
> On Thu, Feb 7, 2013 at 7:30 AM, Hari harishr30@yahoo.
>
> Sub: Any Excel macro file available for downloading all the real-time stock price data from yahoo finance
>
>
>
> Is there any excel macro file available to download all the important fields from yahoo finance like price, next earnings date etc. for all around 500 stock tickers.
>
>
>
>
>
Tidak ada komentar:
Posting Komentar