15 New Messages
Digest #2750
Messages
Thu Aug 29, 2013 4:15 am (PDT) . Posted by:
bmissell_thornhill
Interesting - did not know differnent processors would yield
different results!
=RCHGetElementNumbe
Functions add-in, Version 2.1.2012.12.
(C:\Users&#
=RCHGetElementNumbe
=smfGetAParms(
Name;=TRIM(smfStrEx
y.msn.com/investmen
CR=1&AF=1&IH=
A=1&CFQ=1&TYS=
lass=""
Bill
--- In undefined, <smf_addin@yahoogrou
An upload file really won't tell me anything, because it's the
processing on your machine that is different than mine. If I run
your file on my machine, I'll get my results, not yours.
What do you get for the following:
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfGetAParms(
On Wed, Aug 28, 2013 at 6:12 PM, <bmissell@
13862 still isn't working for me. I upload a file and i hope it's
in the right place - but I'm not sure. Its in "All Files" I
didn't see a way to upload into "Attachments&q
that up. the file name is
Thu Aug 29, 2013 4:21 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. Your results for the first and third functions look OK. Do you have
an older version of EXCEL?
What do you get for:
=TRIM(smfGetTagContent("
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
","h1",0,"title="""))
=smfGetTagContent("
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
","h1",0,"title=""")
On Thu, Aug 29, 2013 at 4:15 AM, <bmissell@comcast.net > wrote:
> Interesting - did not know differnent processors would yield different
> results!
> =RCHGetElementNumber("Version") yeilds - "Stock Market Functions add-in,
> Version 2.1.2012.12.29 (C:\Users\bmissell\AppData\Roaming\Microsoft\AddIns;
> 1)"
> =RCHGetElementNumber("MMM";,13862) - yields - "Error"
> =smfGetAParms(13862) yields "MSN;Company
> Name;=TRIM(smfStrExtr("|"&smfGetTagContent("
> 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""")&"<","|","<"))"
>
> Bill
>
an older version of EXCEL?
What do you get for:
=TRIM(smfGetTagCont
http://investing.
","
=smfGetTagContent(
http://investing.
","
On Thu, Aug 29, 2013 at 4:15 AM, <bmissell@comcast.
> Interesting - did not know differnent processors would yield different
> results!
> =RCHGetElementNumbe
> Version 2.1.2012.12.
> 1)"
> =RCHGetElementNumbe
> =smfGetAParms(
> Name;=TRIM(smfStrEx
> http://investing.
> CR=1&AF=1&IH=
>
> Bill
>
Thu Aug 29, 2013 7:13 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Folks, I think we have pretty well established that ADVFN site is not
working.
I don't think we need any more posting to tell us what we already know.
Come to think of it, we probably don't need my posting either.
Have a nice day, everyone
Kermit
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of codyklein
Sent: Wednesday, August 28, 2013 7:26 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Advfn data not updating in smf_addin
The new site is disappointing IMO. Heres a peek at FTR:
http://www.advfn.com/common/financial/NASDAQ/frontier-communications-corp-mm
-FTR/full-financials?pm=Q
--- In smf_addin@yahoogroups.com , "codyklein" <codyklein@...> wrote:
>
> The ADVFN site isn't even working right if you try and go back to get
annual data starting in 2003 or so it takes you to the wrong page, it kicks
you back to the summary page.
>
------------------------------------
Yahoo! Groups Links
working.
I don't think we need any more posting to tell us what we already know.
Come to think of it, we probably don't need my posting either.
Have a nice day, everyone
Kermit
-----Original Message-----
From: smf_addin@yahoogrou
Of codyklein
Sent: Wednesday, August 28, 2013 7:26 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: Advfn data not updating in smf_addin
The new site is disappointing IMO. Heres a peek at FTR:
http://www.advfn.
-FTR/full-financial
--- In smf_addin@yahoogrou
>
> The ADVFN site isn't even working right if you try and go back to get
annual data starting in 2003 or so it takes you to the wrong page, it kicks
you back to the summary page.
>
------------
Yahoo! Groups Links
Thu Aug 29, 2013 7:58 am (PDT) . Posted by:
shareholdrdotcom
Do you have a book you're willing to share with the group that
has GuruFocus table data?
--- In smf_addin@yahoogrou
I've already switched over to GuruFocus. I think the ADVFN
changes are not an improvement. Not sure what they were trying
to accomplish.
--- In smf_addin@yahoogrou
<rharmelink@
>
> Part of my problem is that I'm not sure smfGetAdvFNElement(
*can* work as
> before. The new "beta" page I've seen is a completely different
structure
> of line items. They are mostly the raw data items, like "Cash &
> Equivalents"
ratios can be
> derived, but that's a whole new level of understanding and
processing. It
> depends so much on exactly what was being used from the AdvFN
page.
>
> GuruFocus does have 10 years of data. For example:
>
>
=RCHGetTableCell(
ept <http://www.gurufocu
> per share",
>
> But you do need to be logged in with an IE security cookie. And
premium
> members have more line items available to them.
>
> On Wed, Aug 28, 2013 at 3:03 PM, ridgebacksexcel
<tmallen2@
>
> >
> > I was going to ask you about this problem and when it might
be fixed as
> > well but I see you have answered it already somewhat.
> >
> > I have most of my spreadsheets tied to the ADVFN site so I
would
> > eventually like to get this resolved.
> >
> > When their website settles down and looks like it is done,
will you be
> > adjusting the smfgetADVFNElement function to work as before?
> >
> > I would rather wait and not change my entire spreadsheet if
it can be done
> > in a month or two. I would probably spend half that time
fixing all the
> > work I have done so far switching to something else.
> >
> > I could switch to Yahoo but that is only 3 years of data.
> >
> > Luckily I had a backup Financial page copied for just
something like this.
> > I spent forever manually entering data before I discovered
your add-in
> > program. Thanks so much.
> >
> > I know how much work this has to be and I don't envy you.
> >
> > Any other work around you might suggest? My sheet will
function but not
> > update any new financials but earning season is over for now
so I have some
> > time to wait.
> >
>
Thu Aug 29, 2013 7:58 am (PDT) . Posted by:
"Anteco" antecotv
Good morning to you all,
WAs wondering if nyone can tell me how to get the dividend date and ex-dividend date for foreign stocks. For example I tried the following formulas:
=RCHGetElementNumber($A8,992)=RCHGetElementNumber($A8,991)
with symbols RRS.L and CA.PA and the result is N/A. Strangely enough it picks up the dividend and other info such as stock splits.
I checked the Foreign stock tables in yahoo price history and they seem to be idential in rows and columns to US stocks.
Any ideas? Thanks
Daniel
WAs wondering if nyone can tell me how to get the dividend date and ex-dividend date for foreign stocks. For example I tried the following formulas:
=RCHGetElementNumbe
with symbols RRS.L and CA.PA and the result is N/A. Strangely enough it picks up the dividend and other info such as stock splits.
I checked the Foreign stock tables in yahoo price history and they seem to be idential in rows and columns to US stocks.
Any ideas? Thanks
Daniel
Thu Aug 29, 2013 8:29 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You'd need to find another source. N/A is what Yahoo is populating the web
pages with:
http://finance.yahoo.com/q/ks?s=RRS.L
You could always try the "Send Feedback" link on the page and ask Yahoo
about the issue.
On Thu, Aug 29, 2013 at 6:34 AM, Anteco <antecotv@yahoo.com > wrote:
> Good morning to you all,
> WAs wondering if nyone can tell me how to get the dividend date and
> ex-dividend date for foreign stocks. For example I tried the following
> formulas:
> =RCHGetElementNumber($A8,992)=RCHGetElementNumber($A8,991)
>
> with symbols RRS.L and CA.PA and the result is N/A. Strangely enough it
> picks up the dividend and other info such as stock splits.
> I checked the Foreign stock tables in yahoo price history and they seem to
> be idential in rows and columns to US stocks.
> Any ideas? Thanks
> Daniel
>
pages with:
http://finance.
You could always try the "Send Feedback" link on the page and ask Yahoo
about the issue.
On Thu, Aug 29, 2013 at 6:34 AM, Anteco <antecotv@yahoo.
> Good morning to you all,
> WAs wondering if nyone can tell me how to get the dividend date and
> ex-dividend date for foreign stocks. For example I tried the following
> formulas:
> =RCHGetElementNumbe
>
> with symbols RRS.L and CA.PA and the result is N/A. Strangely enough it
> picks up the dividend and other info such as stock splits.
> I checked the Foreign stock tables in yahoo price history and they seem to
> be idential in rows and columns to US stocks.
> Any ideas? Thanks
> Daniel
>
Thu Aug 29, 2013 9:30 am (PDT) . Posted by:
"ridgebacksexcel" ridgebacksexcel
Randy,
I am now working on converting my feed source over to the gurufocus.com site. I am having trouble getting the RCHGetTableCell function to pull data from one of the Financial lines.
I need it to find data for the Current Quarter, Balance Sheet, for "Current Portion of Long-Term Debt" line.
Stock ticker GLW. Data I need should be 72.00
Data I get is --
Here is the formula I am trying to use. Other lines pull fine.
=RCHGetTableCell("http://www.gurufocus.com/financials/glw ",16,">Balance Sheet<",">Current Portion of Long-Term Debt<",,,,,,"--")
Thanks. This is driving me crazy.
I am now working on converting my feed source over to the gurufocus.com site. I am having trouble getting the RCHGetTableCell function to pull data from one of the Financial lines.
I need it to find data for the Current Quarter, Balance Sheet, for "Current Portion of Long-Term Debt" line.
Stock ticker GLW. Data I need should be 72.00
Data I get is --
Here is the formula I am trying to use. Other lines pull fine.
=RCHGetTableCell(
Thanks. This is driving me crazy.
Thu Aug 29, 2013 9:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You search strings don't align you to the row in the table. Try:
=RCHGetTableCell("http://www.gurufocus.com/financials/glw ",16,"except for
per share",">Current Portion of Long-Term Debt<")
For your version, the first occurrence of ">Balance Sheet<" is in the list
of links above all the tables. Then the string ">Current Portion of
Long-Term Debt<" is in the "Select a Metric" drop-down box for the chart.
You're not even near a table there. If your other lines are pulling fine,
it's only by accident.
On Thu, Aug 29, 2013 at 9:30 AM, ridgebacksexcel <tmallen2@bellsouth.net >wrote:
>
> I am now working on converting my feed source over to the gurufocus.comsite. I am having trouble getting the RCHGetTableCell function to pull data
> from one of the Financial lines.
>
> I need it to find data for the Current Quarter, Balance Sheet, for
> "Current Portion of Long-Term Debt" line.
>
> Stock ticker GLW. Data I need should be 72.00
> Data I get is --
>
> Here is the formula I am trying to use. Other lines pull fine.
>
> =RCHGetTableCell("http://www.gurufocus.com/financials/glw ",16,">Balance
> Sheet<",">Current Portion of Long-Term Debt<",,,,,,"--")
>
> Thanks. This is driving me crazy.
>
=RCHGetTableCell(
per share",
For your version, the first occurrence of ">Balance Sheet<" is in the list
of links above all the tables. Then the string ">Current Portion of
Long-Term Debt<" is in the "Select a Metric" drop-down box for the chart.
You're not even near a table there. If your other lines are pulling fine,
it's only by accident.
On Thu, Aug 29, 2013 at 9:30 AM, ridgebacksexcel <tmallen2@bellsouth.
>
> I am now working on converting my feed source over to the gurufocus.comsite. I am having trouble getting the RCHGetTableCell function to pull data
> from one of the Financial lines.
>
> I need it to find data for the Current Quarter, Balance Sheet, for
> "Current Portion of Long-Term Debt" line.
>
> Stock ticker GLW. Data I need should be 72.00
> Data I get is --
>
> Here is the formula I am trying to use. Other lines pull fine.
>
> =RCHGetTableCell(
> Sheet<"
>
> Thanks. This is driving me crazy.
>
Thu Aug 29, 2013 11:37 am (PDT) . Posted by:
"ridgebacksexcel" ridgebacksexcel
Randy,
Thanks for the quick reply. That seems to work.
Just so I understand this stuff better, how come you use the first PFind string as: "except per share" without the > and < surrounding it?
I see that you want to start the initial search at the top of the table. Why not >Per Share Data< as the first PFind? It seems to not work however.
I see you are pulling the last 3 words from the source code here I think:
<font class="micro"> <img src="/images/question.png" alt="help";><a href="http://www.gurufocus.com/news.php?id=33474 " class="gray" target="_blank">See this page for the explanation of the data and charts </a>
* All numbers are in millions except for per share data </font>
<table id="Rf" class="R10" style="clear:both;width:1000px;table-layout: fixed;"><tbody>;<tr><td class="call2" width="16%" nowrap>Per Share Data<a name="sh" id="sh"></a></td><td colspan="11" class="s22" width="61%">Annuals</td><td colspan="5" class="warn2" width="23%">Quarterly<;/td></tr><tr onClick="javascript:tablerowajaxpage('/modules/chart/stock/stock_iframe.php??symbol=GLW&series[]=per share rev&series[]=per share eps&series[]=Book Value Per Share&title=Per Share Data&trendline[]=1&showq=true&quarterlydata','Rf',this,'Fiscal Period1011054522');" onmouseover = "this.className='highlight highlightwithicon';" onMouseOut="this.className='';"><td class='tk' title='Fiscal Period'><div style='width:200px;'>Fiscal Period</div></td>
and then the table data starts.
Interesting. Does it find those 3 exact works at the beginning of the source code I pasted?
What is the difference with > < surrounding text or not surrounding it?
Thanks. This should help me finish my project.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You search strings don't align you to the row in the table. Try:
>
> =RCHGetTableCell("http://www.gurufocus.com/financials/glw ",16,"except for
> per share",">Current Portion of Long-Term Debt<")
>
> For your version, the first occurrence of ">Balance Sheet<" is in the list
> of links above all the tables. Then the string ">Current Portion of
> Long-Term Debt<" is in the "Select a Metric" drop-down box for the chart.
> You're not even near a table there. If your other lines are pulling fine,
> it's only by accident.
>
> On Thu, Aug 29, 2013 at 9:30 AM, ridgebacksexcel <tmallen2@...>wrote:
>
> >
> > I am now working on converting my feed source over to the gurufocus.comsite. I am having trouble getting the RCHGetTableCell function to pull data
> > from one of the Financial lines.
> >
> > I need it to find data for the Current Quarter, Balance Sheet, for
> > "Current Portion of Long-Term Debt" line.
> >
> > Stock ticker GLW. Data I need should be 72.00
> > Data I get is --
> >
> > Here is the formula I am trying to use. Other lines pull fine.
> >
> > =RCHGetTableCell("http://www.gurufocus.com/financials/glw ",16,">Balance
> > Sheet<",">Current Portion of Long-Term Debt<",,,,,,"--")
> >
> > Thanks. This is driving me crazy.
> >
>
Thanks for the quick reply. That seems to work.
Just so I understand this stuff better, how come you use the first PFind string as: "except per share" without the > and < surrounding it?
I see that you want to start the initial search at the top of the table. Why not >Per Share Data< as the first PFind? It seems to not work however.
I see you are pulling the last 3 words from the source code here I think:
<font class="
* All numbers are in millions except for per share data </font>
<table id="Rf" class="
and then the table data starts.
Interesting. Does it find those 3 exact works at the beginning of the source code I pasted?
What is the difference with > < surrounding text or not surrounding it?
Thanks. This should help me finish my project.
--- In smf_addin@yahoogrou
>
> You search strings don't align you to the row in the table. Try:
>
> =RCHGetTableCell(
> per share",
>
> For your version, the first occurrence of ">Balance Sheet<" is in the list
> of links above all the tables. Then the string ">Current Portion of
> Long-Term Debt<" is in the "Select a Metric" drop-down box for the chart.
> You're not even near a table there. If your other lines are pulling fine,
> it's only by accident.
>
> On Thu, Aug 29, 2013 at 9:30 AM, ridgebacksexcel <tmallen2@
>
> >
> > I am now working on converting my feed source over to the gurufocus.comsite. I am having trouble getting the RCHGetTableCell function to pull data
> > from one of the Financial lines.
> >
> > I need it to find data for the Current Quarter, Balance Sheet, for
> > "Current Portion of Long-Term Debt" line.
> >
> > Stock ticker GLW. Data I need should be 72.00
> > Data I get is --
> >
> > Here is the formula I am trying to use. Other lines pull fine.
> >
> > =RCHGetTableCell(
> > Sheet<"
> >
> > Thanks. This is driving me crazy.
> >
>
Thu Aug 29, 2013 9:41 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Randy, I hate to ask for help but I have spent hours already trying to
figure out how to capture the stock splits information from this webpage
http://getsplithistory.com/IBM
What I'd like to do is create a worksheet that calculates the total number
of shares one would have based on purchase date and the stock splits that
have occurred since purchase.
This table does the calcultations with a javascript.
Seems like I should be able to do a table download and then do the
calculations
However, I have not been successful. Any chance you might figure this out
for me?
Thanks,
Kermit
figure out how to capture the stock splits information from this webpage
http://getsplithist
What I'd like to do is create a worksheet that calculates the total number
of shares one would have based on purchase date and the stock splits that
have occurred since purchase.
This table does the calcultations with a javascript.
Seems like I should be able to do a table download and then do the
calculations
However, I have not been successful. Any chance you might figure this out
for me?
Thanks,
Kermit
Thu Aug 29, 2013 9:51 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Are you asking for something other than this to grab the table?
=RCHGetHTMLTable("http://getsplithistory.com/IBM ","",1,"",1)
On Thu, Aug 29, 2013 at 9:41 AM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> Randy, I hate to ask for help but I have spent hours already trying to
> figure out how to capture the stock splits information from this webpage
> ****
>
> ** **
>
> http://getsplithistory.com/IBM ****
>
> ** **
>
> What I'd like to do is create a worksheet that calculates the total number
> of shares one would have based on purchase date and the stock splits that
> have occurred since purchase.****
>
> This table does the calcultations with a javascript. ****
>
> ** **
>
> Seems like I should be able to do a table download and then do the
> calculations****
>
> ** **
>
> However, I have not been successful. Any chance you might figure this out
> for me?****
>
>
>
=RCHGetHTMLTable(
On Thu, Aug 29, 2013 at 9:41 AM, Kermit W. Prather
<kermitp@tampabay.
>
> Randy, I hate to ask for help but I have spent hours already trying to
> figure out how to capture the stock splits information from this webpage
> ****
>
> ** **
>
> http://getsplithist
>
> ** **
>
> What I'd like to do is create a worksheet that calculates the total number
> of shares one would have based on purchase date and the stock splits that
> have occurred since purchase.***
>
> This table does the calcultations with a javascript. ****
>
> ** **
>
> Seems like I should be able to do a table download and then do the
> calculations*
>
> ** **
>
> However, I have not been successful. Any chance you might figure this out
> for me?****
>
>
>
Thu Aug 29, 2013 9:57 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Sorry, I forgot to mention that the first field in each table row has the
calculated value to multiply the shares for the split
<tr class="2"><td>May 27, 1999</td><td class="bold"><span
class="c-blue">2</span> : 1</td><td>116.00</td><td>236.25 <span class="f-11
c-light">(May 26)</span></td><td><span class="c-red">-1.80%</span></td><td
class="a-right"><input type="text" class="calculation";></td></tr>
Randy, I hate to ask for help but I have spent hours already trying to
figure out how to capture the stock splits information from this webpage
http://getsplithistory.com/IBM
What I'd like to do is create a worksheet that calculates the total number
of shares one would have based on purchase date and the stock splits that
have occurred since purchase.
This table does the calcultations with a javascript.
Seems like I should be able to do a table download and then do the
calculations
However, I have not been successful. Any chance you might figure this out
for me?
Thanks,
Kermit
calculated value to multiply the shares for the split
<tr class="
class="
c-light"
class="
Randy, I hate to ask for help but I have spent hours already trying to
figure out how to capture the stock splits information from this webpage
http://getsplithist
What I'd like to do is create a worksheet that calculates the total number
of shares one would have based on purchase date and the stock splits that
have occurred since purchase.
This table does the calcultations with a javascript.
Seems like I should be able to do a table download and then do the
calculations
However, I have not been successful. Any chance you might figure this out
for me?
Thanks,
Kermit
Thu Aug 29, 2013 10:00 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Well I'm not really sure. I need the Class= from each table row. In addition to grabbing the table.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Thursday, August 29, 2013 12:51 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Need help with this webpage
Are you asking for something other than this to grab the table?
=RCHGetHTMLTable("http://getsplithistory.com/IBM ","",1,"",1)
On Thu, Aug 29, 2013 at 9:41 AM, Kermit W. Prather <kermitp@tampabay.rr.com > wrote:
Randy, I hate to ask for help but I have spent hours already trying to figure out how to capture the stock splits information from this webpage
http://getsplithistory.com/IBM
What I'd like to do is create a worksheet that calculates the total number of shares one would have based on purchase date and the stock splits that have occurred since purchase.
This table does the calcultations with a javascript.
Seems like I should be able to do a table download and then do the calculations
However, I have not been successful. Any chance you might figure this out for me?
From: smf_addin@yahoogrou
Sent: Thursday, August 29, 2013 12:51 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Need help with this webpage
Are you asking for something other than this to grab the table?
=RCHGetHTMLTable(
On Thu, Aug 29, 2013 at 9:41 AM, Kermit W. Prather <kermitp@tampabay.
Randy, I hate to ask for help but I have spent hours already trying to figure out how to capture the stock splits information from this webpage
http://getsplithist
What I'd like to do is create a worksheet that calculates the total number of shares one would have based on purchase date and the stock splits that have occurred since purchase.
This table does the calcultations with a javascript.
Seems like I should be able to do a table download and then do the calculations
However, I have not been successful. Any chance you might figure this out for me?
Thu Aug 29, 2013 10:05 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Why not just compute it yourself, from the data in the table. For example,
referring to the "Ratio" column:
=smfWord(D4,1,":") / smfWord(D4,2,":")
On Thu, Aug 29, 2013 at 10:00 AM, Kermit W. Prather <kermitp@tampabay.rr.com
> wrote:
> Well I'm not really sure. I need the Class= from each table row. In
> addition to grabbing the table. ****
>
referring to the "Ratio" column:
=smfWord(D4,
On Thu, Aug 29, 2013 at 10:00 AM, Kermit W. Prather <kermitp@tampabay.
> wrote:
> Well I'm not really sure. I need the Class= from each table row. In
> addition to grabbing the table. ****
>
Thu Aug 29, 2013 10:34 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
You totally lost me there. I am not familiar with the smfWord function. I looked thru the doc and can't find a any mention of it.
I'm not sure what else is needed to put it all together.
Where is smfWord documented?
I want to download the complete table and then calculate the shares because the number of rows varies from stock to stock. Some stocks have no splits (AGNC)
so there is not table.
Just a text message at top of page. I can retrieve with
=smfGetTagContent("http://getsplithistory.com/ "&A1,"div",0,"splits-text";)
this returns
<b>International Business Machines Corp.</b> has had <b>7</b> splits.
Where the 7 tell me there has been 7 splits so there will be 7 rows in the table.
Some stock will have more Walmart has 9 splits.
So I need the table to be expandable.
My real problem is I can't figure out how to download the table.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Thursday, August 29, 2013 1:06 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Need help with this webpage
Why not just compute it yourself, from the data in the table. For example, referring to the "Ratio" column:
=smfWord(D4,1,":") / smfWord(D4,2,":")
On Thu, Aug 29, 2013 at 10:00 AM, Kermit W. Prather <kermitp@tampabay.rr.com > wrote:
Well I'm not really sure. I need the Class= from each table row. In addition to grabbing the table.
I'm not sure what else is needed to put it all together.
Where is smfWord documented?
I want to download the complete table and then calculate the shares because the number of rows varies from stock to stock. Some stocks have no splits (AGNC)
so there is not table.
Just a text message at top of page. I can retrieve with
=smfGetTagContent(
this returns
<b>Internatio
Where the 7 tell me there has been 7 splits so there will be 7 rows in the table.
Some stock will have more Walmart has 9 splits.
So I need the table to be expandable.
My real problem is I can't figure out how to download the table.
From: smf_addin@yahoogrou
Sent: Thursday, August 29, 2013 1:06 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Need help with this webpage
Why not just compute it yourself, from the data in the table. For example, referring to the "Ratio" column:
=smfWord(D4,
On Thu, Aug 29, 2013 at 10:00 AM, Kermit W. Prather <kermitp@tampabay.
Well I'm not really sure. I need the Class= from each table row. In addition to grabbing the table.
Tidak ada komentar:
Posting Komentar