15 New Messages
Digest #2854
4
Implementing RCHGeetYahooQuotes in Windows 8 and Excel 2013 by "gfoster07k@sbcglobal.net" gfoster07k@sbcglobal.net
Messages
Tue Nov 12, 2013 6:34 am (PST) . Posted by:
julian_svirsky
Is there a limited # of requests until the addin generates an 'Error'? I am requesting 2 fields =RCHGetElementNumber(A2, 25) & =RCHGetElementNumber(A2, 13863) (name & price), iterating different tickers in A2, and after about 500 iterations I get 'Error'. Is yahoo blocking requests by IP, which is sending too many, or what is the issue here, and how do I fix it please? Many thanks in advance.
Tue Nov 12, 2013 7:23 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The add-in has a built in limitation of being able to access only 1000 web
pages per "session".
What you're trying to do should be done with something like
RCHGetYahooQuotes(), so that you can get all of the data in just a few
Internet accesses instead of needing to do 1000 of them.
RCHGetYahooQuotes() can get the name and the current stock price for up to
200 ticker symbols in one Internet access.
Also, I've obsoleted element #25 because when MSN redesigned their web page
last year, they started posting the previous day's closing prices as the
"Last Price".
On Tue, Nov 12, 2013 at 7:34 AM, <julian_svirsky@yahoo.com> wrote:
>
> Is there a limited # of requests until the addin generates an 'Error'? I
> am requesting 2 fields =RCHGetElementNumber(A2, 25) &
> =RCHGetElementNumber(A2, 13863) (name & price), iterating different tickers
> in A2, and after about 500 iterations I get 'Error'. Is yahoo blocking
> requests by IP, which is sending too many, or what is the issue here, and
> how do I fix it please? Many thanks in advance.
>
pages per "session"
What you're trying to do should be done with something like
RCHGetYahooQuotes(
Internet accesses instead of needing to do 1000 of them.
RCHGetYahooQuotes(
200 ticker symbols in one Internet access.
Also, I've obsoleted element #25 because when MSN redesigned their web page
last year, they started posting the previous day's closing prices as the
"Last Price".
On Tue, Nov 12, 2013 at 7:34 AM, <julian_svirsky@
>
> Is there a limited # of requests until the addin generates an 'Error&#
> am requesting 2 fields =RCHGetElementNumbe
> =RCHGetElementNumbe
> in A2, and after about 500 iterations I get 'Error&#
> requests by IP, which is sending too many, or what is the issue here, and
> how do I fix it please? Many thanks in advance.
>
Tue Nov 12, 2013 1:40 pm (PST) . Posted by:
julian_svirsky
Thank you very much for the quick response. I was cycling through tickers because excel was crashing due to so much data being requested at once. I actually want to retrieve about 15 pieces of data for each ticker, mainly fundamental - would RCHGetYahooQuotes() work, if so, could you please show me an example? Also, I can't seem to find the location of the newest 'beta' add-on everyone's talking about - is it updated in the files section?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
The add-in has a built in limitation of being able to access only 1000 web pages per "session".
What you're trying to do should be done with something like RCHGetYahooQuotes(), so that you can get all of the data in just a few Internet accesses instead of needing to do 1000 of them. RCHGetYahooQuotes() can get the name and the current stock price for up to 200 ticker symbols in one Internet access.
Also, I've obsoleted element #25 because when MSN redesigned their web page last year, they started posting the previous day's closing prices as the "Last Price".
On Tue, Nov 12, 2013 at 7:34 AM, <julian_svirsky@... mailto:julian_svirsky@...> wrote:
Is there a limited # of requests until the addin generates an 'Error'? I am requesting 2 fields =RCHGetElementNumber(A2, 25) & =RCHGetElementNumber(A2, 13863) (name & price), iterating different tickers in A2, and after about 500 iterations I get 'Error'. Is yahoo blocking requests by IP, which is sending too many, or what is the issue here, and how do I fix it please? Many thanks in advance.
---In smf_addin@yahoogrou
The add-in has a built in limitation of being able to access only 1000 web pages per "session"
What you're trying to do should be done with something like RCHGetYahooQuotes(
Also, I've obsoleted element #25 because when MSN redesigned their web page last year, they started posting the previous day's closing prices as the "Last Price".
On Tue, Nov 12, 2013 at 7:34 AM, <julian_svirsky@
Is there a limited # of requests until the addin generates an 'Error&#
Tue Nov 12, 2013 1:48 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The beta version of the add-in is in the "Works in Progress" folder of the
FILES area.
I guess my question would be why the data for so many tickers? There are
screening programs out there, if that is the purpose of collecting the data.
Take a look at the LINKS area of the group. It has some examples on getting
a number of data items on a number of stocks with a single Internet access.
Specifically, using RCHGetYahooQuotes() and getting data from Yahoo, or
getting data from FinViz.
On Tue, Nov 12, 2013 at 2:40 PM, <julian_svirsky@yahoo.com> wrote:
> Thank you very much for the quick response. I was cycling through
> tickers because excel was crashing due to so much data being requested at
> once. I actually want to retrieve about 15 pieces of data for each ticker,
> mainly fundamental - would RCHGetYahooQuotes() work, if so, could you
> please show me an example? Also, I can't seem to find the location of the
> newest 'beta' add-on everyone's talking about - is it updated in the files
> section?
>
FILES area.
I guess my question would be why the data for so many tickers? There are
screening programs out there, if that is the purpose of collecting the data.
Take a look at the LINKS area of the group. It has some examples on getting
a number of data items on a number of stocks with a single Internet access.
Specifically, using RCHGetYahooQuotes(
getting data from FinViz.
On Tue, Nov 12, 2013 at 2:40 PM, <julian_svirsky@
> Thank you very much for the quick response. I was cycling through
> tickers because excel was crashing due to so much data being requested at
> once. I actually want to retrieve about 15 pieces of data for each ticker,
> mainly fundamental - would RCHGetYahooQuotes(
> please show me an example? Also, I can't seem to find the location of the
> newest 'beta' add-on everyone'
> section?
>
Tue Nov 12, 2013 7:14 am (PST) . Posted by:
ronnyrode21
Hi Randy..thanks for you help..I should have bee more clearer in previous message..The url I am trying to pull is:
http://nt8.zacks.com/ZComIcaCharts/PNG/cno_eps.png http://nt8.zacks.com/ZComIcaCharts/PNG/cno_eps.png
just as you stated above..the problem is I want to enbed the cell number of a ticker in the URL. I've done it before for others but I cant seem to get this one to work. For example, on my spreadsheet I enter a stock symbol in cell B1 then press enter to retrieve all of the data I have programmed in that spreadsheet. When RCHcomment is executed I want it to grab the stock symbol in cell B1 and grab that chart for me. In essence replacing the "cno" piece of the URL. But I just cant seem to get it to work. Thanks for your help Randy.
Thanks again.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
I had no problems:
=RCHCreateComment("http://nt8.zacks.com/ZComIcaCharts/PNG/cno_eps.png http://nt8.zacks.com/ZComIcaCharts/PNG/cno_eps.png",99)
Remember, you need the URL of the *image*, not the *web page*. Any given web page could have hundreds of images on it.
On Mon, Nov 11, 2013 at 9:24 AM, <ronnyrode21@... mailto:ronnyrode21@...> wrote:
Hi everyone..I've been working on trying to pull this chart:
http://www.zacks.com/stock/chart/CNO/eps http://www.zacks.com/stock/chart/CNO/eps
from zacks..I tried using the RCHCreateComment but kept getting a Value error. I was able to pull a chart from stockcharts.com http://stockcharts.com with another URL but couldnt get the chart from zacks to work. Any advice would be appreciated.
http://nt8.zacks.
just as you stated above..the problem is I want to enbed the cell number of a ticker in the URL. I've done it before for others but I cant seem to get this one to work. For example, on my spreadsheet I enter a stock symbol in cell B1 then press enter to retrieve all of the data I have programmed in that spreadsheet. When RCHcomment is executed I want it to grab the stock symbol in cell B1 and grab that chart for me. In essence replacing the "cno" piece of the URL. But I just cant seem to get it to work. Thanks for your help Randy.
Thanks again.
---In smf_addin@yahoogrou
I had no problems:
=RCHCreateComment(
Remember, you need the URL of the *image*, not the *web page*. Any given web page could have hundreds of images on it.
On Mon, Nov 11, 2013 at 9:24 AM, <ronnyrode21@
Hi everyone..I&#
http://www.zacks.
from zacks..I tried using the RCHCreateComment but kept getting a Value error. I was able to pull a chart from stockcharts.
Tue Nov 12, 2013 7:19 am (PST) . Posted by:
"Randy Harmelink" rharmelink
This worked fine for me:
=RCHCreateComment("http://nt8.zacks.com/ZComIcaCharts/PNG/
"&B1&"_eps.png",99,,,1)
On Tue, Nov 12, 2013 at 8:14 AM, <ronnyrode21@yahoo.com> wrote:
> Hi Randy..thanks for you help..I should have bee more clearer in
> previous message..The url I am trying to pull is:
>
> http://nt8.zacks.com/ZComIcaCharts/PNG/cno_eps.png
>
> just as you stated above..the problem is I want to enbed the cell number
> of a ticker in the URL. I've done it before for others but I cant seem to
> get this one to work. For example, on my spreadsheet I enter a stock symbol
> in cell B1 then press enter to retrieve all of the data I have programmed
> in that spreadsheet. When RCHcomment is executed I want it to grab the
> stock symbol in cell B1 and grab that chart for me. In essence replacing
> the "cno" piece of the URL. But I just cant seem to get it to work. Thanks
> for your help Randy.
>
>
=RCHCreateComment(
"&B1&"
On Tue, Nov 12, 2013 at 8:14 AM, <ronnyrode21@
> Hi Randy..thanks for you help..I should have bee more clearer in
> previous message..The url I am trying to pull is:
>
> http://nt8.zacks.
>
> just as you stated above..the problem is I want to enbed the cell number
> of a ticker in the URL. I've done it before for others but I cant seem to
> get this one to work. For example, on my spreadsheet I enter a stock symbol
> in cell B1 then press enter to retrieve all of the data I have programmed
> in that spreadsheet. When RCHcomment is executed I want it to grab the
> stock symbol in cell B1 and grab that chart for me. In essence replacing
> the "cno" piece of the URL. But I just cant seem to get it to work. Thanks
> for your help Randy.
>
>
Tue Nov 12, 2013 8:11 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Randy, I saw you place a spreadsheet in the files area. Thanks for the spreadsheet.
It is a great example of dividend reinvestment.
But to be totally accurate it would need to use the pay date not the EX-Dividend date for reinvestment
However, dividends reinvestment isn't what I had in mind.
I'm trying to calculate total returns without reinvesting in the same stock.
Because I don't think most folks do dividend reinvestment.
Sure, they invest the dividends in more stock positions but not always in the same stock and certainly not right away.
I don't do dividend reinvesting because I am more of a trader than an investor.
I invest it in whatever I happen to be buying at the time the dividend hits my account which is the pay date. In some cases that is months later.
For those who do dividend reinvestment I think a spreadsheet like yours can be a big help in determining the historical return.
After all, history is all we have to go by when looking at performance. Some consider this strange because current stock prices are mostly based on implied future plans.
Once again, Thanks millions for your support,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Kermit W. Prather
Sent: Monday, November 11, 2013 7:38 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] What am I doing wrong in these formulas
]
[Attachment(s) from Kermit W. Prather included below]
I don't see how one can compute the actual profit using adjusted price. I am going to attach the spreadsheet.
Here is what it looks like. I don't see how one determines total profit with adjusted purchase price. Hopefully, you or someone else can show me how it is done.
This stock does not have any stock splits which is why I am using it as an example.
I think I provide enough information, if not let me know what else is needed.
If you open the spreadsheet you will need to adjust the links for the SMF addin.
Thanks,
Kermit
Row
1
Cell E1 contains formula
=
IF(C5> 0,RCHGetYahooHistory(C5,YEAR(E5),MONTH(E5),DAY(E5),YEAR(E5),MONTH(E5),DAY(E5),"d","c",0,0,0)," ")
2
Cell E2 contains formula
=
RCHGetYahooHistory(C5,YEAR(E5),MONTH(E5),DAY(E5),YEAR(E5),MONTH(E5),DAY(E5),"d","c",0,0,0)
3
Column
4
C
E
Shares purchased
Unjusted purchase price
adjusted purchase price
Friday unadjusted close
Friday Adjusted price
Dividend's paid out between dates
No splits on this stock
5
AGNC
Purchase date
6/27/2008
1
17.11
-6.26
21.05
21.05
26.96
6
last date
11/8/2013
100
Can you explain for me how I calculate the total profit and percentage of profit using the adjusted price. Can you do it for 1 share and 100 shares
The way I see it I paid 17.11 to purchase the stock. I was paid 26.96 in dividends. Then I sold on Friday's closing (11/8/2013. so I figure my total profit is the selling price - purchase price plus the received dividends which is ((21.05 - 17.11) + 26.96) = 30.90 the formula is ((SP - PP) = DIV payout)
Using the adjusted price I can not figure out the total profit unless I am missing something. So what would be the formula to calculate total profit using the adjusted price. ?
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Monday, November 11, 2013 6:23 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] What am I doing wrong in these formulas
Comparing adjusted prices *would* give you total return. That's the main point of using them -- so that everything is relative to each other.
In any case, your formulas don't work because 6/29/2008 was not a trading day, so there is no data to retrieve.
smfPricesByDates() fills forward for non-trading days, so you don't need to know which days were trading days or not.
On Mon, Nov 11, 2013 at 3:42 PM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
I am trying to retrieve the unadjusted closing price on a given date.
It is returning nothing. I have tried many difference methods to get the unadjusted price.
The reason I need the unadjusted price on the purchase date is in order to calculate the total returns including stock splits and dividends since purchase..
Row
1
Cell E1 contains formula
=
IF(C5> 0,RCHGetYahooHistory(C5,YEAR(E5),MONTH(E5),DAY(E5),YEAR(E5),MONTH(E5),DAY(E5),"d","c",0,0,0)," ")
2
Cell E2 contains formula
=
RCHGetYahooHistory(C5,YEAR(E5),MONTH(E5),DAY(E5),YEAR(E5),MONTH(E5),DAY(E5),"d","c",0,0,0)
3
Column
4
C
E
5
AGNC
6/29/2008
6
It is a great example of dividend reinvestment.
But to be totally accurate it would need to use the pay date not the EX-Dividend date for reinvestment
However, dividends reinvestment isn't what I had in mind.
I'm trying to calculate total returns without reinvesting in the same stock.
Because I don't think most folks do dividend reinvestment.
Sure, they invest the dividends in more stock positions but not always in the same stock and certainly not right away.
I don't do dividend reinvesting because I am more of a trader than an investor.
I invest it in whatever I happen to be buying at the time the dividend hits my account which is the pay date. In some cases that is months later.
For those who do dividend reinvestment I think a spreadsheet like yours can be a big help in determining the historical return.
After all, history is all we have to go by when looking at performance. Some consider this strange because current stock prices are mostly based on implied future plans.
Once again, Thanks millions for your support,
Kermit
From: smf_addin@yahoogrou
Sent: Monday, November 11, 2013 7:38 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] What am I doing wrong in these formulas
]
[Attachment(
I don't see how one can compute the actual profit using adjusted price. I am going to attach the spreadsheet.
Here is what it looks like. I don't see how one determines total profit with adjusted purchase price. Hopefully, you or someone else can show me how it is done.
This stock does not have any stock splits which is why I am using it as an example.
I think I provide enough information, if not let me know what else is needed.
If you open the spreadsheet you will need to adjust the links for the SMF addin.
Thanks,
Kermit
Row
1
Cell E1 contains formula
=
IF(C5> 0,RCHGetYahooHistor
2
Cell E2 contains formula
=
RCHGetYahooHistory(
3
Column
4
C
E
Shares purchased
Unjusted purchase price
adjusted purchase price
Friday unadjusted close
Friday Adjusted price
Dividend'
No splits on this stock
5
AGNC
Purchase date
6/27/2008
1
17.11
-6.26
21.05
21.05
26.96
6
last date
11/8/2013
100
Can you explain for me how I calculate the total profit and percentage of profit using the adjusted price. Can you do it for 1 share and 100 shares
The way I see it I paid 17.11 to purchase the stock. I was paid 26.96 in dividends. Then I sold on Friday's closing (11/8/2013. so I figure my total profit is the selling price - purchase price plus the received dividends which is ((21.05 - 17.11) + 26.96) = 30.90 the formula is ((SP - PP) = DIV payout)
Using the adjusted price I can not figure out the total profit unless I am missing something. So what would be the formula to calculate total profit using the adjusted price. ?
From: smf_addin@yahoogrou
Sent: Monday, November 11, 2013 6:23 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] What am I doing wrong in these formulas
Comparing adjusted prices *would* give you total return. That's the main point of using them -- so that everything is relative to each other.
In any case, your formulas don't work because 6/29/2008 was not a trading day, so there is no data to retrieve.
smfPricesByDates(
On Mon, Nov 11, 2013 at 3:42 PM, Kermit W. Prather <kermitp@tampabay.
I am trying to retrieve the unadjusted closing price on a given date.
It is returning nothing. I have tried many difference methods to get the unadjusted price.
The reason I need the unadjusted price on the purchase date is in order to calculate the total returns including stock splits and dividends since purchase..
Row
1
Cell E1 contains formula
=
IF(C5> 0,RCHGetYahooHistor
2
Cell E2 contains formula
=
RCHGetYahooHistory(
3
Column
4
C
E
5
AGNC
6/29/2008
6
Tue Nov 12, 2013 9:09 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It's not about your METHOD of investment. It's about the CALCULATION of a
total return.
If you don't include reinvestment of dividends, those aren't total returns.
Without reinvestment, any comparison of total returns would put a dividend
paying stock at a disadvantage.
That's what the company is doing with any retained earnings that they
didn't pay out as a dividend -- reinvesting it in the company.
Otherwise, you'd have to track whatever you did with each dividend, and add
that to the your return. But then every investor would get a different
total return calculation on a dividend-paying stock.
Or is your meaning of "total return" something other than the norm?
On Tue, Nov 12, 2013 at 9:10 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:
> I'm trying to calculate total returns without reinvesting in the same
> stock.
>
> Because I don't think most folks do dividend reinvestment.
>
> Sure, they invest the dividends in more stock positions but not always in
> the same stock and certainly not right away.
>
> I don't do dividend reinvesting because I am more of a trader than an
> investor.
>
> I invest it in whatever I happen to be buying at the time the dividend
> hits my account which is the pay date. In some cases that is months later.
>
>
>
> For those who do dividend reinvestment I think a spreadsheet like yours
> can be a big help in determining the historical return.
>
total return.
If you don't include reinvestment of dividends, those aren't total returns.
Without reinvestment, any comparison of total returns would put a dividend
paying stock at a disadvantage.
That's what the company is doing with any retained earnings that they
didn't pay out as a dividend -- reinvesting it in the company.
Otherwise, you'd have to track whatever you did with each dividend, and add
that to the your return. But then every investor would get a different
total return calculation on a dividend-paying stock.
Or is your meaning of "total return" something other than the norm?
On Tue, Nov 12, 2013 at 9:10 AM, Kermit W. Prather
<kermitp@tampabay.
> I'm trying to calculate total returns without reinvesting in the same
> stock.
>
> Because I don't think most folks do dividend reinvestment.
>
> Sure, they invest the dividends in more stock positions but not always in
> the same stock and certainly not right away.
>
> I don't do dividend reinvesting because I am more of a trader than an
> investor.
>
> I invest it in whatever I happen to be buying at the time the dividend
> hits my account which is the pay date. In some cases that is months later.
>
>
>
> For those who do dividend reinvestment I think a spreadsheet like yours
> can be a big help in determining the historical return.
>
Tue Nov 12, 2013 12:14 pm (PST) . Posted by:
"Kermit W. Prather" kermitpra
Randy, I certainly do not want to get into a discussion on how companies calculate their total returns.
As I mentioned previously, I am not reinvesting my dividends nor do most people. Therefore using the total return method does not apply.
I, also, mentioned that this is not about dividend reinvestment it is about tracking my complete return on the investment.
Perhaps my mistake is in using the term "Total Returns" I'll change the title to investment return.
I apologize for any misunderstanding. But it is about my METHOD not about Dividend Reinvesting.
I simply want to know the total amount that goes into or out of my account from the time I open a trade to when I close the trade that includes the dividends, stock splits and the cost of executing the trade.
I'm all for companies reinvesting the retained earnings. It is extremely important they do that. But they took back from me what they paid in dividends when they reduce the stock price on Ex-dividend date.
So if I am holding that stock on Ex-Dividend date I immediately at best breakeven. For me to receive any profit the stock has to make up that dividend payout.
Typically, high yield dividend stocks will continue to drop after Ex-Dividend date because of the reaction by the unknowing who do not realize the reason for the price drop.
In fact, I sell on my website www.tradingourway.com a High Yield Dividend Trading Strategy. I'll be glad to send you a free copy if you are interested. Let me know.
I do track what I do with that money both the losses and the profits. That dividend money goes into my account just like any other money.
But I don't have a separate bucket that says this is dividend earnings and have to account for it separately and I don't believe others do either.
Again thanks for all your support, As I said that spreadsheet will be great for dividend reinvestors.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Tuesday, November 12, 2013 12:09 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] What am I doing wrong in these formulas
It's not about your METHOD of investment. It's about the CALCULATION of a total return.
If you don't include reinvestment of dividends, those aren't total returns. Without reinvestment, any comparison of total returns would put a dividend paying stock at a disadvantage.
That's what the company is doing with any retained earnings that they didn't pay out as a dividend -- reinvesting it in the company.
Otherwise, you'd have to track whatever you did with each dividend, and add that to the your return. But then every investor would get a different total return calculation on a dividend-paying stock.
Or is your meaning of "total return" something other than the norm?
On Tue, Nov 12, 2013 at 9:10 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
I'm trying to calculate total returns without reinvesting in the same stock.
Because I don't think most folks do dividend reinvestment.
Sure, they invest the dividends in more stock positions but not always in the same stock and certainly not right away.
I don't do dividend reinvesting because I am more of a trader than an investor.
I invest it in whatever I happen to be buying at the time the dividend hits my account which is the pay date. In some cases that is months later.
For those who do dividend reinvestment I think a spreadsheet like yours can be a big help in determining the historical return.
As I mentioned previously, I am not reinvesting my dividends nor do most people. Therefore using the total return method does not apply.
I, also, mentioned that this is not about dividend reinvestment it is about tracking my complete return on the investment.
Perhaps my mistake is in using the term "Total Returns" I'll change the title to investment return.
I apologize for any misunderstanding. But it is about my METHOD not about Dividend Reinvesting.
I simply want to know the total amount that goes into or out of my account from the time I open a trade to when I close the trade that includes the dividends, stock splits and the cost of executing the trade.
I'm all for companies reinvesting the retained earnings. It is extremely important they do that. But they took back from me what they paid in dividends when they reduce the stock price on Ex-dividend date.
So if I am holding that stock on Ex-Dividend date I immediately at best breakeven. For me to receive any profit the stock has to make up that dividend payout.
Typically, high yield dividend stocks will continue to drop after Ex-Dividend date because of the reaction by the unknowing who do not realize the reason for the price drop.
In fact, I sell on my website www.tradingourway.
I do track what I do with that money both the losses and the profits. That dividend money goes into my account just like any other money.
But I don't have a separate bucket that says this is dividend earnings and have to account for it separately and I don't believe others do either.
Again thanks for all your support, As I said that spreadsheet will be great for dividend reinvestors.
Kermit
From: smf_addin@yahoogrou
Sent: Tuesday, November 12, 2013 12:09 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] What am I doing wrong in these formulas
It's not about your METHOD of investment. It's about the CALCULATION of a total return.
If you don't include reinvestment of dividends, those aren't total returns. Without reinvestment, any comparison of total returns would put a dividend paying stock at a disadvantage.
That's what the company is doing with any retained earnings that they didn't pay out as a dividend -- reinvesting it in the company.
Otherwise, you'd have to track whatever you did with each dividend, and add that to the your return. But then every investor would get a different total return calculation on a dividend-paying stock.
Or is your meaning of "total return" something other than the norm?
On Tue, Nov 12, 2013 at 9:10 AM, Kermit W. Prather <kermitp@tampabay.
I'm trying to calculate total returns without reinvesting in the same stock.
Because I don't think most folks do dividend reinvestment.
Sure, they invest the dividends in more stock positions but not always in the same stock and certainly not right away.
I don't do dividend reinvesting because I am more of a trader than an investor.
I invest it in whatever I happen to be buying at the time the dividend hits my account which is the pay date. In some cases that is months later.
For those who do dividend reinvestment I think a spreadsheet like yours can be a big help in determining the historical return.
Tue Nov 12, 2013 9:20 am (PST) . Posted by:
"gfoster07k@sbcglobal.net" gfoster07k@sbcglobal.net
Since I am only marginally computer literate, I had a challenge implementing one of the Stock Market Functions. Once I got it working (with Randy's help), I decided to document the steps I went through in case it might be of some value to someone else. Here is the step-by-step procedure I used.
Go to C:\Program Files
Right click on a blank spot on the screen
Left click on "New" "Folder"
Create a new folder called "SMF Add In"
Use your browser to go to www.Yahoo.com
Assuming you have added "smf_addin group" to your list of groups … select that group.
Left click on "Files"
Read all the documentation associated with the Stock Market Functions!
Left click on "Add-In Files"
Left click on "RCH_Stock_
The file will download. It is still zipped and in the "Downloads&quo
Right click on it and see the options
Left click on "Extract All"
Enter the destination file as the "C:\
The computer will extract the zipped file from the "Downloads&quo
Start Excel
Open a new spreadsheet
Left click on "File"
Where it says "Manage Add ins" left click on "Go"
Left click on "Browse" and go to C:\Program Files\SMF Add In
Select the "RCH_Stock_
Left click "OK" on the Add Ins screen
At this point the add in should be ready to use.
To test the add in:
Enter "l1" in B1 (request for current stock price)
Enter "T" in A2 (stock market symbol for AT&T)
Enter "=RCHGetYahooQ
Key in "Control + Shift + Enter"
The current price of AT&T stock should appear in B2
If it does not, a possible cause is that macros are not enabled for the spreadsheet.
In Excel 2013, if the spreadsheet involves macros and the macros are not enabled, a yellow alert bar will appear and offer the option to enable the macros. It will be necessary to click on "Enable"
Tue Nov 12, 2013 5:18 pm (PST) . Posted by:
altaclip
The new Zacks element definitions seem to be working well but I wonder why the Zacks Rank is not updating in a timely manner.
i.e. JAZZ was upgraded to ZR #1 on Nov 8. I've updated my smfupdatedownloadtable many times every day Nov 9-12 and it still shows #3 for ZR.
There are other examples.
I am a Zacks premium subscriber.
Anyone else notice certain Z elements not updating in a timely manenr?
i.e. JAZZ was upgraded to ZR #1 on Nov 8. I've updated my smfupdatedownloadta
There are other examples.
I am a Zacks premium subscriber.
Anyone else notice certain Z elements not updating in a timely manenr?
Tue Nov 12, 2013 5:27 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I just tried it and got a 1 rating back.
Do you have your Internet Options set to always get new content? Maybe IE
is giving up cached web pages...although 4 days seems like quite a while to
cache a page.
Did you close down EXCEL, or run the smfForceRecalculation macro, in
between the smfUpdateDownloadTable runs? If not, the add-in will just be
extracting the data from the same web page it had saved from the first time
you accessed that web page. I keep my EXCEL open for days at a time, so I
run the smfForceRecalculation macro every time I finish up with a given
task (and then EXCEL is just sitting there with an empty Sheet1). :)
On Tue, Nov 12, 2013 at 6:18 PM, <altaclip@gmail.com> wrote:
>
> The new Zacks element definitions seem to be working well but I wonder why
> the Zacks Rank is not updating in a timely manner.
>
> i.e. JAZZ was upgraded to ZR #1 on Nov 8. I've updated my
> smfupdatedownloadtable many times every day Nov 9-12 and it still shows #3
> for ZR.
>
> There are other examples.
> I am a Zacks premium subscriber.
> Anyone else notice certain Z elements not updating in a timely manenr?
>
Do you have your Internet Options set to always get new content? Maybe IE
is giving up cached web pages...although 4 days seems like quite a while to
cache a page.
Did you close down EXCEL, or run the smfForceRecalculati
between the smfUpdateDownloadTa
extracting the data from the same web page it had saved from the first time
you accessed that web page. I keep my EXCEL open for days at a time, so I
run the smfForceRecalculati
task (and then EXCEL is just sitting there with an empty Sheet1). :)
On Tue, Nov 12, 2013 at 6:18 PM, <altaclip@gmail.
>
> The new Zacks element definitions seem to be working well but I wonder why
> the Zacks Rank is not updating in a timely manner.
>
> i.e. JAZZ was upgraded to ZR #1 on Nov 8. I've updated my
> smfupdatedownloadta
> for ZR.
>
> There are other examples.
> I am a Zacks premium subscriber.
> Anyone else notice certain Z elements not updating in a timely manenr?
>
Tue Nov 12, 2013 6:02 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Since you use Zacks, can you try something for me?
Array-enter this over a 300-row by 3-column range:
=smfGetCSVFile("http://screener.zacks.com/export"&LEFT(RCHGetWebData("
http://screener.zacks.com/screens/1781741/run",1,1),0))
If it works properly, it should return a list of the Zacks #1 stocks.
The "http://screener.zacks.com/screens/1781741/run" runs a saved screen I
have and then the "http://screener.zacks.com/export" exports a CSV file
containing the results of that screen.
I know it works for my saved screens and predefined screens. I'm just
curious if the saved screens are unassociated with users when running them,
or if they are keyed to specific users and only they can run them.
This would be Zack's predefined screen for "Solid Growth and Low
Valuations":
=smfGetCSVFile("http://screener.zacks.com/export"&LEFT(RCHGetWebData("
http://screener.zacks.com/screens/16536/run",1,1),0))
On Tue, Nov 12, 2013 at 6:18 PM, <altaclip@gmail.com> wrote:
>
> The new Zacks element definitions seem to be working well but I wonder why
> the Zacks Rank is not updating in a timely manner.
>
> i.e. JAZZ was upgraded to ZR #1 on Nov 8. I've updated my
> smfupdatedownloadtable many times every day Nov 9-12 and it still shows #3
> for ZR.
>
> There are other examples.
> I am a Zacks premium subscriber.
> Anyone else notice certain Z elements not updating in a timely manenr?
>
Array-enter this over a 300-row by 3-column range:
=smfGetCSVFile(
http://screener.
If it works properly, it should return a list of the Zacks #1 stocks.
The "http://screener.
have and then the "http://screener.
containing the results of that screen.
I know it works for my saved screens and predefined screens. I'm just
curious if the saved screens are unassociated with users when running them,
or if they are keyed to specific users and only they can run them.
This would be Zack's predefined screen for "Solid Growth and Low
Valuations"
=smfGetCSVFile(
http://screener.
On Tue, Nov 12, 2013 at 6:18 PM, <altaclip@gmail.
>
> The new Zacks element definitions seem to be working well but I wonder why
> the Zacks Rank is not updating in a timely manner.
>
> i.e. JAZZ was upgraded to ZR #1 on Nov 8. I've updated my
> smfupdatedownloadta
> for ZR.
>
> There are other examples.
> I am a Zacks premium subscriber.
> Anyone else notice certain Z elements not updating in a timely manenr?
>
Tue Nov 12, 2013 6:21 pm (PST) . Posted by:
altaclip
Thanks Randy. the forcerecalc did the trick. I often keep multiple spreadsheets linked open for days. My first clue that it was using previously saved cache should have been how fast it updated. Working now - lesson learned.
thanks! Alta Clip
ps - I will try your request and report back...
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Since you use Zacks, can you try something for me?
Array-enter this over a 300-row by 3-column range:
=smfGetCSVFile("http://screener.zacks.com/export http://screener.zacks.com/export"&LEFT(RCHGetWebData("http://screener.zacks.com/screens/1781741/run http://screener.zacks.com/screens/1781741/run",1,1),0))
If it works properly, it should return a list of the Zacks #1 stocks.
The "http://screener.zacks.com/screens/1781741/run http://screener.zacks.com/screens/1781741/run" runs a saved screen I have and then the "http://screener.zacks.com/export http://screener.zacks.com/export" exports a CSV file containing the results of that screen.
I know it works for my saved screens and predefined screens. I'm just curious if the saved screens are unassociated with users when running them, or if they are keyed to specific users and only they can run them.
This would be Zack's predefined screen for "Solid Growth and Low Valuations":
=smfGetCSVFile("http://screener.zacks.com/export http://screener.zacks.com/export"&LEFT(RCHGetWebData("http://screener.zacks.com/screens/16536/run http://screener.zacks.com/screens/16536/run",1,1),0))
On Tue, Nov 12, 2013 at 6:18 PM, <altaclip@... mailto:altaclip@...> wrote:
The new Zacks element definitions seem to be working well but I wonder why the Zacks Rank is not updating in a timely manner.
i.e. JAZZ was upgraded to ZR #1 on Nov 8. I've updated my smfupdatedownloadtable many times every day Nov 9-12 and it still shows #3 for ZR.
There are other examples.
I am a Zacks premium subscriber.
Anyone else notice certain Z elements not updating in a timely manenr?
thanks! Alta Clip
ps - I will try your request and report back...
---In smf_addin@yahoogrou
Since you use Zacks, can you try something for me?
Array-enter this over a 300-row by 3-column range:
=smfGetCSVFile(
If it works properly, it should return a list of the Zacks #1 stocks.
The "http://screener.
I know it works for my saved screens and predefined screens. I'm just curious if the saved screens are unassociated with users when running them, or if they are keyed to specific users and only they can run them.
This would be Zack's predefined screen for "Solid Growth and Low Valuations"
=smfGetCSVFile(
On Tue, Nov 12, 2013 at 6:18 PM, <altaclip@
The new Zacks element definitions seem to be working well but I wonder why the Zacks Rank is not updating in a timely manner.
i.e. JAZZ was upgraded to ZR #1 on Nov 8. I've updated my smfupdatedownloadta
There are other examples.
I am a Zacks premium subscriber.
Anyone else notice certain Z elements not updating in a timely manenr?
Tue Nov 12, 2013 6:39 pm (PST) . Posted by:
altaclip
I worked and returned 126 rows (125 stocks) once I clicked on the web query import data and entered my zacks account info. Errors prior to logging in.
There currently are about 228 ZR #1's
"Solid Growth and Low Valuations" also worked for me and returned the following items (not sure how many columns)
ABG BGFV DAL HIG LAD LCC MTOR
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Since you use Zacks, can you try something for me?
Array-enter this over a 300-row by 3-column range:
=smfGetCSVFile("http://screener.zacks.com/export http://screener.zacks.com/export"&LEFT(RCHGetWebData("http://screener.zacks.com/screens/1781741/run http://screener.zacks.com/screens/1781741/run",1,1),0))
If it works properly, it should return a list of the Zacks #1 stocks.
The "http://screener.zacks.com/screens/1781741/run http://screener.zacks.com/screens/1781741/run" runs a saved screen I have and then the "http://screener.zacks.com/export http://screener.zacks.com/export" exports a CSV file containing the results of that screen.
I know it works for my saved screens and predefined screens. I'm just curious if the saved screens are unassociated with users when running them, or if they are keyed to specific users and only they can run them.
This would be Zack's predefined screen for "Solid Growth and Low Valuations":
=smfGetCSVFile("http://screener.zacks.com/export http://screener.zacks.com/export"&LEFT(RCHGetWebData("http://screener.zacks.com/screens/16536/run http://screener.zacks.com/screens/16536/run",1,1),0))
On Tue, Nov 12, 2013 at 6:18 PM, <altaclip@... mailto:altaclip@...> wrote:
The new Zacks element definitions seem to be working well but I wonder why the Zacks Rank is not updating in a timely manner.
i.e. JAZZ was upgraded to ZR #1 on Nov 8. I've updated my smfupdatedownloadtable many times every day Nov 9-12 and it still shows #3 for ZR.
There are other examples.
I am a Zacks premium subscriber.
Anyone else notice certain Z elements not updating in a timely manenr?
There currently are about 228 ZR #1's
"Solid Growth and Low Valuations" also worked for me and returned the following items (not sure how many columns)
ABG BGFV DAL HIG LAD LCC MTOR
---In smf_addin@yahoogrou
Since you use Zacks, can you try something for me?
Array-enter this over a 300-row by 3-column range:
=smfGetCSVFile(
If it works properly, it should return a list of the Zacks #1 stocks.
The "http://screener.
I know it works for my saved screens and predefined screens. I'm just curious if the saved screens are unassociated with users when running them, or if they are keyed to specific users and only they can run them.
This would be Zack's predefined screen for "Solid Growth and Low Valuations"
=smfGetCSVFile(
On Tue, Nov 12, 2013 at 6:18 PM, <altaclip@
The new Zacks element definitions seem to be working well but I wonder why the Zacks Rank is not updating in a timely manner.
i.e. JAZZ was upgraded to ZR #1 on Nov 8. I've updated my smfupdatedownloadta
There are other examples.
I am a Zacks premium subscriber.
Anyone else notice certain Z elements not updating in a timely manenr?
Tidak ada komentar:
Posting Komentar