Messages In This Digest (9 Messages)
- 1.1.
- Re: ADVFN Financial Statements From: Kermit W. Prather
- 1.2.
- Re: ADVFN Financial Statements From: Randy Harmelink
- 2a.
- Smart Money Financial Statements From: rebalance85
- 2b.
- Re: Smart Money Financial Statements From: Randy Harmelink
- 2c.
- Re: Smart Money Financial Statements From: rebalance85
- 2d.
- Re: Smart Money Financial Statements From: Randy Harmelink
- 3a.
- Which function to use for basic company stats from advfn From: B B
- 3b.
- Re: Which function to use for basic company stats from advfn From: Randy Harmelink
- 4.
- Converting cumulative financial data for quarterly cashflow statemen From: redcorolla9999
Messages
- 1.1.
-
Re: ADVFN Financial Statements
Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com kermitpra
Sat May 26, 2012 6:56 am (PDT)
Clark, thanks, I just downloaded both versions. They both work well.
However, they both have problems on stocks that were listed after 2007, such
as AGNC.
Since this isn't an SMF addin function is there another place where we can
discuss your spreadsheet? This looks like a tremendous about of work on
your part and we appreciate your willingness to share it.
I know it is asking a lot but for those of us that are not great on
fundamentals could you possibly provide more instructions on how to best
take advantage of these spreadsheet.
For example, using IBM I see this on the Start worksheet
SCORES
Fundamental
72
Financial
56
Average
64
StockScouter Rating
10
-274
I am familiar with stockscouter but not with the other scores and what is
the -274
Thanks,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Clark F. Grain
Sent: Friday, May 25, 2012 9:27 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: ADVFN Financial Statements
I forgot to give instructions. Open the Start tab and type in the stock
symbol in the upper left cell (Blue) press enter and wait about 30 seconds
or so for the downloads to finish.
C. Grain
----- Original Message -----
From: rebalance85 <mailto:rebalance85@yahoo.com >
To: smf_addin@yahoogroups.com
Sent: Thursday, May 24, 2012 11:01 PM
Subject: [smf_addin] Re: ADVFN Financial Statements
Thank you very much for your kindess.
We want to have 10 years financial statments, the goal is the same, find,
analysis, buy and sell.
I want to put some tab into your file, if it's possible, I will sent the
file to your mailbox.
Thanks again!
--- In smf_addin@yahoogroups.com , "Clark F. Grain" <cgrain@...> wrote:
>
> Hello all,
>
> I am not sure about what you are trying to accomplish. I think you are
interested in downloading financial data, for specific companies, in order
to purchase shares of the company, If this is true I have developed a rather
simple way of getting the data and analyzing it using "web queries". If you
are interested the spreadsheets can be downloaded from the link shown below.
The files to be downloaded are "SA_6.0.4"(Excel 2007-2010), and
"SA_6.0.4(2000) for Excel 97-2003.
>
> C. Grain
> https://www.myiclub.com/ club/folders/ public.aspx? club=3442
- 1.2.
-
Re: ADVFN Financial Statements
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat May 26, 2012 8:27 am (PDT)
The appropriate place for discussion would be:
http://tech.groups.yahoo. com/group/ xltraders/
On Sat, May 26, 2012 at 6:56 AM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
>
> Since this isn't an SMF addin function is there another place where we
> can discuss your spreadsheet? This looks like a tremendous about of work
> on your part and we appreciate your willingness to share it. ****
>
>
>
- 2a.
-
Smart Money Financial Statements
Posted by: "rebalance85" rebalance85@yahoo.com rebalance85
Sat May 26, 2012 7:34 am (PDT)
Hi Randy.
I couldn't find some template about the SmartMoney Source. I am now working on the financial statements.
1. =RCHGetTableCell("http://www.smartmon ey.com/quote/ ",5,"Depreciation & Amortization Expense")IBM/?story= financials& opt=YI
and =RCHGetTableCell("http://www.smartmon ey.com/quote/ ",5,"Depreciation"IBM/?story= financials& opt=YI ), I got the same value.How to solve it?
2. I want to creat element definitions, I make it in txt file name such as:smf-elements-10, then put all the number in it. Or, I must put them into the excel file:RCHGetElementN umber-Element- Definitions.
3. Also, I couldn't find the Marco:smfForceRecalculation, what should I do?
Thanks for your patience.
- 2b.
-
Re: Smart Money Financial Statements
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat May 26, 2012 8:30 am (PDT)
Answers:
1. Use two search strings for the second item. Both can be
"Depreciation".
2. The XLS file is just documentation. Nothing needs to go into it for
your personal elements.
3. It's in the add-in. But the macro dialog doesn't give you an option
to display macros from add-ins. You need to type out the name.
On Sat, May 26, 2012 at 7:34 AM, rebalance85 <rebalance85@yahoo.com > wrote:
> Hi Randy.
> I couldn't find some template about the SmartMoney Source. I am now
> working on the financial statements.
> 1. =RCHGetTableCell("
> http://www.smartmoney.com/quote/ ",5,"DepreciationIBM/?story= financials& opt=YI
> & Amortization Expense")
> and =RCHGetTableCell("
> http://www.smartmoney.com/quote/ ",5,"Depreciation"IBM/?story= financials& opt=YI ),
> I got the same value.How to solve it?
> 2. I want to creat element definitions, I make it in txt file name such
> as:smf-elements-10, then put all the number in it. Or, I must put them into
> the excel file:RCHGetElementNumber-Element- Definitions.
> 3. Also, I couldn't find the Marco:smfForceRecalculation, what should I do?
>
> Thanks for your patience.
>
>
>
>
> --------------------- --------- ------
>
> Yahoo! Groups Links
>
>
>
>
- 2c.
-
Re: Smart Money Financial Statements
Posted by: "rebalance85" rebalance85@yahoo.com rebalance85
Sat May 26, 2012 9:08 am (PDT)
Many thanks.
2 and 3 solved.
Question 1 is still problem, the second line, I use Depreciation Depreciation, the result is error.
Could you please give me an example?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Answers:
>
> 1. Use two search strings for the second item. Both can be
> "Depreciation".
>
> 2. The XLS file is just documentation. Nothing needs to go into it for
> your personal elements.
>
> 3. It's in the add-in. But the macro dialog doesn't give you an option
> to display macros from add-ins. You need to type out the name.
>
>
> On Sat, May 26, 2012 at 7:34 AM, rebalance85 <rebalance85@...> wrote:
>
> > Hi Randy.
> > I couldn't find some template about the SmartMoney Source. I am now
> > working on the financial statements.
> > 1. =RCHGetTableCell("
> > http://www.smartmoney.com/quote/ ",5,"DepreciationIBM/?story= financials& opt=YI
> > & Amortization Expense")
> > and =RCHGetTableCell("
> > http://www.smartmoney.com/quote/ ",5,"Depreciation"IBM/?story= financials& opt=YI ),
> > I got the same value.How to solve it?
> > 2. I want to creat element definitions, I make it in txt file name such
> > as:smf-elements-10, then put all the number in it. Or, I must put them into
> > the excel file:RCHGetElementNumber-Element- Definitions.
> > 3. Also, I couldn't find the Marco:smfForceRecalculation, what should I do?
> >
> > Thanks for your patience.
> >
> >
> >
> >
> > --------------------- --------- ------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
>
- 2d.
-
Re: Smart Money Financial Statements
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat May 26, 2012 11:18 am (PDT)
You can retrieve the first depreciation item with:
=RCHGetTableCell("
http://www.smartmoney.com/quote/ IBM/?story= financials& opt=YI
",5,"Depreciation")
...and the second with:
=RCHGetTableCell("
http://www.smartmoney.com/quote/ IBM/?story= financials& opt=YI
",5,"Depreciation","Depreciation" )
On Sat, May 26, 2012 at 9:08 AM, rebalance85 <rebalance85@yahoo.com > wrote:
> Question 1 is still problem, the second line, I use Depreciation
> Depreciation, the result is error.
> Could you please give me an example?
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Answers:
> >
> > 1. Use two search strings for the second item. Both can be
> > "Depreciation".
> >
> > On Sat, May 26, 2012 at 7:34 AM, rebalance85 <rebalance85@...> wrote:
> >
> > > Hi Randy.
> > > I couldn't find some template about the SmartMoney Source. I am now
> > > working on the financial statements.
> > > 1. =RCHGetTableCell("
> > > http://www.smartmoney.com/quote/ IBM/?story= financials& opt=YI
> ",5,"Depreciation
> > > & Amortization Expense")
> > > and =RCHGetTableCell("
> > > http://www.smartmoney.com/quote/ IBM/?story= financials& opt=YI
> ",5,"Depreciation"),
> > > I got the same value.How to solve it?
>
- 3a.
-
Which function to use for basic company stats from advfn
Posted by: "B B" kokdari82@yahoo.com kokdari82
Sat May 26, 2012 4:53 pm (PDT)
Since ADVFN seems to be the most stable of data sources at the moment, I'm trying to extract the basic stats from advfn but I'm having trouble extracting the information with their layout.
http://www.advfn.com/p.php? pid=qkquote& symbol=qsii
Which function would be best to get the company description as well as which stock market it is listed in?
RCHGetTableCell
RCHGetWebData
smfGetTagContent
- 3b.
-
Re: Which function to use for basic company stats from advfn
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat May 26, 2012 5:14 pm (PDT)
You can use RCHGetTableCell() for both. However, you're still going to have
to do manual extraction of the data you want because of the way it's
presented (combined with labels, etc).
To retrieve the raw data from the page:
=RCHGetTableCell("http://www.advfn. com/p.php? ",0,">Companypid=qkquote& symbol=qsii
Description")
=RCHGetTableCell("http://www.advfn. com/p.php? ",0,">Stockpid=qkquote& symbol=qsii
Market")
Then use smfStrExtr() to pull out the pieces you need.
On Sat, May 26, 2012 at 4:53 PM, B B <kokdari82@yahoo.com > wrote:
> Since ADVFN seems to be the most stable of data sources at the moment, I'm
> trying to extract the basic stats from advfn but I'm having trouble
> extracting the information with their layout.
>
> http://www.advfn.com/p.php? pid=qkquote& symbol=qsii
>
> Which function would be best to get the company description as well as
> which stock market it is listed in?
>
> RCHGetTableCell
> RCHGetWebData
> smfGetTagContent
>
- 4.
-
Converting cumulative financial data for quarterly cashflow statemen
Posted by: "redcorolla9999" redcorolla9999@yahoo.com redcorolla9999
Sat May 26, 2012 11:53 pm (PDT)
Hi,
In Reuters (and most other sources), the cumulative data is given for the quarterly cash-flow statements.
Does anyone know a good general way to convert this to individual quarters?
This is especially tricky when some of the cumulative data covers over-lapping periods, and the data segments are not uniform.
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