4 New Messages
Digest #2301
| |
Messages
Thu Aug 2, 2012 3:11 pm (PDT) . Posted by:
"almondtree" almondtree
Your Idea of use of a database, solved problem blanks with no zeros in "Stock Screener.xls" Thank you and pays to read posts from the past.
--- In smf_addin@yahoogroups.com , zarathustra_winced@... wrote:
>
> The downside of free data is that you have to use your own cpu cycles to parse it. :)
>
> I just save advfn data to a database any time I download it. The database builds very quickly. You'd be surprised how many times you're downloading EPS or FCF for SPX stocks, for example. It only changes 4 times a year. Kind of a waste to throw it away just to download it again later.
> Sent via BlackBerry by AT&T
>
> -----Original Message-----
> From: "rb_luther" <rb_luther@...>
> Sender: smf_addin@yahoogroups.com
> Date: Tue, 31 Jul 2012 18:49:07
> To: <smf_addin@yahoogroups.com >
> Reply-To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: MACRO Question
>
> Do you know of a good website that can export csv files for fast macro computing for metrics such as Current Assets, Total Liabilities, Net Income, etc. going back 10 years? The finviz site is the most comprehensive I have found, but the don't have those basic financial statement metrics, and it seems that it has to be a website that is capable of exporting a csv file, because running a macro to pull the csv file is light years faster than getting the html tables. Thanks again for the help.
>
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > There are two reasons AdvFN takes longer than most other sites:
> >
> > 1. They only have 5 periods of data on a page. So if you want 20 annual
> > periods and 40 quarterly periods, you need to access 12 web pages to get
> > the data for a single ticker symbol.
> >
> > 2. Each web page has a lot of data on it, so if you extract a lot of
> > data from the web page, they do take longer to search for and extract than
> > a smaller web page.
> >
> > You may be able to speed it up by doing RCHGetHTMLTable() on each of the 12
> > web pages, if you're getting all of the data.
> >
> > I get FinViz data quickly, but I do use their CSV file (see LINKS area of
> > the group for more info). Depending on how you're getting the data, and how
> > much data you're getting, it can be a lot slower getting things
> > individually.
> > On Mon, Jul 30, 2012 at 4:52 PM, rb_luther <rb_luther@> wrote:
> >
> > > Is there a way to write a macro to retrieve financial statement data from
> > > the advfn website and then depending on the rows specified paste that data
> > > into excel. (Basically running the macro in background and then pasting the
> > > data into excel without using a formula in each cell to retrieve the
> > > lines.) I'm looking to retrieve ADVFN data more efficiently (decrease
> > > processing time) than using the getADVFN formula in numerous cells.
> > >
> > > Is the processing time long due to the formula in each cell retrieving one
> > > by one, or is it due to having to open numerous web pages to retrieve the
> > > data for different time frames and different tickers?
> > >
> > > Lastly, there is a macro that I have used in the past to retrieve data
> > > from the finviz website and it is much faster processing time than using
> > > the formulas in the cell with the smfaddin macros. Is this due to the
> > > finviz website being able to export csv files and then retrieve the data
> > > from the csv in the background as opposed to retrieving data from an html
> > > table? If so, is there a way to convert the html table on advfn to a csv
> > > file to run more efficiently?
> > >
> > > Thanks for the help.
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
--- In smf_addin@yahoogrou
>
> The downside of free data is that you have to use your own cpu cycles to parse it. :)
>
> I just save advfn data to a database any time I download it. The database builds very quickly. You'd be surprised how many times you're downloading EPS or FCF for SPX stocks, for example. It only changes 4 times a year. Kind of a waste to throw it away just to download it again later.
> Sent via BlackBerry by AT&T
>
> -----Original Message-----
> From: "rb_luther" <rb_luther@.
> Sender: smf_addin@yahoogrou
> Date: Tue, 31 Jul 2012 18:49:07
> To: <smf_addin@yahoogrou
> Reply-To: smf_addin@yahoogrou
> Subject: [smf_addin] Re: MACRO Question
>
> Do you know of a good website that can export csv files for fast macro computing for metrics such as Current Assets, Total Liabilities, Net Income, etc. going back 10 years? The finviz site is the most comprehensive I have found, but the don't have those basic financial statement metrics, and it seems that it has to be a website that is capable of exporting a csv file, because running a macro to pull the csv file is light years faster than getting the html tables. Thanks again for the help.
>
>
>
> --- In smf_addin@yahoogrou
> >
> > There are two reasons AdvFN takes longer than most other sites:
> >
> > 1. They only have 5 periods of data on a page. So if you want 20 annual
> > periods and 40 quarterly periods, you need to access 12 web pages to get
> > the data for a single ticker symbol.
> >
> > 2. Each web page has a lot of data on it, so if you extract a lot of
> > data from the web page, they do take longer to search for and extract than
> > a smaller web page.
> >
> > You may be able to speed it up by doing RCHGetHTMLTable(
> > web pages, if you're getting all of the data.
> >
> > I get FinViz data quickly, but I do use their CSV file (see LINKS area of
> > the group for more info). Depending on how you're getting the data, and how
> > much data you're getting, it can be a lot slower getting things
> > individually.
> > On Mon, Jul 30, 2012 at 4:52 PM, rb_luther <rb_luther@> wrote:
> >
> > > Is there a way to write a macro to retrieve financial statement data from
> > > the advfn website and then depending on the rows specified paste that data
> > > into excel. (Basically running the macro in background and then pasting the
> > > data into excel without using a formula in each cell to retrieve the
> > > lines.) I'm looking to retrieve ADVFN data more efficiently (decrease
> > > processing time) than using the getADVFN formula in numerous cells.
> > >
> > > Is the processing time long due to the formula in each cell retrieving one
> > > by one, or is it due to having to open numerous web pages to retrieve the
> > > data for different time frames and different tickers?
> > >
> > > Lastly, there is a macro that I have used in the past to retrieve data
> > > from the finviz website and it is much faster processing time than using
> > > the formulas in the cell with the smfaddin macros. Is this due to the
> > > finviz website being able to export csv files and then retrieve the data
> > > from the csv in the background as opposed to retrieving data from an html
> > > table? If so, is there a way to convert the html table on advfn to a csv
> > > file to run more efficiently?
> > >
> > > Thanks for the help.
> > >
> > >
> > >
> > > ------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> >
>
>
>
>
> ------------
>
> Yahoo! Groups Links
>
Thu Aug 2, 2012 5:00 pm (PDT) . Posted by:
"Ron Spruell" hashky
Kermit -
You might try downloading again. Bruce has a revised version, and is working on a newer version. It should be out in a couple of days.
Maybe Randy can give some pointers.
>________________________________
> From: Kermit W. Prather <kermitp@tampabay.rr.com >
>To: smf_addin@yahoogroups.com
>Sent: Thursday, August 2, 2012 3:55 PM
>Subject: RE: [smf_addin] Re: DCF
>
>
>
>I have the latest SMF Addin 7-12-12 version. I'm am on excel 2007. And all links are fine I created a tag to correct the links on each spreadsheet I download. All others work just fine. On the DCF spreadsheet Nothing happens even when I force a recalculation.
>
>From:smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Ron Spruell
>Sent: Thursday, August 02, 2012 10:19 AM
>To: smf_addin@yahoogroups.com
>Subject: Re: [smf_addin] Re: DCF
>
>
>
>
>
>Kermit -
>
>I didn't have any problem with it - other than I know very little about DCF.
>
>Did you update the links? Are you running Excel 2007 or 2010?
>
>Ron Spruell
>
>>
>>________________________________
>>
>>From:Kermit W. Prather <kermitp@tampabay.rr.com >
>>To: smf_addin@yahoogroups.com
>>Sent: Thursday, August 2, 2012 8:40 AM
>>Subject: RE: [smf_addin] Re: DCF
>>
>>
>>I downloaded your file and it does not work. The .XLSM implies there should be a macro but none is present.
>>
>>I have my Excel trust settings to allow all macros.
>>
>>When I change a symbol in column A nothing happens. Am I suppose to do something?
>>
>>Columns A thru G contains the values below. What are the values in row 2?
>>
>>
>>Ticker Price DCF EPS
>> d1t1 l1 e
>>
>>
>>When I create a spreadsheet I always make a worksheet name "Instructions" where I explain what the spreadsheet does and how one should use it. The reason I do this isn't so much to provide others the instructions but for me when I visit it months later.
>>
>>I'd love to see folks posting their work do the same. It should save lots of question and you may find it useful when you revisit your work.
>>
>>Of course, not everyone has my bad memory.
>>
>>Thanks for contributing your work. We do appreciate it.
>>
>>Kermit
>>
>>-----Original Message-----
>>From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Bruce
>>Sent: Wednesday, August 01, 2012 10:16 AM
>>To: smf_addin@yahoogroups.com
>>Subject: [smf_addin] Re: DCF
>>
>>
>>
>>Sorry, my mistake, I'll upload it again without the link.
>>
>>
>>
>
>
>
>
>
>
>
You might try downloading again. Bruce has a revised version, and is working on a newer version. It should be out in a couple of days.
Maybe Randy can give some pointers.
>___________
> From: Kermit W. Prather <kermitp@tampabay.
>To: smf_addin@yahoogrou
>Sent: Thursday, August 2, 2012 3:55 PM
>Subject: RE: [smf_addin] Re: DCF
>
>
>
>I have the latest SMF Addin 7-12-12 version. I'm am on excel 2007. And all links are fine I created a tag to correct the links on each spreadsheet I download. All others work just fine. On the DCF spreadsheet Nothing happens even when I force a recalculation.
>
>From:smf_addin@yahoogrou
>Sent: Thursday, August 02, 2012 10:19 AM
>To: smf_addin@yahoogrou
>Subject: Re: [smf_addin] Re: DCF
>
>
>
>
>
>Kermit -
>
>I didn't have any problem with it - other than I know very little about DCF.
>
>Did you update the links? Are you running Excel 2007 or 2010?
>
>Ron Spruell
>
>>
>>__________
>>
>>From:Kermit W. Prather <kermitp@tampabay.
>>To: smf_addin@yahoogrou
>>Sent: Thursday, August 2, 2012 8:40 AM
>>Subject: RE: [smf_addin] Re: DCF
>>
>>
>>I downloaded your file and it does not work. The .XLSM implies there should be a macro but none is present.
>>
>>I have my Excel trust settings to allow all macros.
>>
>>When I change a symbol in column A nothing happens. Am I suppose to do something?
>>
>>Columns A thru G contains the values below. What are the values in row 2?
>>
>>
>>Ticker Price DCF EPS
>> d1t1 l1 e
>>
>>
>>When I create a spreadsheet I always make a worksheet name "Instructions" where I explain what the spreadsheet does and how one should use it. The reason I do this isn't so much to provide others the instructions but for me when I visit it months later.
>>
>>I'd love to see folks posting their work do the same. It should save lots of question and you may find it useful when you revisit your work.
>>
>>Of course, not everyone has my bad memory.
>>
>>Thanks for contributing your work. We do appreciate it.
>>
>>Kermit
>>
>>-----Original Message-----
>>From: smf_addin@yahoogrou
>>Sent: Wednesday, August 01, 2012 10:16 AM
>>To: smf_addin@yahoogrou
>>Subject: [smf_addin] Re: DCF
>>
>>
>>
>>Sorry, my mistake, I'll upload it again without the link.
>>
>>
>>
>
>
>
>
>
>
>
Fri Aug 3, 2012 12:09 am (PDT) . Posted by:
"oryxius" oryxius
While using the Automated Fair-Value Estimator spreadsheet developed by osmangulseven and txbeekeeper I noticed that there tends to be a difference between Morningstar's Long-Term Annualized EPS Growth Estimate and that of Yahoo's, with Yahoo's being more conservative. Here is an example of two stocks:
Morningstar Yahoo
HPQ 7.3% 4.2%
QCOR 45.3% 35.8%
They are not always that different, but aren't these consensus estimates and shouldn't they be always close? I think Yahoo's is based on Reuter's tally, but I don't know where Morningstar's tally come from. Any thoughts on which one is more reliable?
Moe
Morningstar Yahoo
HPQ 7.3% 4.2%
QCOR 45.3% 35.8%
They are not always that different, but aren't these consensus estimates and shouldn't they be always close? I think Yahoo's is based on Reuter's tally, but I don't know where Morningstar'
Moe
Fri Aug 3, 2012 2:59 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Many articles claim NONE of the analyst's estimates are reliable.
BTW, when I look at Morningstar, I see -0.7% for HPQ and 36.5% for QCOR.
And both Morningstar and Yahoo have a significantly different number of
analysts -- 3 vs 11 for QCOR, for example.
On Fri, Aug 3, 2012 at 12:09 AM, oryxius <oryxius@yahoo.com > wrote:
> While using the Automated Fair-Value Estimator spreadsheet developed by
> osmangulseven and txbeekeeper I noticed that there tends to be a difference
> between Morningstar's Long-Term Annualized EPS Growth Estimate and that of
> Yahoo's, with Yahoo's being more conservative. Here is an example of two
> stocks:
>
> Morningstar Yahoo
> HPQ 7.3% 4.2%
> QCOR 45.3% 35.8%
>
>
> They are not always that different, but aren't these consensus estimates
> and shouldn't they be always close? I think Yahoo's is based on Reuter's
> tally, but I don't know where Morningstar's tally come from. Any thoughts
> on which one is more reliable?
>
BTW, when I look at Morningstar, I see -0.7% for HPQ and 36.5% for QCOR.
And both Morningstar and Yahoo have a significantly different number of
analysts -- 3 vs 11 for QCOR, for example.
On Fri, Aug 3, 2012 at 12:09 AM, oryxius <oryxius@yahoo.
> While using the Automated Fair-Value Estimator spreadsheet developed by
> osmangulseven and txbeekeeper I noticed that there tends to be a difference
> between Morningstar'
> Yahoo's, with Yahoo's being more conservative. Here is an example of two
> stocks:
>
> Morningstar Yahoo
> HPQ 7.3% 4.2%
> QCOR 45.3% 35.8%
>
>
> They are not always that different, but aren't these consensus estimates
> and shouldn't they be always close? I think Yahoo's is based on Reuter's
> tally, but I don't know where Morningstar'
> on which one is more reliable?
>
Tidak ada komentar:
Posting Komentar