7 New Messages
Digest #2525
Messages
Wed Feb 27, 2013 6:40 am (PST) . Posted by:
"Russell M" rerussellson
Does anyone know of either an element # or a way to get trailing 12-month free cash flow easily? Because of the cumulative nature of quarterly cash flow numbers, it is a bit more difficult to figure out.
I have built a worksheet that can do it for a single stock incorporating operating cash flow and net capex for the previous 5 quarterly reporting periods and then using an IF function based on element #8066 to control what fiscal quarter a company is in.
I would like to be able to screen for FCF yield (FCF/Enterprise Value...not FCF/P) for a of group stocks, but the above issue makes it difficult.
My experience to date has been limited to using RCHGetElementNumber functions. If there is a way using different functions to achieve this goal I would be very happy to learn if someone can point me in the right direction.
Any help would be greatly appreciated.
Randy - Once again, thanks for a great tool!
Russell
I have built a worksheet that can do it for a single stock incorporating operating cash flow and net capex for the previous 5 quarterly reporting periods and then using an IF function based on element #8066 to control what fiscal quarter a company is in.
I would like to be able to screen for FCF yield (FCF/Enterprise Value...not FCF/P) for a of group stocks, but the above issue makes it difficult.
My experience to date has been limited to using RCHGetElementNumber functions. If there is a way using different functions to achieve this goal I would be very happy to learn if someone can point me in the right direction.
Any help would be greatly appreciated.
Randy - Once again, thanks for a great tool!
Russell
Wed Feb 27, 2013 6:57 am (PST) . Posted by:
"ds5ec" ds5ec
OK, thanks, that explains it. I'm not loading a database - just scanning for a few conditions related to earnings every quarter but understand that it is straying into the paid data area. I'll look for a paid for data feed if I continue with it. Thanks again and thanks for providing the functions.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> The add-in itself is internally limited to 1000 web page accesses. I'm sure
> that's what you're running into.
>
> The add-in is intended for ad hoc data retrieval, not for loading up of
> databases. It's not fair to place that level of burden on the free data
> sources.
>
> If you need that amount of data, you should be using a paid data provider.
>
> On Wed, Feb 27, 2013 at 3:17 AM, ds5ec wrote:
>
> > I've written some Excel VBA to cycle through the following functions for
> > each of about 1200 stocks.
> >
> > smfGetOptionStrikes
> > smfGetOptionQuotes
> > smfGetOptionExpirations
> > RCHGetYahooQuotes
> > RCHGetElementNumber
> >
> > It seems that after about the 300th stock the OX source stops providing
> > data. For example, smfGetOptionStrikes gives "" even though there are valid
> > strikes. To check this I used
> > smfGetOptionQuotes-Example-Table-Building-Exercise.xls as a starting point
> > and added the stock list to sheet 2. Then used smfGetOptionStrikes for each
> > stock. The data stops after about the 900 stock. At that point sheet1
> > doesn't return data, which it did before.
> >
> > Would you expect the data feed to stop after so many requests? I've tried
> > waiting a couple of seconds between each function but get the same result.
> > Do you have any advice for dealing with this?
> >
>
--- In smf_addin@yahoogrou
>
> The add-in itself is internally limited to 1000 web page accesses. I'm sure
> that's what you're running into.
>
> The add-in is intended for ad hoc data retrieval, not for loading up of
> databases. It's not fair to place that level of burden on the free data
> sources.
>
> If you need that amount of data, you should be using a paid data provider.
>
> On Wed, Feb 27, 2013 at 3:17 AM, ds5ec wrote:
>
> > I've written some Excel VBA to cycle through the following functions for
> > each of about 1200 stocks.
> >
> > smfGetOptionStrikes
> > smfGetOptionQuotes
> > smfGetOptionExpirat
> > RCHGetYahooQuotes
> > RCHGetElementNumber
> >
> > It seems that after about the 300th stock the OX source stops providing
> > data. For example, smfGetOptionStrikes gives "" even though there are valid
> > strikes. To check this I used
> > smfGetOptionQuotes-
> > and added the stock list to sheet 2. Then used smfGetOptionStrikes for each
> > stock. The data stops after about the 900 stock. At that point sheet1
> > doesn't return data, which it did before.
> >
> > Would you expect the data feed to stop after so many requests? I've tried
> > waiting a couple of seconds between each function but get the same result.
> > Do you have any advice for dealing with this?
> >
>
Wed Feb 27, 2013 7:00 am (PST) . Posted by:
"alexcomp1" alexcomp1
I created a spreadsheet that has mixed stocks and options, perhaps as many as 125 cells requiring lookup, and it works – sort of.
My first problem is that if I make additions for new positions as I go from cell to cell it is slow as it seems to recalculate the entire sheet. How do I fix this?
In a previous post I asked about "real time" Yahoo quotes. The answer I received indicated that this was a possibility but you had to sign up for it. I attempted this but got confused – it seemed to me that I might be able to get an individual real-time quote for free but if I wanted to get a stream of real-time quotes it looked like I would have to pay for it. Am I correct in this assumption?
I have created a toolbar command to "force recalculation" however, it seems to be unable to completely recalculate and look up fresh quotations unless I delete temporary files in my Internet Explorer, then close and reopen the sheet. There must be an easier way to do a fresh look up and complete recalculation. Is there?
Many thanks to the author of this highly useful add-in.
My first problem is that if I make additions for new positions as I go from cell to cell it is slow as it seems to recalculate the entire sheet. How do I fix this?
In a previous post I asked about "real time" Yahoo quotes. The answer I received indicated that this was a possibility but you had to sign up for it. I attempted this but got confused – it seemed to me that I might be able to get an individual real-time quote for free but if I wanted to get a stream of real-time quotes it looked like I would have to pay for it. Am I correct in this assumption?
I have created a toolbar command to "force recalculation" however, it seems to be unable to completely recalculate and look up fresh quotations unless I delete temporary files in my Internet Explorer, then close and reopen the sheet. There must be an easier way to do a fresh look up and complete recalculation. Is there?
Many thanks to the author of this highly useful add-in.
Wed Feb 27, 2013 7:53 am (PST) . Posted by:
"Randy Harmelink" rharmelink
On Wed, Feb 27, 2013 at 8:00 AM, alexcomp1 sgg@alexcomp.com > wrote:
> I created a spreadsheet that has mixed stocks and options, perhaps as many
> as 125 cells requiring lookup, and it works â€" sort of.
>
> My first problem is that if I make additions for new positions as I go
> from cell to cell it is slow as it seems to recalculate the entire sheet.
> How do I fix this?
>
Sounds like you have made one or more of the functions volatile, which
means they will recalculate with every change made to the workbook. But
insertion/deletion of rows and columns will trigger all formula to
recalculate.
> In a previous post I asked about "real time" Yahoo quotes. The answer I
> received indicated that this was a possibility but you had to sign up for
> it. I attempted this but got confused â€" it seemed to me that I might be
> able to get an individual real-time quote for free but if I wanted to get a
> stream of real-time quotes it looked like I would have to pay for it. Am I
> correct in this assumption?
>
The real-time quotes option on Yahoo is a paid subscription. It's my
understanding that when logged in to your account, all quotes provided by
Yahoo are real-time.
However, they quote individual stock quotes real-time. But getting them
means grabbing data one web page at a time, and can be very slow. The
advantage of using an array-entered RCHGetYahooQuotes() is that all of the
data can be retrieved with a single Internet access, so it can be a lot
faster.
> I have created a toolbar command to "force recalculation" however, it
> seems to be unable to completely recalculate and look up fresh quotations
> unless I delete temporary files in my Internet Explorer, then close and
> reopen the sheet. There must be an easier way to do a fresh look up and
> complete recalculation. Is there?
>
You need to set your Internet Options so that a fresh copy of a web page is
retrieved every time you visit a web page. Otherwise, it can just deliver
up a cached copy of the web page. This is discussed in one of the
smfForceRecalculation entries in the LINKS area of the group.
> I created a spreadsheet that has mixed stocks and options, perhaps as many
> as 125 cells requiring lookup, and it works â€" sort of.
>
> My first problem is that if I make additions for new positions as I go
> from cell to cell it is slow as it seems to recalculate the entire sheet.
> How do I fix this?
>
Sounds like you have made one or more of the functions volatile, which
means they will recalculate with every change made to the workbook. But
insertion/deletion of rows and columns will trigger all formula to
recalculate.
> In a previous post I asked about "real time" Yahoo quotes. The answer I
> received indicated that this was a possibility but you had to sign up for
> it. I attempted this but got confused â€" it seemed to me that I might be
> able to get an individual real-time quote for free but if I wanted to get a
> stream of real-time quotes it looked like I would have to pay for it. Am I
> correct in this assumption?
>
The real-time quotes option on Yahoo is a paid subscription. It's my
understanding that when logged in to your account, all quotes provided by
Yahoo are real-time.
However, they quote individual stock quotes real-time. But getting them
means grabbing data one web page at a time, and can be very slow. The
advantage of using an array-entered RCHGetYahooQuotes(
data can be retrieved with a single Internet access, so it can be a lot
faster.
> I have created a toolbar command to "force recalculation" however, it
> seems to be unable to completely recalculate and look up fresh quotations
> unless I delete temporary files in my Internet Explorer, then close and
> reopen the sheet. There must be an easier way to do a fresh look up and
> complete recalculation. Is there?
>
You need to set your Internet Options so that a fresh copy of a web page is
retrieved every time you visit a web page. Otherwise, it can just deliver
up a cached copy of the web page. This is discussed in one of the
smfForceRecalculati
Wed Feb 27, 2013 1:12 pm (PST) . Posted by:
"andyha8" andyha8
Hello:
I am finding this software amazing! Thank you Randy.
I want to get the next earnings date for a list of stocks.
In excel, I have a list of tickers in cells A1-A12
Is there a way to use this formula:
=RCHGetTableCell("http://finance.yahoo.com/q?s=BAC&ql=1 ",1,"Next Earnings Date:",,,,0)
to get the ticker from the cells instead of having to write the ticker into the formula every time?
Thankyou
I am finding this software amazing! Thank you Randy.
I want to get the next earnings date for a list of stocks.
In excel, I have a list of tickers in cells A1-A12
Is there a way to use this formula:
=RCHGetTableCell(
to get the ticker from the cells instead of having to write the ticker into the formula every time?
Thankyou
Wed Feb 27, 2013 1:24 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
This is just a normal EXCEL operation of concatenation:
=RCHGetTableCell("http://finance.yahoo.com/q?s= "&A4,1,"Next Earnings
Date:",,,,0)
On Wed, Feb 27, 2013 at 11:13 AM, andyha8 andyha8@gmail.com > wrote:
>
> I want to get the next earnings date for a list of stocks.
>
> In excel, I have a list of tickers in cells A1-A12
>
> Is there a way to use this formula:
>
> =RCHGetTableCell("http://finance.yahoo.com/q?s=BAC&ql=1 ",1,"Next Earnings
> Date:",,,,0)
>
> to get the ticker from the cells instead of having to write the ticker
> into the formula every time?
>
=RCHGetTableCell(
Date:",
On Wed, Feb 27, 2013 at 11:13 AM, andyha8 andyha8@gmail.
>
> I want to get the next earnings date for a list of stocks.
>
> In excel, I have a list of tickers in cells A1-A12
>
> Is there a way to use this formula:
>
> =RCHGetTableCell(
> Date:",
>
> to get the ticker from the cells instead of having to write the ticker
> into the formula every time?
>
Wed Feb 27, 2013 11:44 pm (PST) . Posted by:
"Pete A" option2z
It works fine in my Office 360 version; only minor problem is that there is no longer a MDI (multi document interface) but except for some button bars I've created everything worked perfectly.
Pete A
--- In smf_addin@yahoogrou
>
> I was wondering if smf_addin works with Excel 2013. I was planning on upgrading from 2007, but won't do it if the addin is not compatible.
>
> Thanks.
>
Tidak ada komentar:
Posting Komentar