9 New Messages
Digest #2488
Messages
Wed Jan 30, 2013 10:24 am (PST) . Posted by:
"freefaller6" freefaller6
Would someone please confirm the calculation for annual FCF, element 6596? I want to use this value, but it is not reporting the same number as what is available elsewhere. Using msft as an example, FCF for Y1 using the element is 12.8BN, yet as reported here (http://www.marketwatch.com/investing/stock/msft/financials/cash-flow ), its 22.94BN. Any ideas?
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Uploads by forum members/Yahoo Parameter List (1-30-13).xls
Uploaded by : calhandon bozo@donandcarla.
Description : Yahoo CSV Feed Parameter List as of January 30, 2013
You can access this file at the URL:
http://groups.
To learn more about file sharing for your group, please visit:
http://help.
Regards,
calhandon bozo@donandcarla.
Wed Jan 30, 2013 11:12 am (PST) . Posted by:
"bozo" calhandon
Just uploaded the fixed and enhanced Yahoo CSV Feed Parameter List to "Files
> Uploads by forum members". Here is the link to the file:
Yahoo Parameter List (1-30-13).xls
http://f1.grp.yahoofs.com/v1/oF8JUdBNlIF9U2v3LFQlDr1plUMcjGVJrixynyKElCRKwy
CHLGpDyMyKrxW7llSiUXrTLwj-d5R6TacHNS-CGBHdKFfgmc6d/Uploads%20by%20forum%20me
mbers/Yahoo%20Parameter%20List%20%281-30-13%29.xls>
As mentioned previously, the parameters marked with an asterisk are not
recognized by the SMF add-in when you ask it to return column headings. It
will return the data if you do not request column headings. If you use one
of these parameters in a RCHGetYahooQuotes() formula, and request the
function to return column headings, the data being retrieved will get out of
sync with the column headings. Most of these parameters are of no real
value anyway.
Enjoy!
-Don
From: bozo [mailto:bozo@donandcarla.com ]
Sent: Monday, January 28, 2013 8:55 PM
To: smf_addin@yahoogroups.com '
Subject: RE: [smf_addin] Yahoo CSV Feed Parameter List
Please disregard this list for now. There are some errors in it that I need
to fix. Sorry!
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of calhandon
Sent: Monday, January 28, 2013 7:07 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Yahoo CSV Feed Parameter List
The following is a complete list of Yahoo CSV Feed Parameters, based on
multiple sources, as of Jan 28, 2013.
The parameters marked with an asterisk are not recognized by the SMF add-in
(as of Jan 28, 2013). If you use one of these in a RCHGetYahooQuotes()
function, where you are also requesting column headings, the data being
retrieved will get out of sync with the column headings.
Enjoy ...
Param Description
a
Ask
a2
Average Daily Volume
a5
Ask Size
b
Bid
b2
Ask (Real-Time)
b3
Bid (Real-Time)
b4
Book Value
b6
Bid Size
c
Change $ - Change % (as pct)
c1
Change
c3*
Commission (Yahoo="-" SMF=N)
c6
Change (Real-Time)
c8
After Hour Change (Real-Time)
d
Dividend/Share
d1
Last Trade Date
d2*
Trade Date (Yahoo="-" SMF=N)
e
Earnings/Share
e1*
Error (N/A or error text and URLs) SMF=N
e3
Expiration date (Yahoo="N/A" even with valid Option symbol)
e7
EPS Estimate Current Year
e8
EPS Estimate Next Year
e9
EPS Estimate Next Quarter SMF=N
f6
Float Shares
g
Day's Low
g1*
Holding Gain %
g3*
Annualized Gain
g4*
Holding Gain
g5
Holding Gain % (Real-Time)
g6
Holding Gain (Real-Time)
h
Day's High
i*
More Info
i5
Order Book (Real-Time)
j
52-Week Low
j1
Market Capitalization
j3
Market Cap (Real-Time)
j4
EBITDA
j5
Change from 52-Week Low
j6
% Change from 52-Week Low
k
52-Week High
k1
Last Trade with Time (Real-Time)
k2
Change % (Real-Time)
k3
Last Trade Size
k4
Change from 52-Week High
k5
% Change from 52-Week Low
l
Last Trade with Time
l1*
Last Trade (Price Only)
l2*
High Limit
l3
Low Limit
m
Day's Range
m2
Day's Range (Real-Time)
m3
50-Day Mov Avg
m4
200-Day Mov Avg
m5
Change from 200-Day Mov Avg
m6
% Change from 200-Day Mov Avg
m7
Change from 50-Day Mov Avg
m8
% Change from 50-Day Mov Avg
n
Name
n4*
Notes
o
Open
o1
Open interest?
p
Previous Close
p1*
Price Paid
p2
Change in %
p3
Type of option
p5
Price/Sales
p6
Price/Book
q
Ex-Dividend Date
r
P/E Ratio
r1
Dividend Pay Date
r2
P/E Ratio (Real-Time)
r5
PEG Ratio
r6
Price/EPS Estimate Current Year
r7
Price/EPS Estimate Next Year
s
Symbol
s1*
Shares Owned
s3
Strike price
s7
Short Ratio
t1
Last Trade Time
t6*
Trade Links
t7
Ticker Trend
t8
Analyst One-Year Target
v
Volume
v1*
Holding Value
v7
Holding Value (Real-Time)
w
52-Week Range
w1*
Day's Value Change
w4
Day's Value Change (Real-Time)
x
Stock Exchange
y
Dividend Yield
> Uploads by forum members"
Yahoo Parameter List (1-30-13).xls
http://f1.grp.
CHLGpDyMyKrxW7llSiU
mbers/Yahoo%
As mentioned previously, the parameters marked with an asterisk are not
recognized by the SMF add-in when you ask it to return column headings. It
will return the data if you do not request column headings. If you use one
of these parameters in a RCHGetYahooQuotes(
function to return column headings, the data being retrieved will get out of
sync with the column headings. Most of these parameters are of no real
value anyway.
Enjoy!
-Don
From: bozo [mailto:bozo@donandcarla.
Sent: Monday, January 28, 2013 8:55 PM
To: smf_addin@yahoogro
Subject: RE: [smf_addin] Yahoo CSV Feed Parameter List
Please disregard this list for now. There are some errors in it that I need
to fix. Sorry!
From: smf_addin@yahoogrou
Of calhandon
Sent: Monday, January 28, 2013 7:07 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Yahoo CSV Feed Parameter List
The following is a complete list of Yahoo CSV Feed Parameters, based on
multiple sources, as of Jan 28, 2013.
The parameters marked with an asterisk are not recognized by the SMF add-in
(as of Jan 28, 2013). If you use one of these in a RCHGetYahooQuotes(
function, where you are also requesting column headings, the data being
retrieved will get out of sync with the column headings.
Enjoy ...
Param Description
a
Ask
a2
Average Daily Volume
a5
Ask Size
b
Bid
b2
Ask (Real-Time)
b3
Bid (Real-Time)
b4
Book Value
b6
Bid Size
c
Change $ - Change % (as pct)
c1
Change
c3*
Commission (Yahoo="
c6
Change (Real-Time)
c8
After Hour Change (Real-Time)
d
Dividend/Share
d1
Last Trade Date
d2*
Trade Date (Yahoo="
e
Earnings/Share
e1*
Error (N/A or error text and URLs) SMF=N
e3
Expiration date (Yahoo="
e7
EPS Estimate Current Year
e8
EPS Estimate Next Year
e9
EPS Estimate Next Quarter SMF=N
f6
Float Shares
g
Day's Low
g1*
Holding Gain %
g3*
Annualized Gain
g4*
Holding Gain
g5
Holding Gain % (Real-Time)
g6
Holding Gain (Real-Time)
h
Day's High
i*
More Info
i5
Order Book (Real-Time)
j
52-Week Low
j1
Market Capitalization
j3
Market Cap (Real-Time)
j4
EBITDA
j5
Change from 52-Week Low
j6
% Change from 52-Week Low
k
52-Week High
k1
Last Trade with Time (Real-Time)
k2
Change % (Real-Time)
k3
Last Trade Size
k4
Change from 52-Week High
k5
% Change from 52-Week Low
l
Last Trade with Time
l1*
Last Trade (Price Only)
l2*
High Limit
l3
Low Limit
m
Day's Range
m2
Day's Range (Real-Time)
m3
50-Day Mov Avg
m4
200-Day Mov Avg
m5
Change from 200-Day Mov Avg
m6
% Change from 200-Day Mov Avg
m7
Change from 50-Day Mov Avg
m8
% Change from 50-Day Mov Avg
n
Name
n4*
Notes
o
Open
o1
Open interest?
p
Previous Close
p1*
Price Paid
p2
Change in %
p3
Type of option
p5
Price/Sales
p6
Price/Book
q
Ex-Dividend Date
r
P/E Ratio
r1
Dividend Pay Date
r2
P/E Ratio (Real-Time)
r5
PEG Ratio
r6
Price/EPS Estimate Current Year
r7
Price/EPS Estimate Next Year
s
Symbol
s1*
Shares Owned
s3
Strike price
s7
Short Ratio
t1
Last Trade Time
t6*
Trade Links
t7
Ticker Trend
t8
Analyst One-Year Target
v
Volume
v1*
Holding Value
v7
Holding Value (Real-Time)
w
52-Week Range
w1*
Day's Value Change
w4
Day's Value Change (Real-Time)
x
Stock Exchange
y
Dividend Yield
Wed Jan 30, 2013 7:57 pm (PST) . Posted by:
"gz_cp" gz_cp
Randy,
The Federal Reserve database has become a very large and important collection of stocks, markets, and economic data.
http://research.stlouisfed.org/fred2/
Could you add a function to get the data from their API page?
The format is detailed here, not very complicated.
http://api.stlouisfed.org/docs/fred/series_observations.html
We just want to be able to get the time series (with dates) from the webpage into Excel cells.
Thank you very much.
XP
The Federal Reserve database has become a very large and important collection of stocks, markets, and economic data.
http://research.
Could you add a function to get the data from their API page?
The format is detailed here, not very complicated.
http://api.stlouisf
We just want to be able to get the time series (with dates) from the webpage into Excel cells.
Thank you very much.
XP
Wed Jan 30, 2013 8:07 pm (PST) . Posted by:
"gz_cp" gz_cp
Randy,
I just found that you have smfGetEconData, but does it only return data for one specific date?
Could you make a function to get the whole time series in one function call just like RCHGetHTMLTable where we can use an array function?
I asked because for high frequency data like SP500, if we want to get 50 years of history, using smfGetEconData will be too resource consuming because it needs tens of thousand functions running at the same time.
Thank you very much.
XP
--- In smf_addin@yahoogroups.com , "gz_cp" wrote:
>
> Randy,
>
> The Federal Reserve database has become a very large and important collection of stocks, markets, and economic data.
>
> http://research.stlouisfed.org/fred2/
>
>
> Could you add a function to get the data from their API page?
> The format is detailed here, not very complicated.
>
> http://api.stlouisfed.org/docs/fred/series_observations.html
>
>
> We just want to be able to get the time series (with dates) from the webpage into Excel cells.
>
>
> Thank you very much.
>
> XP
>
I just found that you have smfGetEconData, but does it only return data for one specific date?
Could you make a function to get the whole time series in one function call just like RCHGetHTMLTable where we can use an array function?
I asked because for high frequency data like SP500, if we want to get 50 years of history, using smfGetEconData will be too resource consuming because it needs tens of thousand functions running at the same time.
Thank you very much.
XP
--- In smf_addin@yahoogrou
>
> Randy,
>
> The Federal Reserve database has become a very large and important collection of stocks, markets, and economic data.
>
> http://research.
>
>
> Could you add a function to get the data from their API page?
> The format is detailed here, not very complicated.
>
> http://api.stlouisf
>
>
> We just want to be able to get the time series (with dates) from the webpage into Excel cells.
>
>
> Thank you very much.
>
> XP
>
Wed Jan 30, 2013 9:07 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
A problem arises -- the API Key would be exposed in my VBA code, since it
is open source.
On Wed, Jan 30, 2013 at 8:57 PM, gz_cp gz_cp@yahoo.com > wrote:
> Randy,
>
> The Federal Reserve database has become a very large and important
> collection of stocks, markets, and economic data.
>
> http://research.stlouisfed.org/fred2/
>
>
> Could you add a function to get the data from their API page?
> The format is detailed here, not very complicated.
>
> http://api.stlouisfed.org/docs/fred/series_observations.html
>
>
> We just want to be able to get the time series (with dates) from the
> webpage into Excel cells.
>
>
is open source.
On Wed, Jan 30, 2013 at 8:57 PM, gz_cp gz_cp@yahoo.
> Randy,
>
> The Federal Reserve database has become a very large and important
> collection of stocks, markets, and economic data.
>
> http://research.
>
>
> Could you add a function to get the data from their API page?
> The format is detailed here, not very complicated.
>
> http://api.stlouisf
>
>
> We just want to be able to get the time series (with dates) from the
> webpage into Excel cells.
>
>
Wed Jan 30, 2013 9:19 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You can get the whole time series with something like:
=smfGetCSVFile("https://research.stlouisfed.org/fred2/data/SP500.csv ")
On Wed, Jan 30, 2013 at 9:07 PM, gz_cp gz_cp@yahoo.com > wrote:
>
> I just found that you have smfGetEconData, but does it only return data
> for one specific date?
>
> Could you make a function to get the whole time series in one function
> call just like RCHGetHTMLTable where we can use an array function?
>
> I asked because for high frequency data like SP500, if we want to get 50
> years of history, using smfGetEconData will be too resource consuming
> because it needs tens of thousand functions running at the same time.
>
=smfGetCSVFile(
On Wed, Jan 30, 2013 at 9:07 PM, gz_cp gz_cp@yahoo.
>
> I just found that you have smfGetEconData, but does it only return data
> for one specific date?
>
> Could you make a function to get the whole time series in one function
> call just like RCHGetHTMLTable where we can use an array function?
>
> I asked because for high frequency data like SP500, if we want to get 50
> years of history, using smfGetEconData will be too resource consuming
> because it needs tens of thousand functions running at the same time.
>
Thu Jan 31, 2013 7:02 am (PST) . Posted by:
"boo1712" boo1712
I am currently using the FRED excel addin for FRED econ data.
However I would very much prefer to use Randy's add-in.
If only smfgetcsvfile can sort most recent dates at the top, it will be useful.
I wonder if there is any simple way to do that?
Thanks
--- In smf_addin@yahoogrou
>
> You can get the whole time series with something like:
>
> =smfGetCSVFile(
>
> On Wed, Jan 30, 2013 at 9:07 PM, gz_cp wrote:
>
> >
> > I just found that you have smfGetEconData, but does it only return data
> > for one specific date?
> >
> > Could you make a function to get the whole time series in one function
> > call just like RCHGetHTMLTable where we can use an array function?
> >
> > I asked because for high frequency data like SP500, if we want to get 50
> > years of history, using smfGetEconData will be too resource consuming
> > because it needs tens of thousand functions running at the same time.
> >
>
Thu Jan 31, 2013 7:36 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Nothing simple. You could use VBA to place values onto the worksheet, and
then sort them.
On Thu, Jan 31, 2013 at 8:02 AM, boo1712 boo1712@yahoo.co.uk > wrote:
>
> I am currently using the FRED excel addin for FRED econ data.
>
> However I would very much prefer to use Randy's add-in.
>
> If only smfgetcsvfile can sort most recent dates at the top, it will be
> useful.
>
> I wonder if there is any simple way to do that?
>
then sort them.
On Thu, Jan 31, 2013 at 8:02 AM, boo1712 boo1712@yahoo.
>
> I am currently using the FRED excel addin for FRED econ data.
>
> However I would very much prefer to use Randy's add-in.
>
> If only smfgetcsvfile can sort most recent dates at the top, it will be
> useful.
>
> I wonder if there is any simple way to do that?
>
Tidak ada komentar:
Posting Komentar