9 New Messages
Digest #2481
Messages
Fri Jan 25, 2013 8:08 am (PST) . Posted by:
"Shri" truebangalorean
Thanks .. will checkout the vba routine..
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> You need to click the "Start Updates" button to start the process. A VBA
> routine runs the updates.
>
> On Thu, Jan 24, 2013 at 9:05 AM, Shri K wrote:
>
> >
> > In your timed refresh RCHGetYahooQuotes file, what makes it refresh itself
> > using the time mentioned in the rows above. Because the RCHGetYahooQuotes
> > seems to be the same as the usual function.
> >
>
--- In smf_addin@yahoogrou
>
> You need to click the "Start Updates" button to start the process. A VBA
> routine runs the updates.
>
> On Thu, Jan 24, 2013 at 9:05 AM, Shri K wrote:
>
> >
> > In your timed refresh RCHGetYahooQuotes file, what makes it refresh itself
> > using the time mentioned in the rows above. Because the RCHGetYahooQuotes
> > seems to be the same as the usual function.
> >
>
Fri Jan 25, 2013 10:47 am (PST) . Posted by:
"y_charles_2000" y_charles_2000
Good morning,
I need a hand to retrieve from yahoo or google finance the sector or the industry for a given stock on excel?
Any help would be greatly appreciate !!
Thanks,
Charles
I need a hand to retrieve from yahoo or google finance the sector or the industry for a given stock on excel?
Any help would be greatly appreciate !!
Thanks,
Charles
Fri Jan 25, 2013 12:10 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You can use RCHGetElementNumber() to get it from Yahoo:
*#* *Source* *Element* *Example: IBM* 13865 YahooIN Sector Name Technology
13867 YahooIN Industry Name Diversified Computer Systems
But be aware that different data providers have different groupings.
On Fri, Jan 25, 2013 at 9:05 AM, y_charles_2000 y_charles_2000@yahoo.com >wrote:
>
> I need a hand to retrieve from yahoo or google finance the sector or the
> industry for a given stock on excel?
> Any help would be greatly appreciate !!
>
*#* *Source* *Element* *Example: IBM* 13865 YahooIN Sector Name Technology
13867 YahooIN Industry Name Diversified Computer Systems
But be aware that different data providers have different groupings.
On Fri, Jan 25, 2013 at 9:05 AM, y_charles_2000 y_charles_2000@
>
> I need a hand to retrieve from yahoo or google finance the sector or the
> industry for a given stock on excel?
> Any help would be greatly appreciate !!
>
Fri Jan 25, 2013 11:02 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
You must use the adjusted for dividend or you are using invalid data. The
stock's price is reduced by the dividend amount on Ex-dividend date. Share
holders get the cash dividend but they lose the same amount in stock value.
If you are trying to determine total gain of a position then you need to
apply both the stock gain/loss and the dividend issued.
To do otherwise, results in incomplete results.
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of lexstar
Sent: Friday, January 25, 2013 7:19 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Price Only OHLC
You do have a point about the splits.
What I am hoping to do is to ignore the dividends so that I can see what the
true movement of the stock is with just its OHLC prices.
So splits will present another problem with the way I'm thinking.
Hmm, what to do then?
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Then you'll need to retrieve the 12 monthly OHLC amounts using
> RCHGetYahooHistory() and compute your own...
>
> Just curious -- of what use are unadjusted OHLC during the year? For
> example, if a stock had a 2-for-1 split mid-year, your high for the
> year will no doubt be prior to the stock split, and your low for the
> year will no doubt be after the stock split, and closing price of the
> year should be about half the opening price of the year. That's why I
> never even considered anything other than adjusted prices for
smfPricesBetween().
>
> For example, look at the unadjusted prices on FMC:
>
> Open for 2012 = $86.24
> High for 2012 = $112.89
> Low for 2012 = $48.35
> Close for 2012 = $58.52
>
> Yet the stock had a total return of 37% for the year, even though the
> unadjusted close is 32% less than the unadjusted open.
>
> On Thu, Jan 24, 2013 at 8:25 PM, lexstar wrote:
>
> > I do wanted just 1 row and 4 columns of data...
> >
> > I want the OHLC for the period between the 2 dates, not just the
> > last month.
> >
> > I don't want to download the whole history each month's OHLC from
> > the beginning of the period to the end.
> >
> > I try the SMFPricesBetween(), but that only provides me with the
> > adjusted OHLC prices, which is not want. I want the "non-adjusted"
OHLC.
> >
> > And, the RCHGetYahooQuotes() has its limitations.
> >
> > So, if any function that could provide me with the same thing as the
> > smfPricesBetween(), but only gives me the "non-adjusted" prices,
> > that would solve my problem.
> >
>
------------------------------------
Yahoo! Groups Links
stock's price is reduced by the dividend amount on Ex-dividend date. Share
holders get the cash dividend but they lose the same amount in stock value.
If you are trying to determine total gain of a position then you need to
apply both the stock gain/loss and the dividend issued.
To do otherwise, results in incomplete results.
-----Original Message-----
From: smf_addin@yahoogrou
Of lexstar
Sent: Friday, January 25, 2013 7:19 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: Price Only OHLC
You do have a point about the splits.
What I am hoping to do is to ignore the dividends so that I can see what the
true movement of the stock is with just its OHLC prices.
So splits will present another problem with the way I'm thinking.
Hmm, what to do then?
--- In smf_addin@yahoogrou
>
> Then you'll need to retrieve the 12 monthly OHLC amounts using
> RCHGetYahooHistory(
>
> Just curious -- of what use are unadjusted OHLC during the year? For
> example, if a stock had a 2-for-1 split mid-year, your high for the
> year will no doubt be prior to the stock split, and your low for the
> year will no doubt be after the stock split, and closing price of the
> year should be about half the opening price of the year. That's why I
> never even considered anything other than adjusted prices for
smfPricesBetween(
>
> For example, look at the unadjusted prices on FMC:
>
> Open for 2012 = $86.24
> High for 2012 = $112.89
> Low for 2012 = $48.35
> Close for 2012 = $58.52
>
> Yet the stock had a total return of 37% for the year, even though the
> unadjusted close is 32% less than the unadjusted open.
>
> On Thu, Jan 24, 2013 at 8:25 PM, lexstar wrote:
>
> > I do wanted just 1 row and 4 columns of data...
> >
> > I want the OHLC for the period between the 2 dates, not just the
> > last month.
> >
> > I don't want to download the whole history each month's OHLC from
> > the beginning of the period to the end.
> >
> > I try the SMFPricesBetween(
> > adjusted OHLC prices, which is not want. I want the "non-adjusted&
OHLC.
> >
> > And, the RCHGetYahooQuotes(
> >
> > So, if any function that could provide me with the same thing as the
> > smfPricesBetween(
> > that would solve my problem.
> >
>
------------
Yahoo! Groups Links
Fri Jan 25, 2013 2:38 pm (PST) . Posted by:
"Rosendo Manuel" rosendojose
Randy, my apologies for my tardiness but this has been a very diabolical week with the accounting close of accounts.
Regarding your code alteration, using only the element numbers instead ("~~~~~",xxxx), it's better an easier now.:)
However, using your example with the element number 10786, I get an error again.
I don't understand why all is fine eith you in Piotroski formulas and I have errors only with numbers 15002, 15004 to 15006 and 15008 to 15011. The others are fine.
Do you have any idea or sugestion what might cause this divergence between ours spreadsheets?
Thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> The smfUpdateDownloadTable issue with elements 826 and 848 are because of
> the way those elements are defined -- as another formula.
>
> If I just change "RCHGetElementNumber("~~~~~",848)" and
> "RCHGetElementNumber("~~~~~",826)" to "848" and "826", they work fine here.
> That's because I added code to the last release of the add-in that bypasses
> the RCHGetElementNumber() function and goes directly to the other function.
>
> For example, element 848 is defined as:
>
> 0+smfStrExtr(smfGetTagContent("
> http://www.zacks.com/stock/quote/~~~~~/detailed-estimates ","p",-1,"Zacks
> Rank:"),": ","-")
>
> The Piotroski and Altman section of your workbook works fine for me:
>
> Number *AAPL* Piotroski 1 15001 *1* *AAPL* Piotroski 2 15002 *1* *
> AAPL* Piotroski 3 15003 *1* *AAPL* Piotroski 4 15004 *1* *AAPL* Piotroski
> 5 15005 * * *AAPL* Piotroski 6 15006 * * *AAPL* Piotroski 7 15007 * * *
> AAPL* Piotroski 8 15008 *1* *AAPL* Piotroski 9 15009 * * *AAPL* Piotroski
> Score 15010 *5* *AAPL* Altman Z Score 15011 *7.7477416*
> What are you seeing? Those use AdvFN elements -- do you have issues with
> those? For example, what do you get with:
>
> =RCHGetElementNumber("MMM";, 10786)
>
> On Sun, Jan 20, 2013 at 1:00 PM, Rosendo Jose wrote:
>
> >
> > Once more I need your help to understand the origin of some errors results
> > in specific RCHGetElementNumbers fomulas as you can see in the attached
> > spreadsheet.
> >
> > I've two kinds of errors:
> >
> > The first one is the most strange. Using the SMFUpdateDownloadTable macro,
> > I obtain "error" for formulas as "Zacks Rank" (848), "Stock Signal" (826)
> > and so on. However, typing directly the RCHGetElementNumber formula I
> > obtain the correct information. Why the divergence?
> >
> > The second, is an older one, because applying the formula to Piotroski and
> > Altman scores (15010 and 15011). I never could obtain any information for
> > these indicators.
> >
> > For your better reference, I'm using Excel 2010 and the last version of
> > SMF (dated December, 29).
> >
> >
>
Regarding your code alteration, using only the element numbers instead ("~~~~~
However, using your example with the element number 10786, I get an error again.
I don't understand why all is fine eith you in Piotroski formulas and I have errors only with numbers 15002, 15004 to 15006 and 15008 to 15011. The others are fine.
Do you have any idea or sugestion what might cause this divergence between ours spreadsheets?
Thanks
--- In smf_addin@yahoogrou
>
> The smfUpdateDownloadTa
> the way those elements are defined -- as another formula.
>
> If I just change "RCHGetElement
> "RCHGetElement
> That's because I added code to the last release of the add-in that bypasses
> the RCHGetElementNumber
>
> For example, element 848 is defined as:
>
> 0+smfStrExtr(
> http://www.zacks.
> Rank:")
>
> The Piotroski and Altman section of your workbook works fine for me:
>
> Number *AAPL* Piotroski 1 15001 *1* *AAPL* Piotroski 2 15002 *1* *
> AAPL* Piotroski 3 15003 *1* *AAPL* Piotroski 4 15004 *1* *AAPL* Piotroski
> 5 15005 * * *AAPL* Piotroski 6 15006 * * *AAPL* Piotroski 7 15007 * * *
> AAPL* Piotroski 8 15008 *1* *AAPL* Piotroski 9 15009 * * *AAPL* Piotroski
> Score 15010 *5* *AAPL* Altman Z Score 15011 *7.7477416*
> What are you seeing? Those use AdvFN elements -- do you have issues with
> those? For example, what do you get with:
>
> =RCHGetElementNumbe
>
> On Sun, Jan 20, 2013 at 1:00 PM, Rosendo Jose wrote:
>
> >
> > Once more I need your help to understand the origin of some errors results
> > in specific RCHGetElementNumber
> > spreadsheet.
> >
> > I've two kinds of errors:
> >
> > The first one is the most strange. Using the SMFUpdateDownloadTa
> > I obtain "error" for formulas as "Zacks Rank" (848), "Stock Signal" (826)
> > and so on. However, typing directly the RCHGetElementNumber formula I
> > obtain the correct information. Why the divergence?
> >
> > The second, is an older one, because applying the formula to Piotroski and
> > Altman scores (15010 and 15011). I never could obtain any information for
> > these indicators.
> >
> > For your better reference, I'm using Excel 2010 and the last version of
> > SMF (dated December, 29).
> >
> >
>
Fri Jan 25, 2013 2:44 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Take a look at the AdvFN item in the LINKS area of the group. Hopefully,
that's why you're having troubles with AdvFN.
Or, are you located in a foreign country, so that AdvFN would redirect you?
For example, if you enter this in the address bar of your browser, what
address is there after the web page is displayed:
http://www.advfn.com/p.php?pid=financials&symbol=MMM
On Fri, Jan 25, 2013 at 3:38 PM, Rosendo Manuel rosendo.jose@gmail.com >wrote:
>
> However, using your example with the element number 10786, I get an error
> again.
>
> I don't understand why all is fine eith you in Piotroski formulas and I
> have errors only with numbers 15002, 15004 to 15006 and 15008 to 15011. The
> others are fine.
>
> Do you have any idea or sugestion what might cause this divergence between
> ours spreadsheets?
>
that's why you're having troubles with AdvFN.
Or, are you located in a foreign country, so that AdvFN would redirect you?
For example, if you enter this in the address bar of your browser, what
address is there after the web page is displayed:
http://www.advfn.
On Fri, Jan 25, 2013 at 3:38 PM, Rosendo Manuel rosendo.jose@
>
> However, using your example with the element number 10786, I get an error
> again.
>
> I don't understand why all is fine eith you in Piotroski formulas and I
> have errors only with numbers 15002, 15004 to 15006 and 15008 to 15011. The
> others are fine.
>
> Do you have any idea or sugestion what might cause this divergence between
> ours spreadsheets?
>
Fri Jan 25, 2013 5:36 pm (PST) . Posted by:
"J@Y" g3m1n1980
Happy new year! I recommend the site:
http://sbs.ntue.edu.tw/discchequekevinmorris/?3You%20won%20t%20feel%20an%20urge%20to%20eat%20all%20the%20time
http://sbs.ntue.
Fri Jan 25, 2013 5:48 pm (PST) . Posted by:
"J@Y" g3m1n1980
Happy new year! I recommend the following site
http://Shardakey.com/data/?4Forget%20about%20your%20ugly%20fat%20with%20this%20stuff
http://Shardakey.
Tidak ada komentar:
Posting Komentar