Messages In This Digest (9 Messages)
- 1a.
- Re: FCFE Free Cash Flow to Equity...where can I find this? From: Mike McQuaid
- 2a.
- Info Beyond Stock Data From: gfoster07k@sbcglobal.net
- 2b.
- Re: Info Beyond Stock Data From: Mike McQuaid
- 2c.
- Re: Info Beyond Stock Data From: adam pilz
- 2d.
- Re: Info Beyond Stock Data From: Randy Harmelink
- 3a.
- Help with a procedure/macro From: dickcopits
- 3b.
- Re: Help with a procedure/macro From: Randy Harmelink
- 3c.
- Re: Help with a procedure/macro From: Richard Copits
- 4a.
- Re: Trading Economics From: boo1712
Messages
- 1a.
-
Re: FCFE Free Cash Flow to Equity...where can I find this?
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Sat Dec 17, 2011 6:11 am (PST)
AdvFN provides the data you seek. See the RCH Get Element Number
definitions file in your SMF directory for a list.
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of investor952
Sent: Saturday, December 17, 2011 2:59 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] FCFE Free Cash Flow to Equity...where can I find this?
Can someone point me to where I may retrieve this statistic for a
stock?...and/or how I may pull down the data necessary to calculate it (Cash
flow from operations - capital expenditures + Net borrowings ) ?
I recently read in a newsletter that I get that this a very useful statistic
to use when evaluation dividend paying stocks. Thanks.
- 2a.
-
Info Beyond Stock Data
Posted by: "gfoster07k@sbcglobal.net" gfoster07k@sbcglobal.net gfoster07k@sbcglobal.net
Sat Dec 17, 2011 11:06 am (PST)
I am only marginally computer literate but have been successful using RCHGetYahooQuotes and smfPricesBetween functions almost daily for about a year now. My question is: Is there a process, using these types of add_ins, to go get info beyond stock market data? For example I might want to get data such as housing starts or unemployment figures. I assume there is some criteria that establish the accessibility of data from a broad spectrum of websites and then there is the challenge of locating and accessing it.
Thanks. I think you are performing an incredibly valueable service and hope it all ends up in a best selling book.
Greg Foster
- 2b.
-
Re: Info Beyond Stock Data
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Sat Dec 17, 2011 11:30 am (PST)
Well, the smfGetEconData has a wide variety of retrieval possibilities from
FRED. This will be your easiest if they have what you want.
Otherwise, you can extract data from ANY website (if it uses plain html)
with several smf functions:
RCHGetHTMLtable, GetTableCell, GetWebData, and GetTagContent.
I mean ANY site - sports, weather, what have you.
To figure out which of these functions is best you have to view the source
for the web page you are viewing. In your browser there will be a function
to "view source". In firefox or IE just right-click to View Page Source.
When viewing source just use browser "Find" to locate the data item you want
and then select the right RCH function to extract it. These smf functions
do the same thing as I just described - they read this source and find text
- returning some bit of info after it finds it.
This will require some modest understanding of html layout (is the item in a
table or not) but html is a very simple system that just uses its own tags
to mark the actual content. Googling for basic html examples should produce
helpful info.
Not all web pages use plain html - some use Flash, Java, or dynamic html and
these cannot be extracted by smf. You'll know it won't work when you use
the browser "view source" function and you don't see anything :(
Happy retrievals
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of gfoster07k@sbcglobal.net
Sent: Saturday, December 17, 2011 2:06 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Info Beyond Stock Data
I am only marginally computer literate but have been successful using
RCHGetYahooQuotes and smfPricesBetween functions almost daily for about a
year now. My question is: Is there a process, using these types of add_ins,
to go get info beyond stock market data? For example I might want to get
data such as housing starts or unemployment figures. I assume there is some
criteria that establish the accessibility of data from a broad spectrum of
websites and then there is the challenge of locating and accessing it.
Thanks. I think you are performing an incredibly valueable service and hope
it all ends up in a best selling book.
Greg Foster
- 2c.
-
Re: Info Beyond Stock Data
Posted by: "adam pilz" adampilz.2326@gmail.com pilzadam
Sat Dec 17, 2011 12:16 pm (PST)
I use both the smf and the fred addin for economic data depending on my end
goal. The fred add in can be found here:
http://research.stlouisfed. org/fred- addin/
however it can only get data from fred (obviously), so its use is limited
to this data.
AP
On Sat, Dec 17, 2011 at 2:32 PM, Mike McQuaid <mikemcq802@yahoo.com > wrote:
> **
>
>
> **
> Well, the smfGetEconData has a wide variety of retrieval possibilities
> from FRED. This will be your easiest if they have what you want.
>
> Otherwise, you can extract data from ANY website (if it uses plain html)
> with several smf functions:
>
> RCHGetHTMLtable, GetTableCell, GetWebData, and GetTagContent.
>
> I mean ANY site - sports, weather, what have you.
>
> To figure out which of these functions is best you have to view the source
> for the web page you are viewing. In your browser there will be a function
> to "view source". In firefox or IE just right-click to View Page Source.
> When viewing source just use browser "Find" to locate the data item you
> want and then select the right RCH function to extract it. These smf
> functions do the same thing as I just described - they read this source and
> find text - returning some bit of info after it finds it.
>
> This will require some modest understanding of html layout (is the item in
> a table or not) but html is a very simple system that just uses its own
> tags to mark the actual content. Googling for basic html examples should
> produce helpful info.
>
> Not all web pages use plain html - some use Flash, Java, or dynamic html
> and these cannot be extracted by smf. You'll know it won't work when you
> use the browser "view source" function and you don't see anything :(
>
> Happy retrievals
>
>
> --------------------- ---------
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] *On
> Behalf Of *gfoster07k@sbcglobal. net
> *Sent:* Saturday, December 17, 2011 2:06 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* [smf_addin] Info Beyond Stock Data
>
>
>
> I am only marginally computer literate but have been successful using
> RCHGetYahooQuotes and smfPricesBetween functions almost daily for about a
> year now. My question is: Is there a process, using these types of add_ins,
> to go get info beyond stock market data? For example I might want to get
> data such as housing starts or unemployment figures. I assume there is some
> criteria that establish the accessibility of data from a broad spectrum of
> websites and then there is the challenge of locating and accessing it.
>
> Thanks. I think you are performing an incredibly valueable service and
> hope it all ends up in a best selling book.
>
> Greg Foster
>
>
>
- 2d.
-
Re: Info Beyond Stock Data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Dec 17, 2011 12:41 pm (PST)
The add-in can be used on almost any web page where you can do an EXCEL Web
Query. But it can target things at a finer level of detail and target
things outside of tables.
For example, I regularly use it to access things from NetFlix. I know
others have used it to retrieve baseball box scores, golf standings, real
estate information, yellow page information, etc.
It's just a matter of finding a source of your desired data and seeing if
the add-in can access the data.
But, as already mentioned, FRED would definitely be the place to go for
economic data. Several people over on TMF compiled this list of FRED data:
http://dl.dropbox.com/u/45054803/ FRED%20Complete% 20Database. xls
Also, previously mentioned here as a possible data source of data:
http://wikiposit.org
On Sat, Dec 17, 2011 at 12:06 PM, gfoster07k@sbcglobal.net <
gfoster07k@sbcglobal.net > wrote:
> I am only marginally computer literate but have been successful using
> RCHGetYahooQuotes and smfPricesBetween functions almost daily for about a
> year now. My question is: Is there a process, using these types of
> add_ins, to go get info beyond stock market data? For example I might want
> to get data such as housing starts or unemployment figures. I assume there
> is some criteria that establish the accessibility of data from a broad
> spectrum of websites and then there is the challenge of locating and
> accessing it.
>
- 3a.
-
Help with a procedure/macro
Posted by: "dickcopits" dickcopits@hotmail.com dickcopits
Sat Dec 17, 2011 5:12 pm (PST)
I've been working on a spreadsheet and I think I'm
getting confused as to how to do something. It's probably
simple and I'm just making myself confused. Can anyone offer
the easy way to do it? What I have is a spreadsheet with ten
columns and "n" rows, the first column being "B". What I want
to do is to set a key combination that I can press that will
shift all of the columns right one column - with what was in
"J" now in "K", what was in "I", now in "J"....what was in "B"
now in "C". I realize that this is probably simple but I'm just
getting addled by different ways I can think of to do it. Thanks.
- 3b.
-
Re: Help with a procedure/macro
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Dec 17, 2011 5:20 pm (PST)
You just need to insert a column -- select a cell in the column that you
want to insert the column before and you can use the keyboard shortcut:
alt+i+c
If you select cells in multiple columns, it will insert that many columns.
PS: Question should have gone to an EXCEL help Yahoo group.
On Sat, Dec 17, 2011 at 6:12 PM, dickcopits <dickcopits@hotmail.com > wrote:
> I've been working on a spreadsheet and I think I'm
> getting confused as to how to do something. It's probably
> simple and I'm just making myself confused. Can anyone offer
> the easy way to do it? What I have is a spreadsheet with ten
> columns and "n" rows, the first column being "B". What I want
> to do is to set a key combination that I can press that will
> shift all of the columns right one column - with what was in
> "J" now in "K", what was in "I", now in "J"....what was in "B"
> now in "C". I realize that this is probably simple but I'm just
> getting addled by different ways I can think of to do it. Thanks.
>
- 3c.
-
Re: Help with a procedure/macro
Posted by: "Richard Copits" dickcopits@hotmail.com dickcopits
Sat Dec 17, 2011 5:39 pm (PST)
Noted. It was that simple? I'm getting really loopy....thanks. Sorry for the bother...
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Sat, 17 Dec 2011 18:20:50 -0700
Subject: Re: [smf_addin] Help with a procedure/macro
You just need to insert a column -- select a cell in the column that you want to insert the column before and you can use the keyboard shortcut: alt+i+c
If you select cells in multiple columns, it will insert that many columns.
PS: Question should have gone to an EXCEL help Yahoo group.
On Sat, Dec 17, 2011 at 6:12 PM, dickcopits <dickcopits@hotmail.com > wrote:
I've been working on a spreadsheet and I think I'm
getting confused as to how to do something. It's probably
simple and I'm just making myself confused. Can anyone offer
the easy way to do it? What I have is a spreadsheet with ten
columns and "n" rows, the first column being "B". What I want
to do is to set a key combination that I can press that will
shift all of the columns right one column - with what was in
"J" now in "K", what was in "I", now in "J"....what was in "B"
now in "C". I realize that this is probably simple but I'm just
getting addled by different ways I can think of to do it. Thanks.
- 4a.
-
Re: Trading Economics
Posted by: "boo1712" boo1712@yahoo.co.uk boo1712
Sun Dec 18, 2011 12:42 am (PST)
We cannot download the data but at least we can download the chart using:
=rchcreatecomment("http://www.tradinge conomics. "&$B2&"-"&AC2&com/charts/ ".png",99, 200,152,1, ,)
where cell b2 = china, cell ac2 = imports
--- In smf_addin@yahoogroups.com , famwencong@... wrote:
>
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Nope. Not with the add-in.
> >
> > On Fri, Dec 9, 2011 at 7:48 AM, newengwongpeggy <tong82@> wrote:
> >
> > >
> > > Possible to download the data from the charts?
> > >
> > > http://www.tradingeconomics. com/china/ imports
> > >
> >
>
> get FRED
>
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