Messages In This Digest (11 Messages)
- 1a.
- Google latest shares outstanding From: antonvanas1989
- 1b.
- Re: Google latest shares outstanding From: Randy Harmelink
- 2a.
- Re: element numbers From: antonvanas1989
- 2b.
- Re: element numbers From: Randy Harmelink
- 2c.
- Re: element numbers From: antonvanas1989
- 2d.
- Re: element numbers From: antonvanas1989
- 2e.
- Re: element numbers From: Randy Harmelink
- 3a.
- Re: MSN Financial Statements From: rebalance85
- 3b.
- Re: MSN Financial Statements From: Randy Harmelink
- 4a.
- A stock's listing exchange From: cherry77tree
- 4b.
- Re: A stock's listing exchange From: Randy Harmelink
Messages
- 1a.
-
Google latest shares outstanding
Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989
Sat Jun 2, 2012 2:42 am (PDT)
Dear Randy, how can i get the latest outstanding shares from any stock from google finance?
Example WMT:
http://www.google.com/finance? cid=38230#
It shows 3,39B shares, how can i get in my spreadsheet something like this 3.390.
With the element i only can get the latest quarter outstanding shares.
- 1b.
-
Re: Google latest shares outstanding
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 2, 2012 3:04 am (PDT)
Try something like:
=RCHGetTableCell("http://www.google. com/finance? ",1,">Shares"cid=38230 )
=RCHGetTableCell("http://www.google. com/finance? ",1,">Shares"q=WMT )
On Sat, Jun 2, 2012 at 2:42 AM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
> Dear Randy, how can i get the latest outstanding shares from any stock
> from google finance?
>
> Example WMT:
> http://www.google.com/finance? cid=38230#
>
> It shows 3,39B shares, how can i get in my spreadsheet something like this
> 3.390.
>
> With the element i only can get the latest quarter outstanding shares.
>
- 2a.
-
Re: element numbers
Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989
Sat Jun 2, 2012 2:56 am (PDT)
Randy, i have today downloaded the new Text 1 file again (with closing excel and deleting older file), and still the #25 element and the #13862 are not working.
#25 gives me previous close instead of current price.
#13862 gives Error.
Rest of msn element's are working fine
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The smf-elements-1.txt file in the add-in's folder contains the element
> definitions for MSN. Those all had to be changed at the end of April
> because MSN changed their website structure and content. There is a new
> smf-elements-1.txt file in the "Works in Progress" folder of the FILES area
> of the group, that contains those new definitions.
>
> You should exit EXCEL, replace that file in the add-in folder with the file
> that you can download, and then restart EXCEL. That will update your
> element definitions.
>
> On Mon, May 28, 2012 at 11:48 AM, Gordon <gordonj5@...> wrote:
>
> > I looked at the elements definitions and I seen no change from previous.
> > I'm looking for the last price of a stock.
> > The element # should be 25 to bring this information in.
> > It doesn't.
> > Am I misinterpreting the information in element definitions or am I using
> > the wrong formula.
> >
> > Sorry that I can't seem to understand your answer about element
> > definitions.
> >
> > What replaces 25?
> > What replaces 30?
> > What replaces 31?
> >
>
- 2b.
-
Re: element numbers
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 2, 2012 3:44 am (PDT)
What version of EXCEL do you have? What do you get for:
=RCHGetElementNumber("Version" )
=smfGetAParms(13862)
=RCHGetElementNumber("MMM",13862)
=TRIM(smfStrExtr("|"&smfGetTagCon tent("
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=MMM
","div",-1,"class=""cn" ">"),"|", "<"))
As for element #25, I've already said about a dozen times -- it's working
and returning what MSN is posting. The problem is MSN is posting the
previous closing price as "Last Price".
On Sat, Jun 2, 2012 at 2:56 AM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
> Randy, i have today downloaded the new Text 1 file again (with closing
> excel and deleting older file), and still the #25 element and the #13862
> are not working.
>
> #25 gives me previous close instead of current price.
> #13862 gives Error.
>
> Rest of msn element's are working fine
>
- 2c.
-
Re: element numbers
Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989
Sat Jun 2, 2012 3:56 am (PDT)
Stock Market Functions add-in, Version 2.1.2010.08.02
(Nothing)
Error
3M Co
Bad move from MSN then... Hope they will fix it soon.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> What version of EXCEL do you have? What do you get for:
>
> =RCHGetElementNumber("Version" )
> =smfGetAParms(13862)
> =RCHGetElementNumber("MMM",13862)
> =TRIM(smfStrExtr("|"&smfGetTagCon tent("
> 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=MMM
> ","div",-1,"class=""cn" ">"),"|", "<"))
>
> As for element #25, I've already said about a dozen times -- it's working
> and returning what MSN is posting. The problem is MSN is posting the
> previous closing price as "Last Price".
>
> On Sat, Jun 2, 2012 at 2:56 AM, antonvanas1989 <antonvanas1989@...>wrote:
>
> > Randy, i have today downloaded the new Text 1 file again (with closing
> > excel and deleting older file), and still the #25 element and the #13862
> > are not working.
> >
> > #25 gives me previous close instead of current price.
> > #13862 gives Error.
> >
> > Rest of msn element's are working fine
> >
>
- 2d.
-
Re: element numbers
Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989
Sat Jun 2, 2012 4:03 am (PDT)
=smfGetAParms(13862)
it now gives this:
MSN;Company Name;=TRIM(smfStrExtr("|"&smfGetTag Content("http://investing. money.msn. ","div",-1,"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=~~ ~~~ class=""cn" "")&"<"," |","<"))
--- In smf_addin@yahoogroups.com , "antonvanas1989" <antonvanas1989@...> wrote:
>
> Stock Market Functions add-in, Version 2.1.2010.08.02
> (Nothing)
> Error
> 3M Co
>
> Bad move from MSN then... Hope they will fix it soon.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > What version of EXCEL do you have? What do you get for:
> >
> > =RCHGetElementNumber("Version" )
> > =smfGetAParms(13862)
> > =RCHGetElementNumber("MMM",13862)
> > =TRIM(smfStrExtr("|"&smfGetTagCon tent("
> > 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=MMM
> > ","div",-1,"class=""cn" ">"),"|", "<"))
> >
> > As for element #25, I've already said about a dozen times -- it's working
> > and returning what MSN is posting. The problem is MSN is posting the
> > previous closing price as "Last Price".
> >
> > On Sat, Jun 2, 2012 at 2:56 AM, antonvanas1989 <antonvanas1989@>wrote:
> >
> > > Randy, i have today downloaded the new Text 1 file again (with closing
> > > excel and deleting older file), and still the #25 element and the #13862
> > > are not working.
> > >
> > > #25 gives me previous close instead of current price.
> > > #13862 gives Error.
> > >
> > > Rest of msn element's are working fine
> > >
> >
>
- 2e.
-
Re: element numbers
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 2, 2012 8:40 am (PDT)
But does element 13862 now work? The "nothing" return you got before would
indicate no element definition was loaded. You are running with a very old
copy of the add-in. I'd suggest updating it. I don't think it works with
that style of element definition.
On Sat, Jun 2, 2012 at 4:03 AM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
> =smfGetAParms(13862)
> it now gives this:
> MSN;Company Name;=TRIM(smfStrExtr("|"&smfGetTag Content("
> 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=~~ ~~~
> ","div",-1,"class=""cn" "")&"<"," |","<"))
>
>
> --- In smf_addin@yahoogroups.com , "antonvanas1989" <antonvanas1989@...>
> wrote:
> >
> > Stock Market Functions add-in, Version 2.1.2010.08.02
> > (Nothing)
> > Error
> > 3M Co
>
- 3a.
-
Re: MSN Financial Statements
Posted by: "rebalance85" rebalance85@yahoo.com rebalance85
Sat Jun 2, 2012 3:17 am (PDT)
It is OK now.
I find another formula get result ERROR:
=RCHGetTableCell(" http://investing. money.msn. "&Ticker, 1,"Accounts Receivable - Trade, Net")com/investments/ stock-balance- sheet?stmtView= Ann&Symbol=
Any suggestions?
Thank you!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You must not be using U.S. Regional settings. Just take off the
> DATEVALUE() function and leave the date as a string literal.
>
> On Fri, Jun 1, 2012 at 10:28 PM, rebalance85 <rebalance85@...> wrote:
>
> > I try =DATEVALUE(12/31/2011), it seems that the excel couldn't reconige
> > the 12/31/2011.
> >
> > --- In smf_addin@yahoogroups.com , "rebalance85" <rebalance85@> wrote:
> > >
> > > Mine is not working, #value!. Is there any other formula to replace this
> > one?
> >
>
- 3b.
-
Re: MSN Financial Statements
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 2, 2012 3:46 am (PDT)
Your search string is not what MSN is using as the label -- try:
=RCHGetTableCell("
http://investing.money.msn. "&A1,com/investments/ stock-balance- sheet?stmtView= Ann&Symbol=
1,"Accounts Receivable -Trade, Net")
On Sat, Jun 2, 2012 at 3:17 AM, rebalance85 <rebalance85@yahoo.com > wrote:
> I find another formula get result ERROR:
> =RCHGetTableCell("
> http://investing.money.msn. "&Ticker,com/investments/ stock-balance- sheet?stmtView= Ann&Symbol=
> 1,"Accounts Receivable - Trade, Net")
> Any suggestions?
>
- 4a.
-
A stock's listing exchange
Posted by: "cherry77tree" david.nincic.wg99@wharton.upenn.edu cherry77tree
Sat Jun 2, 2012 12:52 pm (PDT)
Is there a way to return a stock's listing exchange? (e.g., "IBM" would
return NYSE, "CMMCY" would return Pink or OTC)
I thought =RCHGetElementNumber("IBM",3) would do it, but it looks like
that element (Source: MSN, Element: Exchange) no longer works.
The reason I ask is that Yahoo Finance no longer uses an exchange suffix
(e.g., .PK, .OB) on its ticker symbols. That suffix was a useful
reminder to me on whether a stock was Pink Sheet or OTC Bulletin Board.
I always avoid those stocks.
- 4b.
-
Re: A stock's listing exchange
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 2, 2012 1:45 pm (PDT)
You probably need the new MSN element definitions file from the "Works in
Progress" folder:
http://finance.groups.yahoo. com/group/ smf_addin/ message/18529
On Sat, Jun 2, 2012 at 12:52 PM, cherry77tree <
david.nincic.wg99@wharton. > wrote:upenn.edu
>
> Is there a way to return a stock's listing exchange? (e.g., "IBM" would
> return NYSE, "CMMCY" would return Pink or OTC)
>
> I thought =RCHGetElementNumber("IBM",3) would do it, but it looks like
> that element (Source: MSN, Element: Exchange) no longer works.
>
> The reason I ask is that Yahoo Finance no longer uses an exchange suffix
> (e.g., .PK, .OB) on its ticker symbols. That suffix was a useful reminder
> to me on whether a stock was Pink Sheet or OTC Bulletin Board. I always
> avoid those stocks.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar