12 New Messages
Digest #2330
| |
Messages
Wed Aug 29, 2012 9:15 am (PDT) . Posted by:
"indinvestor111" indinvestor111
This is a very powerful add-in. Thanks for sharing!
I'm having a problem when accessing the Adv FN financial statements.
My my function is: =smfGetAdvFNElement
I've copied the line items I want displayed directly from the website. The problem arises in the "depreciation" line in the CFO section. When using the above function, it displays cost of goods with depreciation. When I use ">depreciation<
Thanks
Wed Aug 29, 2012 9:26 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's because depreciation is in numerous line items on the web page. You'll
need to use multiple search terms to get to the right one. For example, the
elements are defined as such:
=smfGetADVFNElement("IBM", "A",1,">INCOME STATEMENT",">Depreciation<")
=smfGetADVFNElement("IBM", "A",1,">CASH-FLOW STATEMENT",">Depreciation<")
...so that it will pick up the correct one.
On Wed, Aug 29, 2012 at 9:06 AM, indinvestor111 <elandry@bmlcapital.com >wrote:
>
> I'm having a problem when accessing the Adv FN financial statements.
>
> My my function is: =smfGetAdvFNElement(ticker, "A",M$3,$A158), where M$3
> is the number cell reference, and $a158 references the line item I'm
> interested in displaying (i.e. sales, COGS, accts payable, etc).
>
> I've copied the line items I want displayed directly from the website. The
> problem arises in the "depreciation" line in the CFO section. When using
> the above function, it displays cost of goods with depreciation. When I use
> ">depreciation<" in place of the $A158 reference, it displays the net of
> depreciation and amortization. Not sure what is happening here. Any ideas?
>
need to use multiple search terms to get to the right one. For example, the
elements are defined as such:
=smfGetADVFNElement
=smfGetADVFNElement
...so that it will pick up the correct one.
On Wed, Aug 29, 2012 at 9:06 AM, indinvestor111 <elandry@bmlcapital.
>
> I'm having a problem when accessing the Adv FN financial statements.
>
> My my function is: =smfGetAdvFNElement
> is the number cell reference, and $a158 references the line item I'm
> interested in displaying (i.e. sales, COGS, accts payable, etc).
>
> I've copied the line items I want displayed directly from the website. The
> problem arises in the "depreciation" line in the CFO section. When using
> the above function, it displays cost of goods with depreciation. When I use
> ">depreciation<
> depreciation and amortization. Not sure what is happening here. Any ideas?
>
Wed Aug 29, 2012 9:57 am (PDT) . Posted by:
"indinvestor111" indinvestor111
That worked well with Depr and Amort! Thanks. I'm still getting an error message for the "purchase of short-term investments" line, however.
Also, do you know if there's a way to toggle between original and restated statements? Seems all of the data sources report original, but not restated data.
Thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It's because depreciation is in numerous line items on the web page. You'll
> need to use multiple search terms to get to the right one. For example, the
> elements are defined as such:
>
> =smfGetADVFNElement("IBM", "A",1,">INCOME STATEMENT",">Depreciation<")
> =smfGetADVFNElement("IBM", "A",1,">CASH-FLOW STATEMENT",">Depreciation<")
>
> ...so that it will pick up the correct one.
>
> On Wed, Aug 29, 2012 at 9:06 AM, indinvestor111 <elandry@...>wrote:
>
> >
> > I'm having a problem when accessing the Adv FN financial statements.
> >
> > My my function is: =smfGetAdvFNElement(ticker, "A",M$3,$A158), where M$3
> > is the number cell reference, and $a158 references the line item I'm
> > interested in displaying (i.e. sales, COGS, accts payable, etc).
> >
> > I've copied the line items I want displayed directly from the website. The
> > problem arises in the "depreciation" line in the CFO section. When using
> > the above function, it displays cost of goods with depreciation. When I use
> > ">depreciation<" in place of the $A158 reference, it displays the net of
> > depreciation and amortization. Not sure what is happening here. Any ideas?
> >
>
Also, do you know if there's a way to toggle between original and restated statements? Seems all of the data sources report original, but not restated data.
Thanks
--- In smf_addin@yahoogrou
>
> It's because depreciation is in numerous line items on the web page. You'll
> need to use multiple search terms to get to the right one. For example, the
> elements are defined as such:
>
> =smfGetADVFNElement
> =smfGetADVFNElement
>
> ...so that it will pick up the correct one.
>
> On Wed, Aug 29, 2012 at 9:06 AM, indinvestor111 <elandry@...
>
> >
> > I'm having a problem when accessing the Adv FN financial statements.
> >
> > My my function is: =smfGetAdvFNElement
> > is the number cell reference, and $a158 references the line item I'm
> > interested in displaying (i.e. sales, COGS, accts payable, etc).
> >
> > I've copied the line items I want displayed directly from the website. The
> > problem arises in the "depreciation" line in the CFO section. When using
> > the above function, it displays cost of goods with depreciation. When I use
> > ">depreciation<
> > depreciation and amortization. Not sure what is happening here. Any ideas?
> >
>
Wed Aug 29, 2012 10:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Can you give me the exact formula, including ticker symbol?
I don't know of any way to toggle original vs restarted.
On Wed, Aug 29, 2012 at 9:57 AM, indinvestor111 <elandry@bmlcapital.com >wrote:
> That worked well with Depr and Amort! Thanks. I'm still getting an error
> message for the "purchase of short-term investments" line, however.
>
> Also, do you know if there's a way to toggle between original and restated
> statements? Seems all of the data sources report original, but not restated
> data.
>
I don't know of any way to toggle original vs restarted.
On Wed, Aug 29, 2012 at 9:57 AM, indinvestor111 <elandry@bmlcapital.
> That worked well with Depr and Amort! Thanks. I'm still getting an error
> message for the "purchase of short-term investments" line, however.
>
> Also, do you know if there's a way to toggle between original and restated
> statements? Seems all of the data sources report original, but not restated
> data.
>
Wed Aug 29, 2012 2:24 pm (PDT) . Posted by:
"indinvestor111" indinvestor111
Hi Randy,
Perhaps "toggle" was a poor word. What I meant was is there a resource that you're aware of that quotes restated data in prior years when, for instance, a company restates prior-year financials when it puts a business into discontinued operations. So far, I've just seen originally-reported data in prior years when there's a restatement.
No worries.
--- In smf_addin@yahoogrou
>
> Can you give me the exact formula, including ticker symbol?
>
> I don't know of any way to toggle original vs restarted.
>
> On Wed, Aug 29, 2012 at 9:57 AM, indinvestor111 <elandry@...
>
> > That worked well with Depr and Amort! Thanks. I'm still getting an error
> > message for the "purchase of short-term investments" line, however.
> >
> > Also, do you know if there's a way to toggle between original and restated
> > statements? Seems all of the data sources report original, but not restated
> > data.
> >
>
Wed Aug 29, 2012 3:23 pm (PDT) . Posted by:
"indinvestor111" indinvestor111
Hi Again,
Can the user define the search further? There's a problem when two accounts on one statement use similiar discriptions. For instance, the function can't distinguish balance-sheet accounts like current deferred taxes and non-current deferred taxes.
Anything I can do to combat this?
Thanks
--- In smf_addin@yahoogroups.com , "indinvestor111" <elandry@...> wrote:
>
>
> Hi Randy,
>
> Perhaps "toggle" was a poor word. What I meant was is there a resource that you're aware of that quotes restated data in prior years when, for instance, a company restates prior-year financials when it puts a business into discontinued operations. So far, I've just seen originally-reported data in prior years when there's a restatement.
>
> No worries.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Can you give me the exact formula, including ticker symbol?
> >
> > I don't know of any way to toggle original vs restarted.
> >
> > On Wed, Aug 29, 2012 at 9:57 AM, indinvestor111 <elandry@>wrote:
> >
> > > That worked well with Depr and Amort! Thanks. I'm still getting an error
> > > message for the "purchase of short-term investments" line, however.
> > >
> > > Also, do you know if there's a way to toggle between original and restated
> > > statements? Seems all of the data sources report original, but not restated
> > > data.
> > >
> >
>
Can the user define the search further? There's a problem when two accounts on one statement use similiar discriptions. For instance, the function can't distinguish balance-sheet accounts like current deferred taxes and non-current deferred taxes.
Anything I can do to combat this?
Thanks
--- In smf_addin@yahoogrou
>
>
> Hi Randy,
>
> Perhaps "toggle" was a poor word. What I meant was is there a resource that you're aware of that quotes restated data in prior years when, for instance, a company restates prior-year financials when it puts a business into discontinued operations. So far, I've just seen originally-reported data in prior years when there's a restatement.
>
> No worries.
>
> --- In smf_addin@yahoogrou
> >
> > Can you give me the exact formula, including ticker symbol?
> >
> > I don't know of any way to toggle original vs restarted.
> >
> > On Wed, Aug 29, 2012 at 9:57 AM, indinvestor111 <elandry@>wrote:
> >
> > > That worked well with Depr and Amort! Thanks. I'm still getting an error
> > > message for the "purchase of short-term investments" line, however.
> > >
> > > Also, do you know if there's a way to toggle between original and restated
> > > statements? Seems all of the data sources report original, but not restated
> > > data.
> > >
> >
>
Wed Aug 29, 2012 3:58 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Check the documentation for the function -- you can use up to four search
strings to position for the extraction...
On Wed, Aug 29, 2012 at 3:23 PM, indinvestor111 <elandry@bmlcapital.com >wrote:
>
> Can the user define the search further? There's a problem when two
> accounts on one statement use similiar discriptions. For instance, the
> function can't distinguish balance-sheet accounts like current deferred
> taxes and non-current deferred taxes.
>
> Anything I can do to combat this?
>
strings to position for the extraction..
On Wed, Aug 29, 2012 at 3:23 PM, indinvestor111 <elandry@bmlcapital.
>
> Can the user define the search further? There's a problem when two
> accounts on one statement use similiar discriptions. For instance, the
> function can't distinguish balance-sheet accounts like current deferred
> taxes and non-current deferred taxes.
>
> Anything I can do to combat this?
>
Wed Aug 29, 2012 2:05 pm (PDT) . Posted by:
"mercurio89" mercurio89
Hi guys! I would like to start with thanking you all for the great work!!! It is very impressive!!! I found two problems:
1. All MSN functions don't work.
2. the barchart function for the price change and the price % change does not give the same value as the website. Why?
I have excel 2010 and all other functions work pretty grteat!! so i think there's something wrong with those two. Let me know. Thank you for your time.
1. All MSN functions don't work.
2. the barchart function for the price change and the price % change does not give the same value as the website. Why?
I have excel 2010 and all other functions work pretty grteat!! so i think there's something wrong with those two. Let me know. Thank you for your time.
Wed Aug 29, 2012 2:07 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
For MSN, see: http://finance.groups.yahoo.com/group/smf_addin/message/19709
For BarChart, some specific examples of what you're referring to?
On Wed, Aug 29, 2012 at 1:28 PM, mercurio89 <mercurio89@yahoo.it > wrote:
>
> 1. All MSN functions don't work.
> 2. the barchart function for the price change and the price % change does
> not give the same value as the website. Why?
>
> I have excel 2010 and all other functions work pretty grteat!! so i think
> there's something wrong with those two.
>
For BarChart, some specific examples of what you're referring to?
On Wed, Aug 29, 2012 at 1:28 PM, mercurio89 <mercurio89@yahoo.
>
> 1. All MSN functions don't work.
> 2. the barchart function for the price change and the price % change does
> not give the same value as the website. Why?
>
> I have excel 2010 and all other functions work pretty grteat!! so i think
> there's something wrong with those two.
>
Thu Aug 30, 2012 4:08 am (PDT) . Posted by:
"mercurio89" mercurio89
Thank you for your answers!
Now I'll give you an example on the barchart functions problem. If you type this function =RCHGetElementNumber("GM";1218)you should get the Price change of GM in the last 5 days. But if you check on the barchart website the numbers are different, do you know why? The same thing happens for the functions 1223, 1228, 1233, 1238, 1243.
In addition this morning I found out another thing. When I use the function =RCHGetElementNumber("RSG";3506) it gives me error. I found out that this problem concerns speicifc stocks and the google functions, do you know why? i give you the list of the stocks concerned:
CF
FAST
A
CI
NTAP
CERN
CHK
SYMC
HCN
KSS
CA
MAR
NUE
ETR
PXD
KR
MAT
PH
PAYX
STJ
PGR
NU
ALTR
ADI
EW
CBE
JWN
AMP
HUM
FTI
MTB
SWK
CPB
DLTR
NTRS
WDC
HST
RHT
ZMH
HOT
SWN
WU
IVZ
DOV
WPI
WYNN
MNST
RRC
CAG
PRGO
ORLY
ROK
SNDK
MUR
DTE
ROP
RSG
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> For MSN, see: http://finance.groups.yahoo.com/group/smf_addin/message/19709
>
> For BarChart, some specific examples of what you're referring to?
>
> On Wed, Aug 29, 2012 at 1:28 PM, mercurio89 <mercurio89@...> wrote:
>
> >
> > 1. All MSN functions don't work.
> > 2. the barchart function for the price change and the price % change does
> > not give the same value as the website. Why?
> >
> > I have excel 2010 and all other functions work pretty grteat!! so i think
> > there's something wrong with those two.
> >
>
Now I'll give you an example on the barchart functions problem. If you type this function =RCHGetElementNumbe
In addition this morning I found out another thing. When I use the function =RCHGetElementNumbe
CF
FAST
A
CI
NTAP
CERN
CHK
SYMC
HCN
KSS
CA
MAR
NUE
ETR
PXD
KR
MAT
PH
PAYX
STJ
PGR
NU
ALTR
ADI
EW
CBE
JWN
AMP
HUM
FTI
MTB
SWK
CPB
DLTR
NTRS
WDC
HST
RHT
ZMH
HOT
SWN
WU
IVZ
DOV
WPI
WYNN
MNST
RRC
CAG
PRGO
ORLY
ROK
SNDK
MUR
DTE
ROP
RSG
--- In smf_addin@yahoogrou
>
> For MSN, see: http://finance.
>
> For BarChart, some specific examples of what you're referring to?
>
> On Wed, Aug 29, 2012 at 1:28 PM, mercurio89 <mercurio89@
>
> >
> > 1. All MSN functions don't work.
> > 2. the barchart function for the price change and the price % change does
> > not give the same value as the website. Why?
> >
> > I have excel 2010 and all other functions work pretty grteat!! so i think
> > there's something wrong with those two.
> >
>
Wed Aug 29, 2012 10:57 pm (PDT) . Posted by:
"barclaywood@ymail.com" barclaywood@ymail.com
Hi all, I'm using RCHGetTableCell to download ex-div dates. Everything is fine, except I can't find a site that will download in my preferred format (dd-mmm). I am getting data in dd-mmm-yy format (e.g., 29-Aug-12). It's a nit picky thing, but I would REALLY like to be able to format the cells to excise that year information.
After I download the data, I am copying and pasting values only (that way the workbook opens faster). But every attempt I make to format the cell or cells is futile - the data stays in exactly the form it was originally.
Any help? Thanks!
After I download the data, I am copying and pasting values only (that way the workbook opens faster). But every attempt I make to format the cell or cells is futile - the data stays in exactly the form it was originally.
Any help? Thanks!
Wed Aug 29, 2012 11:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you can't format the dates, it's because what's in the cell is a string.
You'd need to convert that string into an EXCEL serial date value before it
can be formatted as a date. Check out EXCEL's DATEVALUE() function.
On Wed, Aug 29, 2012 at 10:29 PM, barclaywood@ymail.com <
barclaywood@ymail.com > wrote:
> Hi all, I'm using RCHGetTableCell to download ex-div dates. Everything is
> fine, except I can't find a site that will download in my preferred format
> (dd-mmm). I am getting data in dd-mmm-yy format (e.g., 29-Aug-12). It's a
> nit picky thing, but I would REALLY like to be able to format the cells to
> excise that year information.
>
> After I download the data, I am copying and pasting values only (that way
> the workbook opens faster). But every attempt I make to format the cell or
> cells is futile - the data stays in exactly the form it was originally.
>
> Any help? Thanks!
>
You'd need to convert that string into an EXCEL serial date value before it
can be formatted as a date. Check out EXCEL's DATEVALUE() function.
On Wed, Aug 29, 2012 at 10:29 PM, barclaywood@
barclaywood@
> Hi all, I'm using RCHGetTableCell to download ex-div dates. Everything is
> fine, except I can't find a site that will download in my preferred format
> (dd-mmm). I am getting data in dd-mmm-yy format (e.g., 29-Aug-12). It's a
> nit picky thing, but I would REALLY like to be able to format the cells to
> excise that year information.
>
> After I download the data, I am copying and pasting values only (that way
> the workbook opens faster). But every attempt I make to format the cell or
> cells is futile - the data stays in exactly the form it was originally.
>
> Any help? Thanks!
>
Tidak ada komentar:
Posting Komentar