15 New Messages
Digest #2636
Messages
Wed May 29, 2013 5:32 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
while trying to extract the information from the is, bs and cf of WSJ from this company,
http://quotes.wsj.com/SG/XSES/O23
i have experienced some problems while extracting certain data
i used this format =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/income-statement",0,"Sales Growth")
the errors are when i key in the words in the columns to replace ''Sales Growth''
1) under http://quotes.wsj.com/SG/XSES/O23/financials/annual/income-statement
a) Depreciation shows me an empty space
b) Net Income shows ''ERROR"
c) Discontinued Operation shows ''ERROR''
2) under http://quotes.wsj.com/SG/XSES/O23/financials/annual/balance-sheet
a) under accumulated depreciation section, the words ''Buildings'', ''Lands & Improvement'', ''Machinery & Equipment'', ''Computer Software and Equipment'', ''Transportation Equipment'' and ''Other Property, Plant & Equipment'' produces repeated results as the one at Property, Plant & Equipment - Gross above accumulated depreciation
b) Total Assets shows me an ''ERROR''
c) Convertible Debt Shows me a replicated answer of ''Non-Convertible Debt''
d) Deferred Income shows me a replicated answer of ''Other Liabilities (excl. Deferred Income)
e) Liabilities & Shareholders' Equity shows me ''NA''
3) under http://quotes.wsj.com/SG/XSES/O23/financials/annual/cash-flow
a) Investment Tax Credit shows a replicated answer of ''Deferred Taxes & Investment Tax Credit''
b) Extraordinaries shows me the repeated result of ''Net Income Before Extraordinaries''
is there any solution for the problems above?
thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Just normal EXCEL concatenation -- this is just one string:
>
> "http://quotes.wsj.com/ID/XIDX/=A1/financials/annual/income-statement "
>
> You need to concatenate three strings:
>
> "http://quotes.wsj.com/ID/XIDX/ "
> A1
> "/financials/annual/income-statement"
>
> So:
>
> "http://quotes.wsj.com/ID/XIDX/ " & A1 &
> "/financials/annual/income-statement"
>
> On Mon, May 27, 2013 at 8:10 PM, sri yanto <sri.yanto@...> wrote:
>
> > hai randy - sory bothering you again :D
> >
> > i have founnd, that i compared have Reuters and FT.com with WSJ, WSJ is
> > the best data provider, over accuracy and data update.
> >
> > but i have trouble here.
> >
> > i am using rchgettable here :
> >
> > =RCHGetTableCell("
> > http://quotes.wsj.com/ID/XIDX/UNTR/financials/annual/income-statement
> > ",1,"Sales/Revenue")
> >
> > but the questian is, how to make it become refreshable link for other
> > ticker.
> > i tried to make formula but return "error", here the formula :
> >
> > =RCHGetTableCell("
> > http://quotes.wsj.com/ID/XIDX/=A1/financials/annual/income-statement
> > ",1,"Sales/Revenue")
> >
> > "=A1" refers to ticker i want to put ( UNTR)
> >
>
while trying to extract the information from the is, bs and cf of WSJ from this company,
http://quotes.
i have experienced some problems while extracting certain data
i used this format =RCHGetTableCell(
the errors are when i key in the words in the columns to replace ''Sales Growth'&#
1) under http://quotes.
a) Depreciation shows me an empty space
b) Net Income shows ''ERROR&quo
c) Discontinued Operation shows ''ERROR&#
2) under http://quotes.
a) under accumulated depreciation section, the words ''Buildings
b) Total Assets shows me an ''ERROR&#
c) Convertible Debt Shows me a replicated answer of ''Non-
d) Deferred Income shows me a replicated answer of ''Other Liabilities (excl. Deferred Income)
e) Liabilities & Shareholders&#
3) under http://quotes.
a) Investment Tax Credit shows a replicated answer of ''Deferred Taxes & Investment Tax Credit'&#
b) Extraordinaries shows me the repeated result of ''Net Income Before Extraordinaries&#
is there any solution for the problems above?
thanks!
--- In smf_addin@yahoogrou
>
> Just normal EXCEL concatenation -- this is just one string:
>
> "http://quotes.
>
> You need to concatenate three strings:
>
> "http://quotes.
> A1
> "/financials/
>
> So:
>
> "http://quotes.
> "/financials/
>
> On Mon, May 27, 2013 at 8:10 PM, sri yanto <sri.yanto@
>
> > hai randy - sory bothering you again :D
> >
> > i have founnd, that i compared have Reuters and FT.com with WSJ, WSJ is
> > the best data provider, over accuracy and data update.
> >
> > but i have trouble here.
> >
> > i am using rchgettable here :
> >
> > =RCHGetTableCell(
> > http://quotes.
> > ",1,"
> >
> > but the questian is, how to make it become refreshable link for other
> > ticker.
> > i tried to make formula but return "error"
> >
> > =RCHGetTableCell(
> > http://quotes.
> > ",1,"
> >
> > "=A1" refers to ticker i want to put ( UNTR)
> >
>
Wed May 29, 2013 8:47 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Have you looked up those strings in the source code of the web page to see
if they will get you positioned where you need to be? If they show up
before the table, they will not extract the data you want.
Extraction of the data is dependent upon using good (and hopefully unique)
search terms. So any time you use an ordinary phrase, you are in danger of
ending up in the wrong location.
On Wed, May 29, 2013 at 5:31 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> while trying to extract the information from the is, bs and cf of WSJ from
> this company,
>
> http://quotes.wsj.com/SG/XSES/O23
>
> i have experienced some problems while extracting certain data
>
> i used this format =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/income-statement",0,"Sales
> Growth")
>
> the errors are when i key in the words in the columns to replace ''Sales
> Growth''
>
> 1) under
> http://quotes.wsj.com/SG/XSES/O23/financials/annual/income-statement
>
> a) Depreciation shows me an empty space
> b) Net Income shows ''ERROR"
> c) Discontinued Operation shows ''ERROR''
>
> 2) under http://quotes.wsj.com/SG/XSES/O23/financials/annual/balance-sheet
>
> a) under accumulated depreciation section, the words ''Buildings'',
> ''Lands & Improvement'', ''Machinery & Equipment'', ''Computer Software and
> Equipment'', ''Transportation Equipment'' and ''Other Property, Plant &
> Equipment'' produces repeated results as the one at Property, Plant &
> Equipment - Gross above accumulated depreciation
>
> b) Total Assets shows me an ''ERROR''
>
> c) Convertible Debt Shows me a replicated answer of ''Non-Convertible
> Debt''
>
> d) Deferred Income shows me a replicated answer of ''Other Liabilities
> (excl. Deferred Income)
>
> e) Liabilities & Shareholders' Equity shows me ''NA''
>
> 3) under http://quotes.wsj.com/SG/XSES/O23/financials/annual/cash-flow
>
> a) Investment Tax Credit shows a replicated answer of ''Deferred Taxes &
> Investment Tax Credit''
>
> b) Extraordinaries shows me the repeated result of ''Net Income Before
> Extraordinaries''
>
> is there any solution for the problems above?
>
if they will get you positioned where you need to be? If they show up
before the table, they will not extract the data you want.
Extraction of the data is dependent upon using good (and hopefully unique)
search terms. So any time you use an ordinary phrase, you are in danger of
ending up in the wrong location.
On Wed, May 29, 2013 at 5:31 AM, weekeewawa <weekeewawa@yahoo.
>
> while trying to extract the information from the is, bs and cf of WSJ from
> this company,
>
> http://quotes.
>
> i have experienced some problems while extracting certain data
>
> i used this format =RCHGetTableCell(
> Growth"
>
> the errors are when i key in the words in the columns to replace ''Sales
> Growth'&#
>
> 1) under
> http://quotes.
>
> a) Depreciation shows me an empty space
> b) Net Income shows ''ERROR&quo
> c) Discontinued Operation shows ''ERROR&#
>
> 2) under http://quotes.
>
> a) under accumulated depreciation section, the words ''Buildings
> ''Lands & Improvement&#
> Equipment'
> Equipment'
> Equipment - Gross above accumulated depreciation
>
> b) Total Assets shows me an ''ERROR&#
>
> c) Convertible Debt Shows me a replicated answer of ''Non-
> Debt''
>
> d) Deferred Income shows me a replicated answer of ''Other Liabilities
> (excl. Deferred Income)
>
> e) Liabilities & Shareholders&#
>
> 3) under http://quotes.
>
> a) Investment Tax Credit shows a replicated answer of ''Deferred Taxes &
> Investment Tax Credit'&#
>
> b) Extraordinaries shows me the repeated result of ''Net Income Before
> Extraordinaries&#
>
> is there any solution for the problems above?
>
Wed May 29, 2013 9:08 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
yup, I look into the source file and trial and error thru the examination excel shit and at the same time tried to reposition it via the number but i just cant hit the magic spot for the errors and problems i mentioned
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Have you looked up those strings in the source code of the web page to see
> if they will get you positioned where you need to be? If they show up
> before the table, they will not extract the data you want.
>
> Extraction of the data is dependent upon using good (and hopefully unique)
> search terms. So any time you use an ordinary phrase, you are in danger of
> ending up in the wrong location.
>
> On Wed, May 29, 2013 at 5:31 AM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > while trying to extract the information from the is, bs and cf of WSJ from
> > this company,
> >
> > http://quotes.wsj.com/SG/XSES/O23
> >
> > i have experienced some problems while extracting certain data
> >
> > i used this format =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/income-statement",0,"Sales
> > Growth")
> >
> > the errors are when i key in the words in the columns to replace ''Sales
> > Growth''
> >
> > 1) under
> > http://quotes.wsj.com/SG/XSES/O23/financials/annual/income-statement
> >
> > a) Depreciation shows me an empty space
> > b) Net Income shows ''ERROR"
> > c) Discontinued Operation shows ''ERROR''
> >
> > 2) under http://quotes.wsj.com/SG/XSES/O23/financials/annual/balance-sheet
> >
> > a) under accumulated depreciation section, the words ''Buildings'',
> > ''Lands & Improvement'', ''Machinery & Equipment'', ''Computer Software and
> > Equipment'', ''Transportation Equipment'' and ''Other Property, Plant &
> > Equipment'' produces repeated results as the one at Property, Plant &
> > Equipment - Gross above accumulated depreciation
> >
> > b) Total Assets shows me an ''ERROR''
> >
> > c) Convertible Debt Shows me a replicated answer of ''Non-Convertible
> > Debt''
> >
> > d) Deferred Income shows me a replicated answer of ''Other Liabilities
> > (excl. Deferred Income)
> >
> > e) Liabilities & Shareholders' Equity shows me ''NA''
> >
> > 3) under http://quotes.wsj.com/SG/XSES/O23/financials/annual/cash-flow
> >
> > a) Investment Tax Credit shows a replicated answer of ''Deferred Taxes &
> > Investment Tax Credit''
> >
> > b) Extraordinaries shows me the repeated result of ''Net Income Before
> > Extraordinaries''
> >
> > is there any solution for the problems above?
> >
>
yup, I look into the source file and trial and error thru the examination excel shit and at the same time tried to reposition it via the number but i just cant hit the magic spot for the errors and problems i mentioned
--- In smf_addin@yahoogrou
>
> Have you looked up those strings in the source code of the web page to see
> if they will get you positioned where you need to be? If they show up
> before the table, they will not extract the data you want.
>
> Extraction of the data is dependent upon using good (and hopefully unique)
> search terms. So any time you use an ordinary phrase, you are in danger of
> ending up in the wrong location.
>
> On Wed, May 29, 2013 at 5:31 AM, weekeewawa <weekeewawa@
>
> >
> > while trying to extract the information from the is, bs and cf of WSJ from
> > this company,
> >
> > http://quotes.
> >
> > i have experienced some problems while extracting certain data
> >
> > i used this format =RCHGetTableCell(
> > Growth"
> >
> > the errors are when i key in the words in the columns to replace ''Sales
> > Growth'&#
> >
> > 1) under
> > http://quotes.
> >
> > a) Depreciation shows me an empty space
> > b) Net Income shows ''ERROR&quo
> > c) Discontinued Operation shows ''ERROR&#
> >
> > 2) under http://quotes.
> >
> > a) under accumulated depreciation section, the words ''Buildings
> > ''Lands & Improvement&#
> > Equipment'
> > Equipment'
> > Equipment - Gross above accumulated depreciation
> >
> > b) Total Assets shows me an ''ERROR&#
> >
> > c) Convertible Debt Shows me a replicated answer of ''Non-
> > Debt''
> >
> > d) Deferred Income shows me a replicated answer of ''Other Liabilities
> > (excl. Deferred Income)
> >
> > e) Liabilities & Shareholders&#
> >
> > 3) under http://quotes.
> >
> > a) Investment Tax Credit shows a replicated answer of ''Deferred Taxes &
> > Investment Tax Credit'&#
> >
> > b) Extraordinaries shows me the repeated result of ''Net Income Before
> > Extraordinaries&#
> >
> > is there any solution for the problems above?
> >
>
Wed May 29, 2013 3:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Well, give me the exact formulas you used for each that got you the errors
you mention. Otherwise, I'm starting from scratch. And you've got so many.
On Wed, May 29, 2013 at 9:08 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> yup, I look into the source file and trial and error thru the examination
> excel shit and at the same time tried to reposition it via the number but i
> just cant hit the magic spot for the errors and problems i mentioned
>
you mention. Otherwise, I'm starting from scratch. And you've got so many.
On Wed, May 29, 2013 at 9:08 AM, weekeewawa <weekeewawa@yahoo.
>
> yup, I look into the source file and trial and error thru the examination
> excel shit and at the same time tried to reposition it via the number but i
> just cant hit the magic spot for the errors and problems i mentioned
>
Wed May 29, 2013 7:13 am (PDT) . Posted by:
"flangeneral" flangeneral
Anyone else having problems with Yahoo reporting ETF's and Index funds? Specifically:
CDZ.TO iShares S&P TSX CDN Dividend Index Fund
ZSP.TO BMO S&P 500 Index ETF
Both return a previous close of N/A when using
{=RCHGetYahooQuotes( G5:G25,A2:E2,,NOW()}
Where G5:G25 is my symbols range
A2:E2 is (in this case) p
CDZ.TO iShares S&P TSX CDN Dividend Index Fund
ZSP.TO BMO S&P 500 Index ETF
Both return a previous close of N/A when using
{=RCHGetYahooQuotes
Where G5:G25 is my symbols range
A2:E2 is (in this case) p
Wed May 29, 2013 8:08 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you ever see "N/A", that means it is what Yahoo is posting for the
values. The add-in doesn't generate "N/A" values, it just passes them along.
Hopefully, a temporary issue, since someone mentioned a similar issue on
another equity.
On Wed, May 29, 2013 at 7:13 AM, flangeneral <jefff@rogers.com > wrote:
> Anyone else having problems with Yahoo reporting ETF's and Index funds?
> Specifically:
>
> CDZ.TO iShares S&P TSX CDN Dividend Index Fund
> ZSP.TO BMO S&P 500 Index ETF
>
> Both return a previous close of N/A when using
> {=RCHGetYahooQuotes( G5:G25,A2:E2,,NOW()}
>
> Where G5:G25 is my symbols range
> A2:E2 is (in this case) p
>
values. The add-in doesn't generate "N/A" values, it just passes them along.
Hopefully, a temporary issue, since someone mentioned a similar issue on
another equity.
On Wed, May 29, 2013 at 7:13 AM, flangeneral <jefff@rogers.
> Anyone else having problems with Yahoo reporting ETF's and Index funds?
> Specifically:
>
> CDZ.TO iShares S&P TSX CDN Dividend Index Fund
> ZSP.TO BMO S&P 500 Index ETF
>
> Both return a previous close of N/A when using
> {=RCHGetYahooQuotes
>
> Where G5:G25 is my symbols range
> A2:E2 is (in this case) p
>
Wed May 29, 2013 8:32 am (PDT) . Posted by:
"flangeneral" flangeneral
Thanks Randy,
I realize it is Yahoo posting the value of N/A, thats why I asked if others were having problems with Yahoo. I could not get proper values all day yesterday for those two symbols, and could not even call them up on their website. The problem continued this morning, but checked again about ten minutes ago, and is now seemingly reporting properly to my spreadsheet. Still cannot lookup those symbols on their website, however.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> If you ever see "N/A", that means it is what Yahoo is posting for the
> values. The add-in doesn't generate "N/A" values, it just passes them along.
>
> Hopefully, a temporary issue, since someone mentioned a similar issue on
> another equity.
>
> On Wed, May 29, 2013 at 7:13 AM, flangeneral <jefff@...> wrote:
>
> > Anyone else having problems with Yahoo reporting ETF's and Index funds?
> > Specifically:
> >
> > CDZ.TO iShares S&P TSX CDN Dividend Index Fund
> > ZSP.TO BMO S&P 500 Index ETF
> >
> > Both return a previous close of N/A when using
> > {=RCHGetYahooQuotes( G5:G25,A2:E2,,NOW()}
> >
> > Where G5:G25 is my symbols range
> > A2:E2 is (in this case) p
> >
>
I realize it is Yahoo posting the value of N/A, thats why I asked if others were having problems with Yahoo. I could not get proper values all day yesterday for those two symbols, and could not even call them up on their website. The problem continued this morning, but checked again about ten minutes ago, and is now seemingly reporting properly to my spreadsheet. Still cannot lookup those symbols on their website, however.
--- In smf_addin@yahoogrou
>
> If you ever see "N/A"
> values. The add-in doesn't generate "N/A" values, it just passes them along.
>
> Hopefully, a temporary issue, since someone mentioned a similar issue on
> another equity.
>
> On Wed, May 29, 2013 at 7:13 AM, flangeneral <jefff@..
>
> > Anyone else having problems with Yahoo reporting ETF's and Index funds?
> > Specifically:
> >
> > CDZ.TO iShares S&P TSX CDN Dividend Index Fund
> > ZSP.TO BMO S&P 500 Index ETF
> >
> > Both return a previous close of N/A when using
> > {=RCHGetYahooQuotes
> >
> > Where G5:G25 is my symbols range
> > A2:E2 is (in this case) p
> >
>
Wed May 29, 2013 11:58 am (PDT) . Posted by:
"flangeneral" flangeneral
......and now Yahoo has stopped posting values for these again.
--- In smf_addin@yahoogroups.com , "flangeneral" <jefff@...> wrote:
>
> Thanks Randy,
> I realize it is Yahoo posting the value of N/A, thats why I asked if others were having problems with Yahoo. I could not get proper values all day yesterday for those two symbols, and could not even call them up on their website. The problem continued this morning, but checked again about ten minutes ago, and is now seemingly reporting properly to my spreadsheet. Still cannot lookup those symbols on their website, however.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > If you ever see "N/A", that means it is what Yahoo is posting for the
> > values. The add-in doesn't generate "N/A" values, it just passes them along.
> >
> > Hopefully, a temporary issue, since someone mentioned a similar issue on
> > another equity.
> >
> > On Wed, May 29, 2013 at 7:13 AM, flangeneral <jefff@> wrote:
> >
> > > Anyone else having problems with Yahoo reporting ETF's and Index funds?
> > > Specifically:
> > >
> > > CDZ.TO iShares S&P TSX CDN Dividend Index Fund
> > > ZSP.TO BMO S&P 500 Index ETF
> > >
> > > Both return a previous close of N/A when using
> > > {=RCHGetYahooQuotes( G5:G25,A2:E2,,NOW()}
> > >
> > > Where G5:G25 is my symbols range
> > > A2:E2 is (in this case) p
> > >
> >
>
--- In smf_addin@yahoogrou
>
> Thanks Randy,
> I realize it is Yahoo posting the value of N/A, thats why I asked if others were having problems with Yahoo. I could not get proper values all day yesterday for those two symbols, and could not even call them up on their website. The problem continued this morning, but checked again about ten minutes ago, and is now seemingly reporting properly to my spreadsheet. Still cannot lookup those symbols on their website, however.
>
> --- In smf_addin@yahoogrou
> >
> > If you ever see "N/A"
> > values. The add-in doesn't generate "N/A" values, it just passes them along.
> >
> > Hopefully, a temporary issue, since someone mentioned a similar issue on
> > another equity.
> >
> > On Wed, May 29, 2013 at 7:13 AM, flangeneral <jefff@> wrote:
> >
> > > Anyone else having problems with Yahoo reporting ETF's and Index funds?
> > > Specifically:
> > >
> > > CDZ.TO iShares S&P TSX CDN Dividend Index Fund
> > > ZSP.TO BMO S&P 500 Index ETF
> > >
> > > Both return a previous close of N/A when using
> > > {=RCHGetYahooQuotes
> > >
> > > Where G5:G25 is my symbols range
> > > A2:E2 is (in this case) p
> > >
> >
>
Wed May 29, 2013 8:05 am (PDT) . Posted by:
"albertalbert7869" albertalbert7869
Hi All,
I ve installed latest version of add-in posted here. I tested it and its working fine too. Now I need some help whith a french fund like Amplégest Multicaps AC (FR0010375600.PA), I can't extract the Last Trade.
http://finance.yahoo.com/q?s=FR0010375600.PA&ql=1
Thanks in advance.
Regards
I ve installed latest version of add-in posted here. I tested it and its working fine too. Now I need some help whith a french fund like Amplégest Multicaps AC (FR0010375600.
http://finance.
Thanks in advance.
Regards
Wed May 29, 2013 8:07 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's a Yahoo issue. Click on the "Download Data" button on the web page
you cited. It shows all "N/A" fields, so Yahoo isn't populating the CSV
file data items.
On Wed, May 29, 2013 at 6:37 AM, albertalbert7869 <
albertalbert7869@yahoo.com > wrote:
>
> I ve installed latest version of add-in posted here. I tested it and its
> working fine too. Now I need some help whith a french fund like Amplégest
> Multicaps AC (FR0010375600.PA), I can't extract the Last Trade.
>
> http://finance.yahoo.com/q?s=FR0010375600.PA&ql=1
>
>
you cited. It shows all "N/A" fields, so Yahoo isn't populating the CSV
file data items.
On Wed, May 29, 2013 at 6:37 AM, albertalbert7869 <
albertalbert7869@
>
> I ve installed latest version of add-in posted here. I tested it and its
> working fine too. Now I need some help whith a french fund like Amplégest
> Multicaps AC (FR0010375600.
>
> http://finance.
>
>
Wed May 29, 2013 8:35 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
yes i did tried it
but when i create the url string independently, it seems ok. but when i started to combine, i either missed out a concatenation symbol before or either after, i guess i neeed even more practice
but regarding the problem, it works well!
thanks randy
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You need a concatenation symbol AFTER the A1 as well.
>
> As I said, you should try creating the URL string independent of the
> formula first, until you're more experienced and more comfortable doing
> concatenations.
>
> When I entered your formula, EXCEL pointed me directly to where the problem
> was.
>
> On Tue, May 28, 2013 at 10:07 AM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > tried to extract balance sheet from
> >
> >
> > http://investing.businessweek.com/research/stocks/financials/financials.asp?ticker=IBM&dataset=balanceSheet&period=A ¤cy=native
> >
> > with this code
> >
> > =RCHGetHTMLTable("
> > http://investing.businessweek.com/research/stocks/financials/financials.asp?ticker=IBM&dataset=balanceSheet&period=A ¤cy=native","US
> > Dollars",-1,"",1)
> >
> > and it works
> >
> > but when i tried to point to cell A1 with this code
> >
> > =RCHGetHTMLTable("
> > http://investing.businessweek.com/research/stocks/financials/financials.asp?ticker= "&A1"&dataset=balanceSheet&period=A¤cy=native","US
> > Dollars",-1,"",1)
> >
> > something wrong with it?
> >
>
yes i did tried it
but when i create the url string independently, it seems ok. but when i started to combine, i either missed out a concatenation symbol before or either after, i guess i neeed even more practice
but regarding the problem, it works well!
thanks randy
--- In smf_addin@yahoogrou
>
> You need a concatenation symbol AFTER the A1 as well.
>
> As I said, you should try creating the URL string independent of the
> formula first, until you're more experienced and more comfortable doing
> concatenations.
>
> When I entered your formula, EXCEL pointed me directly to where the problem
> was.
>
> On Tue, May 28, 2013 at 10:07 AM, weekeewawa <weekeewawa@
>
> >
> > tried to extract balance sheet from
> >
> >
> > http://investing.
> >
> > with this code
> >
> > =RCHGetHTMLTable(
> > http://investing.
> > Dollars"
> >
> > and it works
> >
> > but when i tried to point to cell A1 with this code
> >
> > =RCHGetHTMLTable(
> > http://investing.
> > Dollars"
> >
> > something wrong with it?
> >
>
Wed May 29, 2013 2:00 pm (PDT) . Posted by:
"Seth Wu" sewuzy
Thank you, for your guidance.
I figured it out.
You are great.
Seth
I figured it out.
You are great.
Seth
Wed May 29, 2013 2:20 pm (PDT) . Posted by:
"terminal3screensdesk" terminal3screensdesk
Randy,
Thank you very much for making all these tools available.
I have not been able to successfully use the smfGetOptionQuotes() function. Regardless of the formula I enter, "#NAME" is returned.
For example, when I entered =smfGetYahooOptionQuote("SPY","C",(2013,6,1),160,"b") "#NAME" was returned.
I looked at the documentation files to try to find a solution and didn't find anything there. I understand that "#NAME" means that the link is unresolved and made sure the links have the RCH_Stock_Market_Functions.xla source.
I also searched for similar questions and didn't find anything that answered the specific problem I am having.
Please let me know how I can fix this problem.
Thank you for your help!
Thank you very much for making all these tools available.
I have not been able to successfully use the smfGetOptionQuotes(
For example, when I entered =smfGetYahooOptionQ
I looked at the documentation files to try to find a solution and didn't find anything there. I understand that "#NAME" means that the link is unresolved and made sure the links have the RCH_Stock_Market_
I also searched for similar questions and didn't find anything that answered the specific problem I am having.
Please let me know how I can fix this problem.
Thank you for your help!
Wed May 29, 2013 3:08 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
What you list below can't be what you entered. The "(2013,6,1)" gets
flagged by EXCEL as a formula error, which it is. This worked fine for me:
=smfGetYahooOptionQuote("SPY","C",DATE(2013,6,22),160,"b")
However, if you enter that into your spreadsheet and get a #NAME! error,
the most likely reason is that the add-in isn't installed properly, or that
you have an earlier version of the add-in that doesn't have that function
in it.
What do you get with:
=RCHGetElementNumber("Version")
On Wed, May 29, 2013 at 1:19 PM, terminal3screensdesk
<lsbenedict@gmail.com >wrote:
>
> I have not been able to successfully use the smfGetOptionQuotes()
> function. Regardless of the formula I enter, "#NAME" is returned.
>
> For example, when I entered
> =smfGetYahooOptionQuote("SPY","C",(2013,6,1),160,"b") "#NAME" was returned.
>
> I looked at the documentation files to try to find a solution and didn't
> find anything there. I understand that "#NAME" means that the link is
> unresolved and made sure the links have the RCH_Stock_Market_Functions.xla
> source.
>
> I also searched for similar questions and didn't find anything that
> answered the specific problem I am having.
>
> Please let me know how I can fix this problem.
>
flagged by EXCEL as a formula error, which it is. This worked fine for me:
=smfGetYahooOptionQ
However, if you enter that into your spreadsheet and get a #NAME! error,
the most likely reason is that the add-in isn't installed properly, or that
you have an earlier version of the add-in that doesn't have that function
in it.
What do you get with:
=RCHGetElementNumbe
On Wed, May 29, 2013 at 1:19 PM, terminal3screensdes
<lsbenedict@gmail.
>
> I have not been able to successfully use the smfGetOptionQuotes(
> function. Regardless of the formula I enter, "#NAME" is returned.
>
> For example, when I entered
> =smfGetYahooOptionQ
>
> I looked at the documentation files to try to find a solution and didn't
> find anything there. I understand that "#NAME" means that the link is
> unresolved and made sure the links have the RCH_Stock_Market_
> source.
>
> I also searched for similar questions and didn't find anything that
> answered the specific problem I am having.
>
> Please let me know how I can fix this problem.
>
Wed May 29, 2013 6:08 pm (PDT) . Posted by:
"Randy H" rharmelink
For those of you interested in The Motley Fool CAPS Ratings, it appears
they are working again:
MMM Value Description Formula 5 Caps Rating
=smfConvertData(smfStrExtr(smfGetTagContent("http://caps.fool.com/Ticker\
/ "&$E$4&".aspx","div",-1,"Rating:"),"/stars/trans/","stars-trans";))
4427 Players Outperforms
=smfConvertData(smfGetTagContent("http://caps.fool.com/Ticker/ "&$E$4&".a\
spx","span",1,">All Players")) 155 Players Underperforms
=smfConvertData(smfGetTagContent("http://caps.fool.com/Ticker/ "&$E$4&".a\
spx","span",3,">All Players")) 1331 All-Stars Outperforms
=smfConvertData(smfGetTagContent("http://caps.fool.com/Ticker/ "&$E$4&".a\
spx","span",1,">All-Star Players")) 17 All-Stars Underperforms
=smfConvertData(smfGetTagContent("http://caps.fool.com/Ticker/ "&$E$4&".a\
spx","span",3,">All-Star Players")) 27 Wall Street Outperforms
=smfConvertData(smfGetTagContent("http://caps.fool.com/Ticker/ "&$E$4&".a\
spx","span",1,">Wall Street")) 0 Wall Street Underperforms
=smfConvertData(smfGetTagContent("http://caps.fool.com/Ticker/ "&$E$4&".a\
spx","span",3,">Wall Street"))
they are working again:
MMM Value Description Formula 5 Caps Rating
=smfConvertData(
/
4427 Players Outperforms
=smfConvertData(
spx","
=smfConvertData(
spx","
=smfConvertData(
spx","
=smfConvertData(
spx","
=smfConvertData(
spx","
=smfConvertData(
spx","
Tidak ada komentar:
Posting Komentar