5 New Messages
Digest #2637
2a
Re: Last Trade with Amplégest Multicaps AC (FR0010375600.PA) by "albertalbert7869" albertalbert7869
Messages
Wed May 29, 2013 7:24 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
sure thing.. lets start with the first post i sent
1) under http://quotes.wsj.com/SG/XSES/O23/financials/annual/income-statement
a) Depreciation shows me an empty space
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/income-statement",0,"Depreciation")
b) Net Income shows ''ERROR"
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/income-statement",0,"Net Income")
c) Discontinued Operation shows ''ERROR''
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/income-statement",0,"Discontinued Operation")
2) under http://quotes.wsj.com/SG/XSES/O23/financials/annual/balance-sheet
a) under accumulated depreciation section, the words
''Buildings'',
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Buildings")
''Lands & Improvement'',
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Land & Improvements")
''Machinery & Equipment'',
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Machinery & Equipment")
''Computer Software and Equipment'',
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Computer Software And Equipment")
''Transportation Equipment'',
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Transportation Equipment")
''Other Property, Plant & Equipment''
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"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''
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Total Assets")
c) Convertible Debt Shows me a replicated answer of ''Non-Convertible Debt''
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Non-Convertible Debt")
d) Deferred Income shows me a replicated answer of ''Other Liabilities (excl.
Deferred Income)
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Deferred Income")
e) Liabilities & Shareholders' Equity shows me ''NA''
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Liabilities & Shareholders' Equity")
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''
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/cash-flow",0,"Investment Tax Credit")
b) Extraordinaries shows me the repeated result of ''Net Income Before
Extraordinaries''
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/cash-flow",0,"Extraordinaries")
thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> 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
> >
>
sure thing.. lets start with the first post i sent
1) under http://quotes.
a) Depreciation shows me an empty space
=RCHGetTableCell(
b) Net Income shows ''ERROR&quo
=RCHGetTableCell(
c) Discontinued Operation shows ''ERROR&#
=RCHGetTableCell(
2) under http://quotes.
a) under accumulated depreciation section, the words
''Buildings
=RCHGetTableCell(
''Lands & Improvement&#
=RCHGetTableCell(
''Machinery & Equipment'
=RCHGetTableCell(
''Computer Software and Equipment'
=RCHGetTableCell(
''Transport
=RCHGetTableCell(
''Other Property, Plant & Equipment'
=RCHGetTableCell(
produces
repeated results as the one at Property, Plant & Equipment - Gross above
accumulated depreciation
b) Total Assets shows me an ''ERROR&#
=RCHGetTableCell(
c) Convertible Debt Shows me a replicated answer of ''Non-
=RCHGetTableCell(
d) Deferred Income shows me a replicated answer of ''Other Liabilities (excl.
Deferred Income)
=RCHGetTableCell(
e) Liabilities & Shareholders&#
=RCHGetTableCell(
3) under http://quotes.
a) Investment Tax Credit shows a replicated answer of ''Deferred Taxes &
Investment Tax Credit'&#
=RCHGetTableCell(
b) Extraordinaries shows me the repeated result of ''Net Income Before
Extraordinaries&#
=RCHGetTableCell(
thanks
--- In smf_addin@yahoogrou
>
> 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@
>
> >
> > 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:53 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
OK.
1a -- when you look at the source code of the web page, where is the first
place you find the string "depreciation"? Blank is the proper thing to
return.
1b, 1c -- work for me: "Consolidated Net Income" and "Extraordinaries &
Discontinued Operations"
2a -- I don't understand the issue. Everything seems to work fine for both
of us.
2b -- works for me: "Cash & ST Investments / Total Assets"
2c,2d -- is working for both of us. I don't know what you expect them to
return, other than the first occurrence of the string. That's the way the
function works. You position it and tell it which item to retrieve.
2e - "Liabilities & Shareholders' Equity" is not within a table cell, so
you got the last table cell of the previous table.
3a, 3b -- Again, the formula is just going to position itself based on the
first occurrence of your search string. If that isn't what you want, you
need to use additional search strings to position yourself properly within
a table. That's why I will often use the technique of:
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/cash-flow",0,">Investment
Tax Credit")
...provided that is correct for the way the web page has been coded. It may
not be.
But if strings are on the page multiple times and you want a later
occurrence, you either need to use multiple search strings to position
yourself correctly (e.g. first search string may be a unique header in
front of the table), or find a way to make your search string unique (e.g.
using the ">" prefix, if applicable).
On Wed, May 29, 2013 at 7:24 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
> hello randy,
>
> sure thing.. lets start with the first post i sent
>
>
> 1) under
> http://quotes.wsj.com/SG/XSES/O23/financials/annual/income-statement
>
> a) Depreciation shows me an empty space
> =RCHGetTableCell("http://quotes.wsj.com/
> "&A1&"/financials/annual/income-statement",0,"Depreciation")
> b) Net Income shows ''ERROR"
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/income-statement",0,"Net
> Income")
> c) Discontinued Operation shows ''ERROR''
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/income-statement",0,"Discontinued
> Operation")
>
>
> 2) under http://quotes.wsj.com/SG/XSES/O23/financials/annual/balance-sheet
>
> a) under accumulated depreciation section, the words
> ''Buildings'',
> =RCHGetTableCell("http://quotes.wsj.com/
> "&A1&"/financials/annual/balance-sheet",0,"Buildings")
> ''Lands & Improvement'',
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Land
> & Improvements")
> ''Machinery & Equipment'',
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Machinery
> & Equipment")
> ''Computer Software and Equipment'',
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Computer
> Software And Equipment")
> ''Transportation Equipment'',
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Transportation
> Equipment")
> ''Other Property, Plant & Equipment''
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"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''
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Total
> Assets")
>
> c) Convertible Debt Shows me a replicated answer of ''Non-Convertible
> Debt''
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Non-Convertible
> Debt")
>
> d) Deferred Income shows me a replicated answer of ''Other Liabilities
> (excl.
> Deferred Income)
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Deferred
> Income")
>
> e) Liabilities & Shareholders' Equity shows me ''NA''
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Liabilities
> & Shareholders' Equity")
>
> 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''
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/cash-flow",0,"Investment
> Tax Credit")
>
> b) Extraordinaries shows me the repeated result of ''Net Income Before
> Extraordinaries''
> =RCHGetTableCell("http://quotes.wsj.com/
> "&A1&"/financials/annual/cash-flow",0,"Extraordinaries")
>
>
1a -- when you look at the source code of the web page, where is the first
place you find the string "depreciation&
return.
1b, 1c -- work for me: "Consolidated Net Income" and "Extraordinari
Discontinued Operations"
2a -- I don't understand the issue. Everything seems to work fine for both
of us.
2b -- works for me: "Cash & ST Investments / Total Assets"
2c,2d -- is working for both of us. I don't know what you expect them to
return, other than the first occurrence of the string. That's the way the
function works. You position it and tell it which item to retrieve.
2e - "Liabilities & Shareholders&#
you got the last table cell of the previous table.
3a, 3b -- Again, the formula is just going to position itself based on the
first occurrence of your search string. If that isn't what you want, you
need to use additional search strings to position yourself properly within
a table. That's why I will often use the technique of:
=RCHGetTableCell(
Tax Credit"
...provided that is correct for the way the web page has been coded. It may
not be.
But if strings are on the page multiple times and you want a later
occurrence, you either need to use multiple search strings to position
yourself correctly (e.g. first search string may be a unique header in
front of the table), or find a way to make your search string unique (e.g.
using the ">" prefix, if applicable).
On Wed, May 29, 2013 at 7:24 PM, weekeewawa <weekeewawa@yahoo.
> hello randy,
>
> sure thing.. lets start with the first post i sent
>
>
> 1) under
> http://quotes.
>
> a) Depreciation shows me an empty space
> =RCHGetTableCell(
> "&A1&"
> b) Net Income shows ''ERROR&quo
> =RCHGetTableCell(
> Income"
> c) Discontinued Operation shows ''ERROR&#
> =RCHGetTableCell(
> Operation"
>
>
> 2) under http://quotes.
>
> a) under accumulated depreciation section, the words
> ''Buildings
> =RCHGetTableCell(
> "&A1&"
> ''Lands & Improvement&#
> =RCHGetTableCell(
> & Improvements"
> ''Machinery & Equipment'
> =RCHGetTableCell(
> & Equipment"
> ''Computer Software and Equipment'
> =RCHGetTableCell(
> Software And Equipment"
> ''Transport
> =RCHGetTableCell(
> Equipment"
> ''Other Property, Plant & Equipment'
> =RCHGetTableCell(
> Property, Plant & Equipment"
> produces
> repeated results as the one at Property, Plant & Equipment - Gross above
> accumulated depreciation
>
> b) Total Assets shows me an ''ERROR&#
> =RCHGetTableCell(
> Assets"
>
> c) Convertible Debt Shows me a replicated answer of ''Non-
> Debt''
> =RCHGetTableCell(
> Debt")
>
> d) Deferred Income shows me a replicated answer of ''Other Liabilities
> (excl.
> Deferred Income)
> =RCHGetTableCell(
> Income"
>
> e) Liabilities & Shareholders&#
> =RCHGetTableCell(
> & Shareholders&#
>
> 3) under http://quotes.
>
> a) Investment Tax Credit shows a replicated answer of ''Deferred Taxes &
> Investment Tax Credit'&#
> =RCHGetTableCell(
> Tax Credit"
>
> b) Extraordinaries shows me the repeated result of ''Net Income Before
> Extraordinaries&#
> =RCHGetTableCell(
> "&A1&"
>
>
Wed May 29, 2013 10:31 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy
http://quotes.wsj.com/SG/XSES/O23/financials/annual/income-statement
1a) under Depreciation line
Depreciation 12,767.0 11,530.0 10,047.0 10,958.0 10,525.0
thats the source code that i see. <td class="rowTitle">Depreciation</td> and would like to extract this row. but it just gives me ERROR
1b) the problem lies in this row
Net Income (99,436.0) 23,334.0 50,069.0 69,063.0 86,925.0
where the code i keyed
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/income-statement",0,"Net Income")
gives me ''Consolidated Net Income'' Instead of ''Net Income''
1c) the problem lies in
Discontinued Operations - 0.0 0.0 0.0 0.0
where the code i keyed
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/income-statement",0,"Discontinued Operations")
gives me ''Extraordinaries & Discontinued Operations'' insteaad of ''Discontinued Operation''
--
http://quotes.wsj.com/SG/XSES/O23/financials/annual/balance-sheet
2a) as u can see from below
Property, Plant & Equipment - Gross 85,703.0 83,389.0 79,969.0 86,940.0 89,167.0
Buildings 1,400.0 1,400.0 1,400.0 1,326.0 1,294.0
Land & Improvements 3,246.0 3,246.0 3,246.0 3,214.0 3,140.0
Machinery & Equipment 10,019.0 10,103.0 10,302.0 10,443.0 10,646.0
Leases 5,750.0 2,602.0 363.0 372.0 364.0
Computer Software and Equipment 8,946.0 9,431.0 9,828.0 9,050.0 9,337.0
Transportation Equipment 3,082.0 2,506.0 2,558.0 2,897.0 3,217.0
Other Property, Plant & Equipment 53,260.0 54,101.0 52,272.0 59,638.0 61,169.0
Accumulated Depreciation 56,234.0 63,834.0 61,334.0 67,068.0 68,110.0
Buildings 135.0 162.0 189.0 188.0 209.0
Land & Improvements 30.0 30.0 30.0 53.0 52.0
Machinery & Equipment 6,765.0 7,889.0 9,046.0 10,146.0 10,273.0
Computer Software and Equipment 7,646.0 8,321.0 8,858.0 7,783.0 8,171.0
Transportation Equipment 2,084.0 2,006.0 2,034.0 2,080.0 1,975.0
Other Property, Plant & Equipment 37,991.0 43,922.0 40,942.0 46,580.0 47,191.0
the Property, Plant & Equipment - Gross and Accumulated Depreciation are different category but beneath both of it, the sub category is the same. the codes that i mentioned only extract the data from
Property, Plant & Equipment - Gross 85,703.0 83,389.0 79,969.0 86,940.0 89,167.0
Buildings 1,400.0 1,400.0 1,400.0 1,326.0 1,294.0
Land & Improvements 3,246.0 3,246.0 3,246.0 3,214.0 3,140.0
Machinery & Equipment 10,019.0 10,103.0 10,302.0 10,443.0 10,646.0
Leases 5,750.0 2,602.0 363.0 372.0 364.0
Computer Software and Equipment 8,946.0 9,431.0 9,828.0 9,050.0 9,337.0
Transportation Equipment 3,082.0 2,506.0 2,558.0 2,897.0 3,217.0
Other Property, Plant & Equipment 53,260.0 54,101.0 52,272.0 59,638.0 61,169.0
and not from the ''accumulated depreciation'''s buildings, land & improvements, machinery & equipment, computer software and equipment, transportation equipment and other property, plant and equppment.
Accumulated Depreciation 56,234.0 63,834.0 61,334.0 67,068.0 68,110.0
Buildings 135.0 162.0 189.0 188.0 209.0
Land & Improvements 30.0 30.0 30.0 53.0 52.0
Machinery & Equipment 6,765.0 7,889.0 9,046.0 10,146.0 10,273.0
Computer Software and Equipment 7,646.0 8,321.0 8,858.0 7,783.0 8,171.0
Transportation Equipment 2,084.0 2,006.0 2,034.0 2,080.0 1,975.0
Other Property, Plant & Equipment 37,991.0 43,922.0 40,942.0 46,580.0 47,191.0
thats where the problems lies. what is the code to differentiate the data of the accumulated depreciation sub category and the Property, Plant & Equipment - Gross sub category.
2b) under this
Total Assets 213,463.0 230,722.0 239,162.0 431,076.0 470,905.0
using this code =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Total Assets")
gives me a result of ''Cash & ST Investments / Total Assets'' instead of ''Total Assets''
2c) under this
Convertible Debt 0.0 0.0 0.0 3,773.0 3,773.0
using this code =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Convertible Debt")
gives me a result of ''Non-Covertible Debt'' instead of ''Convertible Debt''
2d) under this
Deferred Income 0.0 0.0 0.0 0.0 0.
using this code =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Deferred Income")
gives me a result of ''Other Liabilities (excl. Deferred Income)'' instead of ''Deferred Income''
for 3a and 3b,
can u provide some example in a form of the codes?
I have come across similar problems numerous times and i remembered once u gave me the > trick
but for this case
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/cash-flow",0,"Investment Tax Credit>")
gives me an error
so is there any codes for the Extraordinaries and Investment Tax Credit?
thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> OK.
>
> 1a -- when you look at the source code of the web page, where is the first
> place you find the string "depreciation"? Blank is the proper thing to
> return.
>
> 1b, 1c -- work for me: "Consolidated Net Income" and "Extraordinaries &
> Discontinued Operations"
>
> 2a -- I don't understand the issue. Everything seems to work fine for both
> of us.
>
> 2b -- works for me: "Cash & ST Investments / Total Assets"
>
> 2c,2d -- is working for both of us. I don't know what you expect them to
> return, other than the first occurrence of the string. That's the way the
> function works. You position it and tell it which item to retrieve.
>
> 2e - "Liabilities & Shareholders' Equity" is not within a table cell, so
> you got the last table cell of the previous table.
>
> 3a, 3b -- Again, the formula is just going to position itself based on the
> first occurrence of your search string. If that isn't what you want, you
> need to use additional search strings to position yourself properly within
> a table. That's why I will often use the technique of:
>
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/cash-flow",0,">Investment
> Tax Credit")
>
> ...provided that is correct for the way the web page has been coded. It may
> not be.
>
> But if strings are on the page multiple times and you want a later
> occurrence, you either need to use multiple search strings to position
> yourself correctly (e.g. first search string may be a unique header in
> front of the table), or find a way to make your search string unique (e.g.
> using the ">" prefix, if applicable).
>
> On Wed, May 29, 2013 at 7:24 PM, weekeewawa <weekeewawa@...> wrote:
>
> > hello randy,
> >
> > sure thing.. lets start with the first post i sent
> >
> >
> > 1) under
> > http://quotes.wsj.com/SG/XSES/O23/financials/annual/income-statement
> >
> > a) Depreciation shows me an empty space
> > =RCHGetTableCell("http://quotes.wsj.com/
> > "&A1&"/financials/annual/income-statement",0,"Depreciation")
> > b) Net Income shows ''ERROR"
> > =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/income-statement",0,"Net
> > Income")
> > c) Discontinued Operation shows ''ERROR''
> > =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/income-statement",0,"Discontinued
> > Operation")
> >
> >
> > 2) under http://quotes.wsj.com/SG/XSES/O23/financials/annual/balance-sheet
> >
> > a) under accumulated depreciation section, the words
> > ''Buildings'',
> > =RCHGetTableCell("http://quotes.wsj.com/
> > "&A1&"/financials/annual/balance-sheet",0,"Buildings")
> > ''Lands & Improvement'',
> > =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Land
> > & Improvements")
> > ''Machinery & Equipment'',
> > =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Machinery
> > & Equipment")
> > ''Computer Software and Equipment'',
> > =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Computer
> > Software And Equipment")
> > ''Transportation Equipment'',
> > =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Transportation
> > Equipment")
> > ''Other Property, Plant & Equipment''
> > =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"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''
> > =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Total
> > Assets")
> >
> > c) Convertible Debt Shows me a replicated answer of ''Non-Convertible
> > Debt''
> > =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Non-Convertible
> > Debt")
> >
> > d) Deferred Income shows me a replicated answer of ''Other Liabilities
> > (excl.
> > Deferred Income)
> > =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Deferred
> > Income")
> >
> > e) Liabilities & Shareholders' Equity shows me ''NA''
> > =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/balance-sheet",0,"Liabilities
> > & Shareholders' Equity")
> >
> > 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''
> > =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/cash-flow",0,"Investment
> > Tax Credit")
> >
> > b) Extraordinaries shows me the repeated result of ''Net Income Before
> > Extraordinaries''
> > =RCHGetTableCell("http://quotes.wsj.com/
> > "&A1&"/financials/annual/cash-flow",0,"Extraordinaries")
> >
> >
>
http://quotes.
1a) under Depreciation line
Depreciation 12,767.0 11,530.0 10,047.0 10,958.0 10,525.0
thats the source code that i see. <td class="
1b) the problem lies in this row
Net Income (99,436.0) 23,334.0 50,069.0 69,063.0 86,925.0
where the code i keyed
=RCHGetTableCell(
gives me ''Consolida
1c) the problem lies in
Discontinued Operations - 0.0 0.0 0.0 0.0
where the code i keyed
=RCHGetTableCell(
gives me ''Extraordi
--
http://quotes.
2a) as u can see from below
Property, Plant & Equipment - Gross 85,703.0 83,389.0 79,969.0 86,940.0 89,167.0
Buildings 1,400.0 1,400.0 1,400.0 1,326.0 1,294.0
Land & Improvements 3,246.0 3,246.0 3,246.0 3,214.0 3,140.0
Machinery & Equipment 10,019.0 10,103.0 10,302.0 10,443.0 10,646.0
Leases 5,750.0 2,602.0 363.0 372.0 364.0
Computer Software and Equipment 8,946.0 9,431.0 9,828.0 9,050.0 9,337.0
Transportation Equipment 3,082.0 2,506.0 2,558.0 2,897.0 3,217.0
Other Property, Plant & Equipment 53,260.0 54,101.0 52,272.0 59,638.0 61,169.0
Accumulated Depreciation 56,234.0 63,834.0 61,334.0 67,068.0 68,110.0
Buildings 135.0 162.0 189.0 188.0 209.0
Land & Improvements 30.0 30.0 30.0 53.0 52.0
Machinery & Equipment 6,765.0 7,889.0 9,046.0 10,146.0 10,273.0
Computer Software and Equipment 7,646.0 8,321.0 8,858.0 7,783.0 8,171.0
Transportation Equipment 2,084.0 2,006.0 2,034.0 2,080.0 1,975.0
Other Property, Plant & Equipment 37,991.0 43,922.0 40,942.0 46,580.0 47,191.0
the Property, Plant & Equipment - Gross and Accumulated Depreciation are different category but beneath both of it, the sub category is the same. the codes that i mentioned only extract the data from
Property, Plant & Equipment - Gross 85,703.0 83,389.0 79,969.0 86,940.0 89,167.0
Buildings 1,400.0 1,400.0 1,400.0 1,326.0 1,294.0
Land & Improvements 3,246.0 3,246.0 3,246.0 3,214.0 3,140.0
Machinery & Equipment 10,019.0 10,103.0 10,302.0 10,443.0 10,646.0
Leases 5,750.0 2,602.0 363.0 372.0 364.0
Computer Software and Equipment 8,946.0 9,431.0 9,828.0 9,050.0 9,337.0
Transportation Equipment 3,082.0 2,506.0 2,558.0 2,897.0 3,217.0
Other Property, Plant & Equipment 53,260.0 54,101.0 52,272.0 59,638.0 61,169.0
and not from the ''accumulat
Accumulated Depreciation 56,234.0 63,834.0 61,334.0 67,068.0 68,110.0
Buildings 135.0 162.0 189.0 188.0 209.0
Land & Improvements 30.0 30.0 30.0 53.0 52.0
Machinery & Equipment 6,765.0 7,889.0 9,046.0 10,146.0 10,273.0
Computer Software and Equipment 7,646.0 8,321.0 8,858.0 7,783.0 8,171.0
Transportation Equipment 2,084.0 2,006.0 2,034.0 2,080.0 1,975.0
Other Property, Plant & Equipment 37,991.0 43,922.0 40,942.0 46,580.0 47,191.0
thats where the problems lies. what is the code to differentiate the data of the accumulated depreciation sub category and the Property, Plant & Equipment - Gross sub category.
2b) under this
Total Assets 213,463.0 230,722.0 239,162.0 431,076.0 470,905.0
using this code =RCHGetTableCell(
gives me a result of ''Cash & ST Investments / Total Assets'&#
2c) under this
Convertible Debt 0.0 0.0 0.0 3,773.0 3,773.0
using this code =RCHGetTableCell(
gives me a result of ''Non-
2d) under this
Deferred Income 0.0 0.0 0.0 0.0 0.
using this code =RCHGetTableCell(
gives me a result of ''Other Liabilities (excl. Deferred Income)'
for 3a and 3b,
can u provide some example in a form of the codes?
I have come across similar problems numerous times and i remembered once u gave me the > trick
but for this case
=RCHGetTableCell(
gives me an error
so is there any codes for the Extraordinaries and Investment Tax Credit?
thanks!
--- In smf_addin@yahoogrou
>
> OK.
>
> 1a -- when you look at the source code of the web page, where is the first
> place you find the string "depreciation&
> return.
>
> 1b, 1c -- work for me: "Consolidated Net Income" and "Extraordinari
> Discontinued Operations"
>
> 2a -- I don't understand the issue. Everything seems to work fine for both
> of us.
>
> 2b -- works for me: "Cash & ST Investments / Total Assets"
>
> 2c,2d -- is working for both of us. I don't know what you expect them to
> return, other than the first occurrence of the string. That's the way the
> function works. You position it and tell it which item to retrieve.
>
> 2e - "Liabilities & Shareholders&#
> you got the last table cell of the previous table.
>
> 3a, 3b -- Again, the formula is just going to position itself based on the
> first occurrence of your search string. If that isn't what you want, you
> need to use additional search strings to position yourself properly within
> a table. That's why I will often use the technique of:
>
> =RCHGetTableCell(
> Tax Credit"
>
> ...provided that is correct for the way the web page has been coded. It may
> not be.
>
> But if strings are on the page multiple times and you want a later
> occurrence, you either need to use multiple search strings to position
> yourself correctly (e.g. first search string may be a unique header in
> front of the table), or find a way to make your search string unique (e.g.
> using the ">" prefix, if applicable).
>
> On Wed, May 29, 2013 at 7:24 PM, weekeewawa <weekeewawa@
>
> > hello randy,
> >
> > sure thing.. lets start with the first post i sent
> >
> >
> > 1) under
> > http://quotes.
> >
> > a) Depreciation shows me an empty space
> > =RCHGetTableCell(
> > "&A1&"
> > b) Net Income shows ''ERROR&quo
> > =RCHGetTableCell(
> > Income"
> > c) Discontinued Operation shows ''ERROR&#
> > =RCHGetTableCell(
> > Operation"
> >
> >
> > 2) under http://quotes.
> >
> > a) under accumulated depreciation section, the words
> > ''Buildings
> > =RCHGetTableCell(
> > "&A1&"
> > ''Lands & Improvement&#
> > =RCHGetTableCell(
> > & Improvements"
> > ''Machinery & Equipment'
> > =RCHGetTableCell(
> > & Equipment"
> > ''Computer Software and Equipment'
> > =RCHGetTableCell(
> > Software And Equipment"
> > ''Transport
> > =RCHGetTableCell(
> > Equipment"
> > ''Other Property, Plant & Equipment'
> > =RCHGetTableCell(
> > Property, Plant & Equipment"
> > produces
> > repeated results as the one at Property, Plant & Equipment - Gross above
> > accumulated depreciation
> >
> > b) Total Assets shows me an ''ERROR&#
> > =RCHGetTableCell(
> > Assets"
> >
> > c) Convertible Debt Shows me a replicated answer of ''Non-
> > Debt''
> > =RCHGetTableCell(
> > Debt")
> >
> > d) Deferred Income shows me a replicated answer of ''Other Liabilities
> > (excl.
> > Deferred Income)
> > =RCHGetTableCell(
> > Income"
> >
> > e) Liabilities & Shareholders&#
> > =RCHGetTableCell(
> > & Shareholders&#
> >
> > 3) under http://quotes.
> >
> > a) Investment Tax Credit shows a replicated answer of ''Deferred Taxes &
> > Investment Tax Credit'&#
> > =RCHGetTableCell(
> > Tax Credit"
> >
> > b) Extraordinaries shows me the repeated result of ''Net Income Before
> > Extraordinaries&#
> > =RCHGetTableCell(
> > "&A1&"
> >
> >
>
Thu May 30, 2013 3:37 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
On Wed, May 29, 2013 at 10:31 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> http://quotes.wsj.com/SG/XSES/O23/financials/annual/income-statement
>
> 1a) under Depreciation line
>
> Depreciation 12,767.0 11,530.0 10,047.0 10,958.0
> 10,525.0
>
> thats the source code that i see. <td class="rowTitle">Depreciation</td>
> and would like to extract this row. but it just gives me ERROR
>
Your formula doesn't give me an error:
=RCHGetTableCell("http://quotes.wsj.com/
"&A1&"/financials/annual/income-statement",0,"Depreciation")
But it doesn't go to that line, because that is not the first
"Depreciation" string on the web page. Just looking at what you have listed
there, what might make it unique? How about:
=RCHGetTableCell("http://quotes.wsj.com/
"&A1&"/financials/annual/income-statement",0,">Depreciation")
1b) the problem lies in this row
>
> Net Income (99,436.0) 23,334.0 50,069.0 69,063.0
> 86,925.0
>
> where the code i keyed
>
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/income-statement",0,"Net
> Income")
>
> gives me ''Consolidated Net Income'' Instead of ''Net Income''
>
Yup. So how can you make your search string unique? Or what search string
can you look for first, so that you are past the "Consolidated Net Income"
string, before looking for "Net Income"?
You could even just look for the second occurrence of "Net Income":
=RCHGetTableCell("http://quotes.wsj.com/
"&A1&"/financials/annual/income-statement",
0,"Net Income","Net Income")
1c) the problem lies in
>
> Discontinued Operations - 0.0 0.0 0.0 0.0
>
> where the code i keyed
>
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/income-statement",0,"Discontinued
> Operations")
>
> gives me ''Extraordinaries & Discontinued Operations'' insteaad of
> ''Discontinued Operation''
>
Right. See the comments on the previous two problems. Unique, or more
search strings.
> http://quotes.wsj.com/SG/XSES/O23/financials/annual/balance-sheet
>
> 2a) as u can see from below
>
>
Again, you either need a unique search string, or use multiple search
strings to position yourself properly.
can u provide some example in a form of the codes?
> I have come across similar problems numerous times and i remembered once u
> gave me the > trick
> but for this case
>
> =RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/cash-flow",0,"Investment
> Tax Credit>")
>
> gives me an error
>
> so is there any codes for the Extraordinaries and Investment Tax Credit?
>
Wrong location of HTML code. It needs to match what is in the HTML source
code:
=RCHGetTableCell("http://quotes.wsj.com/ "&A1&"/financials/annual/cash-flow",0,">Investment
Tax Credit")
Or, to find the second occurrence:
=RCHGetTableCell("http://quotes.wsj.com/
"&$A$1&"/financials/annual/cash-flow",
0,"Investment Tax Credit","Investment Tax Credit")
All of your issues relate to non-unique search strings. I've given you two
examples above, that you should be able to apply to all the others.
>
> http://quotes.
>
> 1a) under Depreciation line
>
> Depreciation 12,767.0 11,530.0 10,047.0 10,958.0
> 10,525.0
>
> thats the source code that i see. <td class="
> and would like to extract this row. but it just gives me ERROR
>
Your formula doesn't give me an error:
=RCHGetTableCell(
"&A1&"
But it doesn't go to that line, because that is not the first
"Depreciation&
there, what might make it unique? How about:
=RCHGetTableCell(
"&A1&"
1b) the problem lies in this row
>
> Net Income (99,436.0) 23,334.0 50,069.0 69,063.0
> 86,925.0
>
> where the code i keyed
>
> =RCHGetTableCell(
> Income"
>
> gives me ''Consolida
>
Yup. So how can you make your search string unique? Or what search string
can you look for first, so that you are past the "Consolidated Net Income"
string, before looking for "Net Income"
You could even just look for the second occurrence of "Net Income"
=RCHGetTableCell(
"&A1&"
0,"Net Income"
1c) the problem lies in
>
> Discontinued Operations - 0.0 0.0 0.0 0.0
>
> where the code i keyed
>
> =RCHGetTableCell(
> Operations"
>
> gives me ''Extraordi
> ''Discontin
>
Right. See the comments on the previous two problems. Unique, or more
search strings.
> http://quotes.
>
> 2a) as u can see from below
>
>
Again, you either need a unique search string, or use multiple search
strings to position yourself properly.
can u provide some example in a form of the codes?
> I have come across similar problems numerous times and i remembered once u
> gave me the > trick
> but for this case
>
> =RCHGetTableCell(
> Tax Credit>"
>
> gives me an error
>
> so is there any codes for the Extraordinaries and Investment Tax Credit?
>
Wrong location of HTML code. It needs to match what is in the HTML source
code:
=RCHGetTableCell(
Tax Credit"
Or, to find the second occurrence:
=RCHGetTableCell(
"&$A$1&"
0,"Investment Tax Credit"
All of your issues relate to non-unique search strings. I've given you two
examples above, that you should be able to apply to all the others.
Thu May 30, 2013 12:39 am (PDT) . Posted by:
"albertalbert7869" albertalbert7869
It's true, thank a lot
--- In smf_addin@yahoogrou
>
> 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@
>
> >
> > 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.
> >
> >
>
Tidak ada komentar:
Posting Komentar