Messages In This Digest (15 Messages)
- 1a.
- silly mistake ? From: leif_85
- 1b.
- Re: silly mistake ? From: Randy Harmelink
- 2a.
- Re: Missing Data? From: rpc19522003
- 3a.
- Yet another installation question From: stplsmrk
- 3b.
- Re: Yet another installation question From: Randy Harmelink
- 4a.
- Adding downloaded templates to tabs in one Excel workbook From: bradleystipp@ymail.com
- 4b.
- Re: Adding downloaded templates to tabs in one Excel workbook From: Randy Harmelink
- 5a.
- RCHGetYahooHistory in a loop From: dmitchelspsscom
- 5b.
- Re: RCHGetYahooHistory in a loop From: Randy Harmelink
- 5c.
- Re: RCHGetYahooHistory in a loop From: dmitchelspsscom
- 6a.
- Re: RCHGetYahooHistory spreadsheet error checking From: Daniel Loper
- 6b.
- Re: RCHGetYahooHistory spreadsheet error checking From: Randy Harmelink
- 6c.
- Re: RCHGetYahooHistory spreadsheet error checking From: Daniel Loper
- 7a.
- Re: Gross and Net PPE From: mnavas
- 7b.
- Re: Gross and Net PPE From: Randy Harmelink
Messages
- 1a.
-
silly mistake ?
Posted by: "leif_85" gondoliere2@web.de leif_85
Wed Feb 22, 2012 4:07 am (PST)
Hi,
I bought Excel 2010 (German edition) now and installed the smf_addin.
There could have been something going wrong meanwhile.
When I try to open the link in line 1286 of the "Elements Definitions" - sheet another sheet opens yet being all filled with the #name? error, the content of the first cell being
='http://finance.groups.yahoo. Files\SMF Add-In\RCH_Stock_com/Program Market_Functions .xla'!RCHGetElem entNumber( Ticker;1286)
which for me does not make sense, as the addin is on my harddisk.
After a while a message box opens saying (about) connection target could not be found.
Earlier I got a sheet where one half of the cells were showing "error" the other half seemingly meaningful percent data. As I initially had the addin file in directory C:\program files\SMF AddIn\Rch_stockmarket functions, I thought I transfer it to C:\program files\SMF AddIn, because somewhere is written, it shoul be in C:\program files\SMF AddIn.
Afterwards I did not get these nice percent numbers anymore.
I tried to deinstall the SMF_AddIn but found only the possibility to inactivate it.
My guess would be to deinstall Office 2010 and reinstall and then tackle the "error" problem again.
Regards,
leif
- 1b.
-
Re: silly mistake ?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Feb 22, 2012 4:56 am (PST)
Check the "Links" area of the group and look for an item on location errors
(#NAME?). This can be a common issue because of how EXCEL handles add-ins.
On Wed, Feb 22, 2012 at 5:07 AM, leif_85 <gondoliere2@web.de > wrote:
>
> I bought Excel 2010 (German edition) now and installed the smf_addin.
> There could have been something going wrong meanwhile.
> When I try to open the link in line 1286 of the "Elements Definitions" -
> sheet another sheet opens yet being all filled with the #name? error, the
> content of the first cell being
>
> ='http://finance.groups.yahoo. Files\SMFcom/Program
> Add-In\RCH_Stock_Market_Functions .xla'!RCHGetElem entNumber( Ticker;1286)
>
> which for me does not make sense, as the addin is on my harddisk.
>
> After a while a message box opens saying (about) connection target could
> not be found.
>
> Earlier I got a sheet where one half of the cells were showing "error" the
> other half seemingly meaningful percent data. As I initially had the addin
> file in directory C:\program files\SMF AddIn\Rch_stockmarket functions, I
> thought I transfer it to C:\program files\SMF AddIn, because somewhere is
> written, it shoul be in C:\program files\SMF AddIn.
> Afterwards I did not get these nice percent numbers anymore.
>
> I tried to deinstall the SMF_AddIn but found only the possibility to
> inactivate it.
>
> My guess would be to deinstall Office 2010 and reinstall and then tackle
> the "error" problem again.
>
- 2a.
-
Re: Missing Data?
Posted by: "rpc19522003" rpc1952@verizon.net rpc19522003
Wed Feb 22, 2012 4:21 am (PST)
Thank you for the timely response. My short answer is that I DON'T need all that data. I am, in fact, using a separate template to perform individual security analysis. When I started seeing errors in that model, I wanted to try a comprehensive test to see if it was the source(s) or my application of the functions. That "test" is what I asked about. But now that I understand a bit more of the functionality, I believe I can continue on my original quest with a bit more confidence. Thanks for the help.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Why do you need all that data?
>
> The problem is you're trying to retrieve too much data. The add-in is
> designed for ad hoc data retrieval, not to build a database. I don't want
> people abusing the free data sources, just because it could be easy to. It
> would be easy enough for them to modify their web pages to prevent
> extraction of the data with something like the add-in.
>
> What happens is the add-in stores up to 1000 web pages before it refuses to
> get any more. It extracts the data from those stored web pages. Check out
> the item on smfForceRecalculation from the "Links" area of the group for
> more details on how the add-in does the extractions.
>
> What you should be doing is using a screener to get down to a manageable
> set of data, and then get more detailed data on that smaller universe.
>
> If you need a good screener with financial statements data, I'd suggest
> stockscreen123.com. It's not free, but for $15 a month, there's a lot of
> things you can do with it. And it's one of the few online screeners with
> backtesting capabilities with "point in time" data.
>
> On Tue, Feb 21, 2012 at 6:26 PM, rpc19522003 <rpc1952@...> wrote:
>
> > After a long search, I stumbled across this group and found exactly what
> > I've been looking for for a very long time! Thanks for all the great work
> > that obviously went into this.
> >
> > I searched the posts and couldn't find anything related to what I'm
> > experiencing, so hopefully someone here can shed some light. I'm using
> > solely the RCHGetElementNumber function to extract certain data elements
> > (shown below) and I'm getting LOTS of errors. I believe I'm using the
> > function correctly because some symbols provide all the data correctly, but
> > my sheet contains over 7,000 symbols and I'm only getting a very small
> > percentage of valid data. Over 6,500 of the symbols return errors for
> > every element requested; most of the remaining symbols return one or more
> > errors; only a very small handful of the 7000+ return a full set of valid
> > data (I'm only showing a few of the elements I'm pulling in the table
> > below).
> >
> > The formula in each cell is "=RCHGetElementNumber($A4,B$ 3)" where the
> > first criteria points to the symbol and the second references the element
> > number which is shown to the right of the "Symbol:" column heading below).
> >
> > Am I using the function correctly? Am I using the correct function? Is
> > the available data from MSN and/or AdvFN as limited as it would appear? is
> > there something else I may be missing? Any help would be greatly
> > appreciated.
> >
> >
> > Current EPS Date Current EPS Initial EPS Date
> > Initial EPS Current Cash Flow Initial Cash Flow
> > Symbol: 333 153 340 160 6595 6603
> > AAPL 27.68 09/11 0.34 09/04 $3,730 $758
> > BLK 12.38 12/11 2.17 12/04 Error Error
> > CAG 1.9 05/11 1.02 05/04 $2,121 ($320)
> > CNI 5.44 12/11 2.18 12/04 ($617) ($571)
> > CTL 1.07 12/11 2.41 12/04 ($92) $537
> > CVS 2.59 12/11 0.88 01/05 $2,876 ($2,847)
> > CVX 13.44 12/11 6.14 12/04 ($2,100) $5,103
> > DIS 2.52 10/11 1.11 09/04 $30 $2,739
> > ETN 3.94 12/11 2.04 12/04 $723 ($282)
> > GE 1.23 12/11 1.59 12/04 $204,950 ($3,615)
> > TLP Error Error Error Error Error Error
> > RGP Error Error Error Error Error Error
> > ETP Error Error Error Error Error Error
> > EONGY Error Error Error Error Error Error
> > GAIN Error Error Error Error Error Error
> > NTLS Error Error Error Error Error Error
> > OSG Error Error Error Error Error Error
> > WBK Error Error Error Error Error Error
> > CMRE Error Error Error Error Error Error
> > HHILY Error Error Error Error Error Error
> > EROC Error Error Error Error Error Error
> > OLP Error Error Error Error Error Error
> > SUNS Error Error Error Error Error Error
> > GNTY Error Error Error Error Error Error
> > CRT Error Error Error Error Error Error
> >
>
- 3a.
-
Yet another installation question
Posted by: "stplsmrk" stplsmrk@yahoo.com stplsmrk
Wed Feb 22, 2012 4:24 am (PST)
Sorry, I've searched, but can't find an answer.
I unzipped the installation files to my desktop and installed the add in in Excel from there. C:\Users\Mark\Desktop\RCH_ Stock_Market_ Functions- 2.1.2012. 02.02
Later I moved the installation to C:\Program Files\RCH AddIn 2.1.2012.02.02\RCH_Stock_ Market_Functions .xla
When I installed from this location, excel asked if I wanted to delete the first installation from the list. Yes.
I deleted the first folder from the desktop.
All fine until I shut down the compute and then reopen. When I launch Excel it gives an alert saying it can't find C:\Users\Mark\Desktop\RCH_ Stock_Market_ Functions- 2.1.2012. 02.02 and all RCH functions now show #name?.
If I use the find and replace and then some other manual stuff I can get everything back together again, but have to repeat with every reboot of the computer.
Any help appreciated.
ps: How does one provide financial support to this site? It is a life saver....
- 3b.
-
Re: Yet another installation question
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Feb 22, 2012 5:01 am (PST)
Go to the "Links" area of the group and look for the item on location
errors (#NAME?). The "find and replace" process is something that has to be
done once. Once you save the workbook, it will have all references pointing
to your location of the add-in. Unfortunately, it's how EXCEL does things.
I actually have the smfFixLinks macro assigned to a button. It usually
fixes all of the link errors I run into when I open up a workbook that uses
a different location.
As far as financial support, I usually just ask people to "Pay it Forward"
and send something to a worthy charity. Share the wealth. :)
On Wed, Feb 22, 2012 at 5:24 AM, stplsmrk <stplsmrk@yahoo.com > wrote:
> Sorry, I've searched, but can't find an answer.
>
> I unzipped the installation files to my desktop and installed the add in
> in Excel from there.
> C:\Users\Mark\Desktop\RCH_ Stock_Market_ Functions- 2.1.2012. 02.02
>
> Later I moved the installation to C:\Program Files\RCH AddIn
> 2.1.2012.02.02\RCH_Stock_ Market_Functions .xla
>
> When I installed from this location, excel asked if I wanted to delete the
> first installation from the list. Yes.
>
> I deleted the first folder from the desktop.
>
> All fine until I shut down the compute and then reopen. When I launch
> Excel it gives an alert saying it can't find
> C:\Users\Mark\Desktop\RCH_ Stock_Market_ Functions- 2.1.2012. 02.02 and all RCH
> functions now show #name?.
>
> If I use the find and replace and then some other manual stuff I can get
> everything back together again, but have to repeat with every reboot of the
> computer.
>
> Any help appreciated.
>
> ps: How does one provide financial support to this site? It is a life
> saver....
>
- 4a.
-
Adding downloaded templates to tabs in one Excel workbook
Posted by: "bradleystipp@ymail.com" btstipp@gmail.com bradleystipp@ymail.com
Wed Feb 22, 2012 7:30 am (PST)
I have downloaded various templates from the files section and they have been installed and work but are in separate workbooks. When I try to copy and paste (paste all) to a blank tab to consolidate within one workbook, I get the Dialog Box that says "A formula or sheet you want to move or copy contains the name 'Ticker', which already exists on the destination worksheet. Do yo want to use this version of the name? If yes, click yes. To rename the range referred to in the formula or worksheet, click No, and enter a new name in the Name Conflict dialog box."
Is there a workaround for this? I would like to have all of the various templates within one workbook for simplicity's sake.
Thank you.
- 4b.
-
Re: Adding downloaded templates to tabs in one Excel workbook
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Feb 22, 2012 7:38 am (PST)
The dialog is giving you the workaround -- either use the original name or
give it a new one. You have to resolve the conflict one way or another.
On Wed, Feb 22, 2012 at 8:02 AM, bradleystipp@ymail.com
<btstipp@gmail.com >wrote:
> I have downloaded various templates from the files section and they have
> been installed and work but are in separate workbooks. When I try to copy
> and paste (paste all) to a blank tab to consolidate within one workbook, I
> get the Dialog Box that says "A formula or sheet you want to move or copy
> contains the name 'Ticker', which already exists on the destination
> worksheet. Do yo want to use this version of the name? If yes, click yes.
> To rename the range referred to in the formula or worksheet, click No, and
> enter a new name in the Name Conflict dialog box."
>
> Is there a workaround for this? I would like to have all of the various
> templates within one workbook for simplicity's sake.
>
- 5a.
-
RCHGetYahooHistory in a loop
Posted by: "dmitchelspsscom" dmitchell@systat.com dmitchelspsscom
Wed Feb 22, 2012 11:18 am (PST)
Hi Randy,
I've been using your macro for some time and it has been very useful. Thank you. However the way I have done it is very inefficient.
For each ticker I have a separate set of cocde and I want to replace this with one set of code in a loop. I've tried two different ways.
My system is:
Windows 7, Office 2010
The latest version of your SMF add-in
Stock Market Functions Add-ins checked in File, Options, Manage Excel Add-ins
Also checked there Analysis Tool Pak, Analysis Tool Pak - VBA, Solver Add-in
Case 1. Use Formula Array
The following runs fine with Ticker strings in cells O2 and O3
Range("A1:B738").Select
Selection.FormulaArray = _
"=RCHGetYahooHistory(O2,YEAR( TODAY()-1062) ,MONTH(TODAY( )-1062),DAY( TODAY()-1062) ,YEAR(TODAY( )),MONTH( TODAY()), DAY(TODAY( )),,""DA" ",1,,1)"
Range("C1:C738").Select
Selection.FormulaArray = _
"=RCHGetYahooHistory(O3,YEAR( TODAY()-1062) ,MONTH(TODAY( )-1062),DAY( TODAY()-1062) ,YEAR(TODAY( )),MONTH( TODAY()), DAY(TODAY( )),,""A"" ,1,,1)"
But nothing that I have tried making the Ticker a variable works. The entire string in quotes, including the variable name,
gets placed into each cell
Case 2. I searched your Yahoo Groups site and found the following which is exactly what I want.
Dim sItems As String
Dim oCell As Range
sItems = "D"
For Each oCell In [B4:Z4]
If oCell.Value2 = "" Then Exit For
Range(oCell.Offset(1, 0), oCell.Offset( 1000, 0)) = RCHGetYahooHistory( oCell.Value2, pResort:=1, pItems:=sItems, pDim1:=1000, pDim2:=1)
sItems = "A"
Next oCell
I set the worksheet up exactly as described but upon running I get "Compile error. Sub or Function not defined" with RCHGetYahooHistory highlighted.
I don't understand why the function is not defined as it certainly was in the first set of code above.
Any help you can give will be very much appreciated.
Dick
- 5b.
-
Re: RCHGetYahooHistory in a loop
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Feb 22, 2012 11:23 am (PST)
In order for your "Case 2" to work, you need to set up the add-in as a
reference library for the VBA project. That will makes all of its functions
available to your VBA project.
The reason the function exists in your "Case 1" is because it is executing
within the EXCEL worksheet, not within the VBA project. Having the add-in
installed for the worksheet doesn't make it available for VBA.
On Wed, Feb 22, 2012 at 12:16 PM, dmitchelspsscom <dmitchell@systat.com >wrote:
> Hi Randy,
>
> I've been using your macro for some time and it has been very useful.
> Thank you. However the way I have done it is very inefficient.
> For each ticker I have a separate set of cocde and I want to replace this
> with one set of code in a loop. I've tried two different ways.
>
> My system is:
>
> Windows 7, Office 2010
> The latest version of your SMF add-in
> Stock Market Functions Add-ins checked in File, Options, Manage Excel
> Add-ins
> Also checked there Analysis Tool Pak, Analysis Tool Pak - VBA, Solver
> Add-in
>
> Case 1. Use Formula Array
>
> The following runs fine with Ticker strings in cells O2 and O3
>
> Range("A1:B738").Select
> Selection.FormulaArray = _
>
> "=RCHGetYahooHistory(O2,YEAR( TODAY()-1062) ,MONTH(TODAY( )-1062),DAY( TODAY()-1062) ,YEAR(TODAY( )),MONTH( TODAY()), DAY(TODAY( )),,""DA" ",1,,1)"
>
> Range("C1:C738").Select
> Selection.FormulaArray = _
>
> "=RCHGetYahooHistory(O3,YEAR( TODAY()-1062) ,MONTH(TODAY( )-1062),DAY( TODAY()-1062) ,YEAR(TODAY( )),MONTH( TODAY()), DAY(TODAY( )),,""A"" ,1,,1)"
>
> But nothing that I have tried making the Ticker a variable works. The
> entire string in quotes, including the variable name,
> gets placed into each cell
>
> Case 2. I searched your Yahoo Groups site and found the following which
> is exactly what I want.
>
> Dim sItems As String
> Dim oCell As Range
> sItems = "D"
> For Each oCell In [B4:Z4]
> If oCell.Value2 = "" Then Exit For
> Range(oCell.Offset(1, 0), oCell.Offset( 1000, 0)) =
> RCHGetYahooHistory(oCell.Value2, pResort:=1, pItems:=sItems, pDim1:=1000,
> pDim2:=1)
> sItems = "A"
> Next oCell
>
> I set the worksheet up exactly as described but upon running I get
> "Compile error. Sub or Function not defined" with RCHGetYahooHistory
> highlighted.
>
> I don't understand why the function is not defined as it certainly was in
> the first set of code above.
>
> Any help you can give will be very much appreciated.
>
- 5c.
-
Re: RCHGetYahooHistory in a loop
Posted by: "dmitchelspsscom" dmitchell@systat.com dmitchelspsscom
Wed Feb 22, 2012 2:34 pm (PST)
Works like a charm. Thank you.
Dick
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> In order for your "Case 2" to work, you need to set up the add-in as a
> reference library for the VBA project. That will makes all of its functions
> available to your VBA project.
>
> The reason the function exists in your "Case 1" is because it is executing
> within the EXCEL worksheet, not within the VBA project. Having the add-in
> installed for the worksheet doesn't make it available for VBA.
>
> On Wed, Feb 22, 2012 at 12:16 PM, dmitchelspsscom <dmitchell@...>wrote:
>
> > Hi Randy,
> >
> > I've been using your macro for some time and it has been very useful.
> > Thank you. However the way I have done it is very inefficient.
> > For each ticker I have a separate set of cocde and I want to replace this
> > with one set of code in a loop. I've tried two different ways.
> >
> > My system is:
> >
> > Windows 7, Office 2010
> > The latest version of your SMF add-in
> > Stock Market Functions Add-ins checked in File, Options, Manage Excel
> > Add-ins
> > Also checked there Analysis Tool Pak, Analysis Tool Pak - VBA, Solver
> > Add-in
> >
> > Case 1. Use Formula Array
> >
> > The following runs fine with Ticker strings in cells O2 and O3
> >
> > Range("A1:B738").Select
> > Selection.FormulaArray = _
> >
> > "=RCHGetYahooHistory(O2,YEAR( TODAY()-1062) ,MONTH(TODAY( )-1062),DAY( TODAY()-1062) ,YEAR(TODAY( )),MONTH( TODAY()), DAY(TODAY( )),,""DA" ",1,,1)"
> >
> > Range("C1:C738").Select
> > Selection.FormulaArray = _
> >
> > "=RCHGetYahooHistory(O3,YEAR( TODAY()-1062) ,MONTH(TODAY( )-1062),DAY( TODAY()-1062) ,YEAR(TODAY( )),MONTH( TODAY()), DAY(TODAY( )),,""A"" ,1,,1)"
> >
> > But nothing that I have tried making the Ticker a variable works. The
> > entire string in quotes, including the variable name,
> > gets placed into each cell
> >
> > Case 2. I searched your Yahoo Groups site and found the following which
> > is exactly what I want.
> >
> > Dim sItems As String
> > Dim oCell As Range
> > sItems = "D"
> > For Each oCell In [B4:Z4]
> > If oCell.Value2 = "" Then Exit For
> > Range(oCell.Offset(1, 0), oCell.Offset( 1000, 0)) =
> > RCHGetYahooHistory(oCell.Value2, pResort:=1, pItems:=sItems, pDim1:=1000,
> > pDim2:=1)
> > sItems = "A"
> > Next oCell
> >
> > I set the worksheet up exactly as described but upon running I get
> > "Compile error. Sub or Function not defined" with RCHGetYahooHistory
> > highlighted.
> >
> > I don't understand why the function is not defined as it certainly was in
> > the first set of code above.
> >
> > Any help you can give will be very much appreciated.
> >
>
- 6a.
-
Re: RCHGetYahooHistory spreadsheet error checking
Posted by: "Daniel Loper" dan@controllogic.net danloper2002
Wed Feb 22, 2012 7:04 pm (PST)
Could you give me an example please. This error seems to be based on how fast the information is retrieved from the internet verses the next line of code executing before the information is completely there. In a VBA routine, how do wait for the retrival of information befor resuming execution of the subroutine? This can't be a unique issue. An examlpe of how to handle this would be appriciated.
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Monday, February 20, 2012 11:46 PM
Subject: Re: [smf_addin] RCHGetYahooHistory spreadsheet error checking
About the only way would be some type of VBA routine...
On Mon, Feb 20, 2012 at 9:10 PM, Dan <dan@controllogic.net > wrote:
My spreadsheet is getting the information for a stock, processing it, and moving on to the next stock. If stock is unavailable at the moment, I'm getting a "400" error. I am looking for information that can be used in error checking for my spreadsheet. Specifically, is there a way to retry a few times befor I get the error?
>
>Any suggestions appreciated.
>
- 6b.
-
Re: RCHGetYahooHistory spreadsheet error checking
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Feb 22, 2012 7:14 pm (PST)
I've not had the issue, so I'm not sure exactly what you'd need. But take a
look at item 9.2 in the "Links" area of the group. I think something like
that, to iterate over your download data, to see what is missing, would
probably do the trick. I'm just not sure how to identify when something is
missing? Not a date in the first column, maybe?
The add-in does wait for the Internet to respond, so it waits before going
to the next line of code.
Recently, I have had an infrequent +issue in my browser where I go to view
some historical quotes and Yahoo tells me there are none. But if I refresh
the web page, they show up. The same thing could be happening with the
add-in -- Yahoo is occasionally sending an empty file or an error message
instead of the CSV file.
On Wed, Feb 22, 2012 at 8:04 PM, Daniel Loper <dan@controllogic.net > wrote:
>
> Could you give me an example please. This error seems to be based on how
> fast the information is retrieved from the internet verses the next line of
> code executing before the information is completely there. In a VBA
> routine, how do wait for the retrival of information befor resuming
> execution of the subroutine? This can't be a unique issue. An examlpe of
> how to handle this would be appriciated.
>
>
- 6c.
-
Re: RCHGetYahooHistory spreadsheet error checking
Posted by: "Daniel Loper" dan@controllogic.net danloper2002
Wed Feb 22, 2012 11:24 pm (PST)
You had it right. Yahoo was occasionally sending me blank files - no data. When I tried to process an empty file I got errors. Now I am set up to check for empty files and everything is working very nicely. I'm impressed with how fast it is. Thank you for your help.
Best regards,
Dan
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Wednesday, February 22, 2012 8:14 PM
Subject: Re: [smf_addin] RCHGetYahooHistory spreadsheet error checking
I've not had the issue, so I'm not sure exactly what you'd need. But take a look at item 9.2 in the "Links" area of the group. I think something like that, to iterate over your download data, to see what is missing, would probably do the trick. I'm just not sure how to identify when something is missing? Not a date in the first column, maybe?
The add-in does wait for the Internet to respond, so it waits before going to the next line of code.
Recently, I have had an infrequent +issue in my browser where I go to view some historical quotes and Yahoo tells me there are none. But if I refresh the web page, they show up. The same thing could be happening with the add-in -- Yahoo is occasionally sending an empty file or an error message instead of the CSV file.
On Wed, Feb 22, 2012 at 8:04 PM, Daniel Loper <dan@controllogic.net > wrote:
>
>Could you give me an example please. This error seems to be based on how fast the information is retrieved from the internet verses the next line of code executing before the information is completely there. In a VBA routine, how do wait for the retrival of information befor resuming execution of the subroutine? This can't be a unique issue. An examlpe of how to handle this would be appriciated.
>
- 7a.
-
Re: Gross and Net PPE
Posted by: "mnavas" mnavas@yahoo.com mnavas
Wed Feb 22, 2012 9:42 pm (PST)
How do you get yearly info? instead of quarterly
--- In smf_addin@yahoogroups.com , "Chovek2" <keith@...> wrote:
>
> That's fantastic, thanks Randy
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Where elements aren't defined, you would need to use other add-in functions
> > to retrieve the data. For example, to get the most recent quarter of
> > depreciation from IBM's income statement:
> >
> > =RCHGetTableCell("https://www. google.com/ finance?q= NYSE:IBM& fstype=ii
> > ",1,">Depreciation/Amortization" )
> >
> > It's not a good idea to mix financial statements data from different
> > sources, because they can have different meanings. For example, Yahoo's
> > "Cash and Equivalents" includes "Restricted Cash", while some other sources
> > break out the "Restricted Cash". In fact, Yahoo has a "Cash" amount listed
> > on their Key Statistics web page -- which you cannot calculate using their
> > financial statements data, because of the "Restricted Cash" issue.
> >
> > On Tue, Jan 10, 2012 at 4:01 AM, Chovek2 <keith@> wrote:
> >
> > > Hi, there. I have an issue in that I am constructing historical
> > > statements, generally using Google. Google gives gross PPE; however, I
> > > need net PPE. Although Google does give accumulated depreciation, there
> > > seems to be no code for that line item.
> > >
> > > 1) does anyone know of code for line item accumulated depreciation on
> > > Google, if so where can I get it?
> > >
> > > Additionally, Yahoo gives PPE as a net figure. However,Yahoo code seems
> > > to exist only for the quarterly balance sheet, from what I see.
> > >
> > > 2)Does yahoo have code for annual balance sheets, if so, where can I get
> > > it.
> > >
> > > Many thanks for any help with this small, but irksome detail.
> > >
> >
>
- 7b.
-
Re: Gross and Net PPE
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Feb 22, 2012 10:05 pm (PST)
Just tell the function to skip down to the annual section before searching
for the line items. For example, to get the first FQ of Revenues:
=RCHGetTableCell("https://www. google.com/ finance?q= NYSE:IBM& fstype=ii
",1,">Revenue")
...and to get the fiirst FY of Revenues:
=RCHGetTableCell("https://www. google.com/ finance?q= NYSE:IBM& fstype=ii
",1,"id=""incannualdiv""","> Revenue")
On Wed, Feb 22, 2012 at 10:41 PM, mnavas <mnavas@yahoo.com > wrote:
> How do you get yearly info? instead of quarterly
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar