Messages In This Digest (7 Messages)
- 1a.
- question on refresh and forcerecalculation From: wu_ming_sg
- 1b.
- Re: question on refresh and forcerecalculation From: Randy Harmelink
- 1c.
- Re: question on refresh and forcerecalculation From: wu_ming_sg
- 2a.
- get Reuters cookie using VBA From: pinetreelondon
- 2b.
- Re: get Reuters cookie using VBA From: Randy Harmelink
- 3a.
- Re: Free Cash Flow per Share From: Pete
- 3b.
- Re: Free Cash Flow per Share From: Pete
Messages
- 1a.
-
question on refresh and forcerecalculation
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Thu Nov 17, 2011 4:29 am (PST)
Hi,
When I use eg. "RCHGetYahooQuotes(Ticker,"v" ,,NOW())" , how does it renew
its data?
Does it re-download the webpage just like SMFForceReCalculation?
Regards,hong
- 1b.
-
Re: question on refresh and forcerecalculation
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Nov 17, 2011 8:36 am (PST)
NOW() is a volatile function, so it makes the RCHGetYahooQuotes() function
volatile. Then, whenever a change is made in the worksheet, or if you
request recalculation via something like the F9 key, it will trigger a
recalculation by EXCEL.
Since this function retrieves a CSV file, there is no web page to
re-download. But it does get a new copy of the CSV file -- ALWAYS. That's
because the entire file is consumed whenever the function is run. Other
functions, like RCHGetTableCell(), only get a single item off of the web
page it is getting the data from. I store the web page first, then extract
the data from the stored copy of the web page, because otherwise every
function getting another data item from the same URL would need to retrieve
the web page again -- which would be VERY slow.
But that's also why RCHGetYahooQuotes() should be used as an array-entered
function -- if you use individual functions, EACH function goes back to the
Internet EVERY TIME it recalculates. But, as an array-entered function, it
can retrieve thousands of data items with a single Internet access. That's
a much faster recalculation. :)
On Thu, Nov 17, 2011 at 5:29 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> When I use eg. "RCHGetYahooQuotes(Ticker,"v" ,,NOW())" , how does it renew
> its data?
>
> Does it re-download the webpage just like SMFForceReCalculation?
>
>
- 1c.
-
Re: question on refresh and forcerecalculation
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Thu Nov 17, 2011 1:18 pm (PST)
Thank you for the great explanation!
The use of array for yahoo quotes has helped me to shave off a few
seconds off my template's calculation.
Thanks again!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...>
wrote:
>
> NOW() is a volatile function, so it makes the RCHGetYahooQuotes()
function
> volatile. Then, whenever a change is made in the worksheet, or if you
> request recalculation via something like the F9 key, it will trigger a
> recalculation by EXCEL.
>
> Since this function retrieves a CSV file, there is no web page to
> re-download. But it does get a new copy of the CSV file -- ALWAYS.
That's
> because the entire file is consumed whenever the function is run.
Other
> functions, like RCHGetTableCell(), only get a single item off of the
web
> page it is getting the data from. I store the web page first, then
extract
> the data from the stored copy of the web page, because otherwise every
> function getting another data item from the same URL would need to
retrieve
> the web page again -- which would be VERY slow.
>
> But that's also why RCHGetYahooQuotes() should be used as an
array-entered
> function -- if you use individual functions, EACH function goes back
to the
> Internet EVERY TIME it recalculates. But, as an array-entered
function, it
> can retrieve thousands of data items with a single Internet access.
That's
> a much faster recalculation. :)
>
> On Thu, Nov 17, 2011 at 5:29 AM, wu_ming_sg nghongchong@... wrote:
>
> >
> > When I use eg. "RCHGetYahooQuotes(Ticker,"v" ,,NOW())" , how does it
renew
> > its data?
> >
> > Does it re-download the webpage just like SMFForceReCalculation?
> >
> >
>
- 2a.
-
get Reuters cookie using VBA
Posted by: "pinetreelondon" vanhulten@yahoo.com pinetreelondon
Thu Nov 17, 2011 7:06 am (PST)
Reuters is one of those sites that require you to do a web query to get a cookie before you want to get the historical financials out. There others like Morningstar.
Does anyone know/have an idea how to make a VBA script that can do this for you, when given the login id and password? That way you can automate this process rather than having to manually browse through the site everyday before you want to get some information out.
Many thanks for the help!
- 2b.
-
Re: get Reuters cookie using VBA
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Nov 17, 2011 8:45 am (PST)
Do a Google search on:
excel vba "InternetExplorer.Application" password
...and you'll find tons of examples.
On Thu, Nov 17, 2011 at 8:06 AM, pinetreelondon <vanhulten@yahoo.com > wrote:
> Reuters is one of those sites that require you to do a web query to get a
> cookie before you want to get the historical financials out. There others
> like Morningstar.
>
> Does anyone know/have an idea how to make a VBA script that can do this
> for you, when given the login id and password? That way you can automate
> this process rather than having to manually browse through the site
> everyday before you want to get some information out.
>
- 3a.
-
Re: Free Cash Flow per Share
Posted by: "Pete" petekoch@yahoo.com petekoch
Thu Nov 17, 2011 8:09 am (PST)
Try elements 7766-7775 from AdvFN (in smf-elements-7.txt). I don't use these elements, so I can't vouch for accuracy. I prefer to just divide FCF by #shares; these numbers are available from multiple sources in the financial statements.
--- In smf_addin@yahoogroups.com , Ron Spruell <hashky@...> wrote:
>
> Does anyone know of a reliable source of Free Cash Flow per share? I am interested in MLPs and REITs that depend on FCF/Share.
>
> An example is NRGY (from ValueLine 9/9/2011 for the year 2011):
>
> Cash Flow per Unit 1.55
> Earnings per Unit 0.50
> Dist. Decl'd per Unit 2.82
> Capital Spending per Unit 0.90
>
- 3b.
-
Re: Free Cash Flow per Share
Posted by: "Pete" petekoch@yahoo.com petekoch
Thu Nov 17, 2011 8:15 am (PST)
Another caveat is the reliability of FCF in the financial statements. FCF is not readily available for financial firms, whose statements differ from those of non-financial firms. I suspect there are differences for MLPs and I am certain that obtaining FCF for REITs won't be that easy.
--- In smf_addin@yahoogroups.com , "Pete" <petekoch@...> wrote:
>
> Try elements 7766-7775 from AdvFN (in smf-elements-7.txt). I don't use these elements, so I can't vouch for accuracy. I prefer to just divide FCF by #shares; these numbers are available from multiple sources in the financial statements.
>
> --- In smf_addin@yahoogroups.com , Ron Spruell <hashky@> wrote:
> >
> > Does anyone know of a reliable source of Free Cash Flow per share? I am interested in MLPs and REITs that depend on FCF/Share.
> >
> > An example is NRGY (from ValueLine 9/9/2011 for the year 2011):
> >
> > Cash Flow per Unit 1.55
> > Earnings per Unit 0.50
> > Dist. Decl'd per Unit 2.82
> > Capital Spending per Unit 0.90
> >
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
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