15 New Messages
Digest #2362
2
Newbie question: Are the quotes pulled in from Yahoo real time? by "vancouvertesla" vancouvertesla
10
Installing on Win 7 (64 bit) with Excel 2007 Instructions by "confusciousficorp" confusciousficorp
Messages
Sat Oct 6, 2012 11:57 am (PDT) . Posted by:
"Ron Spruell" hashky
You could calculate it using finviz.com "SMA200".
I asked Randy about this once. He told me to use RCHGetYahooHistory() and calculate my own. That is what I do now in a 2 column by 300 row array.
If you have a lot of tickers, you would be better off using finviz.com.
Ron Spruell
>________________________________
> From: Craig <craig.sander@comcast.net >
>To: smf_addin@yahoogroups.com
>Sent: Thursday, October 4, 2012 5:14 PM
>Subject: [smf_addin] RE: 50 day moving average
>
>
>
>A follow-up to my question regarding inaccurate moving averages using RCHGetYahooQuotes. The Add-in and function seem to be working properly, Yahoo just has the wrong info. Does anyone have a good source for pulling moving averages?
>
>Craig
>
>
>
>
I asked Randy about this once. He told me to use RCHGetYahooHistory(
If you have a lot of tickers, you would be better off using finviz.com.
Ron Spruell
>___________
> From: Craig <craig.sander@
>To: smf_addin@yahoogrou
>Sent: Thursday, October 4, 2012 5:14 PM
>Subject: [smf_addin] RE: 50 day moving average
>
>
>
>A follow-up to my question regarding inaccurate moving averages using RCHGetYahooQuotes. The Add-in and function seem to be working properly, Yahoo just has the wrong info. Does anyone have a good source for pulling moving averages?
>
>Craig
>
>
>
>
Sat Oct 6, 2012 12:46 pm (PDT) . Posted by:
"vancouvertesla" vancouvertesla
For example if I enter:
=rchgetyahooquotes("msn","k1") will I get back last trade and time of last trade?
I realize I can wait till markets open tomorrow to figure this out...just wondering if anyone can answer me now :)
Cheers
Brandon
=rchgetyahooquotes(
I realize I can wait till markets open tomorrow to figure this out...just wondering if anyone can answer me now :)
Cheers
Brandon
Sat Oct 6, 2012 12:46 pm (PDT) . Posted by:
"Brandon" vancouvertesla
Hey Mike,
I think the trick is pulling the quotes from Google...it's easy enough to
do from within Google Docs Spreadsheets but I can't seem to find a way to
pull in off Google into excel. I thought maybe the smf add-in but I don't
think so (I could be wrong just started tooling with it)...there's a few
solutions out there other than smf but they are all limited in that you
have to manually go into each stock ticker and select it...but a pain if
you want to track a few hundred tickers in excel.
If anyone knows how to pull real time quotes off google using smf can you
please help?
Cheers
Brandon
I think the trick is pulling the quotes from Google...it'
do from within Google Docs Spreadsheets but I can't seem to find a way to
pull in off Google into excel. I thought maybe the smf add-in but I don't
think so (I could be wrong just started tooling with it)...there'
solutions out there other than smf but they are all limited in that you
have to manually go into each stock ticker and select it...but a pain if
you want to track a few hundred tickers in excel.
If anyone knows how to pull real time quotes off google using smf can you
please help?
Cheers
Brandon
Sat Oct 6, 2012 12:46 pm (PDT) . Posted by:
"Shrek" theothershrek
Hi.
I just learned about the data downloading. I am running into an issue similar to
http://finance.groups.yahoo.com/group/smf_addin/message/19853
I just downloaded and installed everything a few days ago so I should have the latest. I verified that the codes are the same by following the links from the above post.
I am trying to get MSN Earnings Estimates Growth Rates. Specifically, my cell would look like this:
=RCHGetElementNumber("AAPL", 430)
(I ultimately want 430, 431, 432, 433 but none of them work.)
but it always returns "Error". I can get the information from Yahoo by using
=RCHGetElementNumber("AAPL", 601)
but for many companies, they are vastly different numbers. Just saying. So we want the MSN values.
What do I need to do to get the MSN values?
Thanks.
I just learned about the data downloading. I am running into an issue similar to
http://finance.
I just downloaded and installed everything a few days ago so I should have the latest. I verified that the codes are the same by following the links from the above post.
I am trying to get MSN Earnings Estimates Growth Rates. Specifically, my cell would look like this:
=RCHGetElementNumbe
(I ultimately want 430, 431, 432, 433 but none of them work.)
but it always returns "Error". I can get the information from Yahoo by using
=RCHGetElementNumbe
but for many companies, they are vastly different numbers. Just saying. So we want the MSN values.
What do I need to do to get the MSN values?
Thanks.
Sat Oct 6, 2012 12:46 pm (PDT) . Posted by:
"tchconsulting" tchconsulting
I would like to try the Add-In
How do I get access to it?
How do I get access to it?
Sat Oct 6, 2012 12:46 pm (PDT) . Posted by:
"i_o_u_love" i_o_u_love
Hi,
Use the following in the Dividend Income calculation..
=IFERROR(<Your dividend income calculation formula>,0)
That would take out all the #Value from the dividend income and you would be able to get a nice sum and project your dividends :)
-Kris.
--- In smf_addin@yahoogroups.com , "bobc94595" <conlonrc@...> wrote:
>
> I have a spreadsheet with one column which uses RCHGetElementNumber(ticker, 46), to get Dividend Rates for about 25 stocks. Those stocks that do not pay dividends return "NA", without the quotes. I am using that Dividend Rate column information to calculate another column of Dividend Income, but I get a #VALUE! in the Dividend Income column for any stock with an NA in the Dividend Rate column.
> Do you have a formula to convert NA to zero in the Dividend Rate column?
>
Use the following in the Dividend Income calculation.
=IFERROR(<Your dividend income calculation formula>,0)
That would take out all the #Value from the dividend income and you would be able to get a nice sum and project your dividends :)
-Kris.
--- In smf_addin@yahoogrou
>
> I have a spreadsheet with one column which uses RCHGetElementNumber
> Do you have a formula to convert NA to zero in the Dividend Rate column?
>
Sat Oct 6, 2012 12:47 pm (PDT) . Posted by:
"dlx_0lb" dlx_0lb
Hi,
I signed up to reuters.com and market.ft.com and , I log into reuters.com and market.ft.com via Excel Web Query, and start using RCHGetHTMLTable function.
It worked fine for the first ticker, but return blanks for the rest.
Delete all of cookies, history, temporary files etc, relog, but it worked for another first ticker.
Any idea ?
I signed up to reuters.com and market.ft.com and , I log into reuters.com and market.ft.com via Excel Web Query, and start using RCHGetHTMLTable function.
It worked fine for the first ticker, but return blanks for the rest.
Delete all of cookies, history, temporary files etc, relog, but it worked for another first ticker.
Any idea ?
Sat Oct 6, 2012 12:47 pm (PDT) . Posted by:
"Gregory Clapper" borg_of_borgs
Hi, new to the group and wondering if there is a location to pull historical financial report data for large groups of stocks, looking for 10 years of annual EPS data for starters.
Thanks
Thanks
Sat Oct 6, 2012 12:48 pm (PDT) . Posted by:
"lamb_cal" lamb_cal
SAME!
--- In smf_addin@yahoogroups.com , "red_rackam" <red_rackam@...> wrote:
>
> Hi,
>
> Has anyone ever tried this on a mac ? I am getting an error stating - can't find project or library
>
> This is what the window looks like -
>
> Microsoft Office 14.0 Object libray
> MISSING: Microsoft Internet Controls
> MISSING: Microsoft XML, v3.0
> MISSING: Microsoft HTML Object Library
>
--- In smf_addin@yahoogrou
>
> Hi,
>
> Has anyone ever tried this on a mac ? I am getting an error stating - can't find project or library
>
> This is what the window looks like -
>
> Microsoft Office 14.0 Object libray
> MISSING: Microsoft Internet Controls
> MISSING: Microsoft XML, v3.0
> MISSING: Microsoft HTML Object Library
>
Sat Oct 6, 2012 12:48 pm (PDT) . Posted by:
"confusciousficorp" confusciousficorp
Hi there,
I am looking at this and want to install it on my machine but can't seem to find clear guidance on installing on a Win 7 (64 bit) machine running excel 2007.
The Add-In Overview (that I have seen so far) refers to Excel 2002 and I see from the strings that there are some possible problems installing on my set up.
Can anyone help with any kind of step by step install instruction on the setup above?
I am looking at this and want to install it on my machine but can't seem to find clear guidance on installing on a Win 7 (64 bit) machine running excel 2007.
The Add-In Overview (that I have seen so far) refers to Excel 2002 and I see from the strings that there are some possible problems installing on my set up.
Can anyone help with any kind of step by step install instruction on the setup above?
Sat Oct 6, 2012 12:49 pm (PDT) . Posted by:
"marcossouza4955" marcossouza4955
All,
I'm using Windows 7 64bits MS Office 2010 64bits. Sorry for the extra details but I just want make sure the pluggin is compatible.
I'm trying the following, however, all that I get as result is a single cell where it says "Ticker Symbol". Any advice?
=smfGetOptionQuotes("C","zbaefsvx123456",1, 1)
Thanks, Marcos.
I'm using Windows 7 64bits MS Office 2010 64bits. Sorry for the extra details but I just want make sure the pluggin is compatible.
I'm trying the following, however, all that I get as result is a single cell where it says "Ticker Symbol". Any advice?
=smfGetOptionQuotes
Thanks, Marcos.
Sat Oct 6, 2012 12:49 pm (PDT) . Posted by:
"zbgb952" zbgb952
Does anyone know where I can use smf to find the statistic
Price/Funds from Operations?..for any given stock?
Can someone provide the smf formula to do this? Thanks.
Price/Funds from Operations?.
Can someone provide the smf formula to do this? Thanks.
Sat Oct 6, 2012 12:50 pm (PDT) . Posted by:
"zbgb952" zbgb952
Can someone show me where/how I may get, using smf, the price/ffo ratio where ffo is funds from operations? I understand this metric is useful for reits and business development companies. Thanks.
Sat Oct 6, 2012 12:49 pm (PDT) . Posted by:
"David Brower" davidbrower37
What is the meaning of the two parameters PDim1 and PDim2. I can't seem to
find this in the documentation?
Thank you
find this in the documentation?
Thank you
Sat Oct 6, 2012 12:50 pm (PDT) . Posted by:
"RFM" ronfm1996
Try these:
Dow Jones Industrial Average
DJIA
Dow Jones Transportation Average
DJT
Dow Jones Utility Average Index
DJU
NASDAQ 100 Index (NASDAQ Calculation)
NDX
NASDAQ Composite Index
COMP
NYSE Composite Index
NYA
S&P 500 Index
SPX
S&P 400 Mid Cap Index
MID
S&P 100 Index
OEX
NASDAQ Computer Index
IXCO
Inter@ctive Week Internet Index
IIX
Morgan Stanley High-Technology 35 Index
MSH
PHLX Semiconductor Index
SOX
Dow Jones U.S. Total Stock Market Index (full-cap)
DWC
PHLX Gold/Silver Index
XAU
NYSE Arca Oil Index
XOI
Russell 2000 Index (Nasdaq)
RUT
Dow Jones Industrial Average
DJIA
Dow Jones Transportation Average
DJT
Dow Jones Utility Average Index
DJU
NASDAQ 100 Index (NASDAQ Calculation)
NDX
NASDAQ Composite Index
COMP
NYSE Composite Index
NYA
S&P 500 Index
SPX
S&P 400 Mid Cap Index
MID
S&P 100 Index
OEX
NASDAQ Computer Index
IXCO
Inter@ctive Week Internet Index
IIX
Morgan Stanley High-Technology 35 Index
MSH
PHLX Semiconductor Index
SOX
Dow Jones U.S. Total Stock Market Index (full-cap)
DWC
PHLX Gold/Silver Index
XAU
NYSE Arca Oil Index
XOI
Russell 2000 Index (Nasdaq)
RUT
Tidak ada komentar:
Posting Komentar