4 New Messages
Digest #2656
2a
Re: Getting "Error" value and want to have it show as a zero value by "Kermit W. Prather" kermitpra
2b
Re: Getting "Error" value and want to have it show as a zero value by "Randy Harmelink" rharmelink
3
How Can I Include RCH Stock Market Functions in a Spreadsheet for Ea by "Ultimate Stock" ultimatestockfinder
Messages
Fri Jun 14, 2013 6:45 am (PDT) . Posted by:
"JCHyjun" JCHyjun
Hi Kermit,
Thank you for very useful file. Please note that dividata.com rounds dividends e.g. they report 0.13$ while company pays 12.5 cents.
Sincerely
J. Chang
--- In smf_addin@yahoogroups.com , smf_addin@yahoogroups.com wrote:
>
>
> 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/EX-Dividend-Dates-and-Payouts.xls
> Uploaded by : kermitpra <kermitp@...>
> Description : This spreadsheet retrieves the last 20 Ex-Dividates and payouts. It then calculates the number of dividend increases and decreases. The objective is to identify didvidend stocks that have a consistent payout over th last 20 payout periods. This is still a work in progress. It is being upload so Randy can assist with excel formulas. My skill are not even close to his.
>
> You can access this file at the URL:
> http://groups.yahoo.com/group/smf_addin/files/Uploads%20by%20forum%20members/EX-Dividend-Dates-and-Payouts.xls
>
> To learn more about file sharing for your group, please visit:
> http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
> Regards,
>
> kermitpra <kermitp@...>
>
Thank you for very useful file. Please note that dividata.com rounds dividends e.g. they report 0.13$ while company pays 12.5 cents.
Sincerely
J. Chang
--- In smf_addin@yahoogrou
>
>
> 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/EX-Dividend
> Uploaded by : kermitpra <kermitp@
> Description : This spreadsheet retrieves the last 20 Ex-Dividates and payouts. It then calculates the number of dividend increases and decreases. The objective is to identify didvidend stocks that have a consistent payout over th last 20 payout periods. This is still a work in progress. It is being upload so Randy can assist with excel formulas. My skill are not even close to his.
>
> You can access this file at the URL:
> http://groups.
>
> To learn more about file sharing for your group, please visit:
> http://help.
> Regards,
>
> kermitpra <kermitp@
>
Fri Jun 14, 2013 8:29 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Randy, I tried the table download spreadsheet this morning and it still would not work.
So I decided to reboot since it had been several days since my last reboot.
Well, guess what the table download worked like a champ. It is also much faster.
Any idea why it required a reboot? I know you keep retrieved data somewhere although it is a mystery to me.
I am now in the process of converting my version to use the table download.
Question: is there a way I can control how many rows get updated when I do the table update?
I may have 200 stocks in the list but only want the first 10 updated. Better yet would be if I could control the range of rows to update say row 15 – 26
If not it is not a big deal I'll just use a second worksheet to hold old updates. Which is what I had plan to do anyway.
Thanks, for your help as always it is quick and works.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Kermit W. Prather
Sent: Thursday, June 13, 2013 4:32 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Getting "Error" value and want to have it show as a zero value
I am using EXCEL 2007 the table download has worked previously.
I'll work with it and get back to you.
Thanks,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Thursday, June 13, 2013 4:27 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Getting "Error" value and want to have it show as a zero value
Hmmm. Works fine here:
Incr
Desc
Unch
Ticker
Div #1
Div #2
Div #3
Div #4
Div #5
Div #6
Div #7
Div #8
3
3
13
AGNC
$1.25
$1.25
$1.25
$1.25
$1.25
$1.40
$1.40
$1.40
3
2
14
AI
$0.88
$0.88
$0.88
$0.88
$0.88
$0.88
$0.88
$0.88
1
2
16
AINV
$0.20
$0.20
$0.20
$0.20
$0.20
$0.28
$0.28
$0.28
4
1
1
AMTG
$0.70
$1.05
$0.85
$0.75
$0.75
$0.30
--
--
3
2
14
ARCC
$0.38
$0.43
$0.43
$0.37
$0.37
$0.36
$0.35
$0.35
2
0
11
ARI
$0.40
$0.40
$0.40
$0.40
$0.40
$0.40
$0.40
$0.40
12
1
6
BBEP
$0.48
$0.47
$0.47
$0.46
$0.46
$0.45
$0.44
$0.42
1
2
16
BKCC
$0.26
$0.26
$0.26
$0.26
$0.26
$0.26
$0.26
$0.26
0
2
17
BOE
$0.31
$0.31
$0.31
$0.41
$0.41
$0.57
$0.57
$0.57
5
2
0
CHKR
$0.69
$0.67
$0.63
$0.61
$0.66
$0.73
$0.58
--
The code you highlighted never would be executed, since I'm not using element numbers.
Do you have an older version of EXCEL?
Hmmm. Close EXCEL and restart it, then open this workbook and run the macro. See if that works to purge everything retrieved in the past.
It should execute the following two statements for each cell above:
sFormula = Replace(sFormula, "~~~~~", sTicker)
.
.
.
[Ticker].Offset(iRow, iCol) = Evaluate(sFormula)
That first statement puts the ticker into the specified formula (e.g. what is in cell F2). That second statement should evaluate that resulting formula and place the value into the cell.
On Thu, Jun 13, 2013 at 1:14 PM, Kermit W. Prather <kermitp@tampabay.rr.com > wrote:
Randy, I did not get the expected results. In fact, all I got was – in every cell. Any suggestions?
So I decided to reboot since it had been several days since my last reboot.
Well, guess what the table download worked like a champ. It is also much faster.
Any idea why it required a reboot? I know you keep retrieved data somewhere although it is a mystery to me.
I am now in the process of converting my version to use the table download.
Question: is there a way I can control how many rows get updated when I do the table update?
I may have 200 stocks in the list but only want the first 10 updated. Better yet would be if I could control the range of rows to update say row 15 – 26
If not it is not a big deal I'll just use a second worksheet to hold old updates. Which is what I had plan to do anyway.
Thanks, for your help as always it is quick and works.
Kermit
From: smf_addin@yahoogrou
Sent: Thursday, June 13, 2013 4:32 PM
To: smf_addin@yahoogrou
Subject: RE: [smf_addin] Getting "Error" value and want to have it show as a zero value
I am using EXCEL 2007 the table download has worked previously.
I'll work with it and get back to you.
Thanks,
Kermit
From: smf_addin@yahoogrou
Sent: Thursday, June 13, 2013 4:27 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Getting "Error" value and want to have it show as a zero value
Hmmm. Works fine here:
Incr
Desc
Unch
Ticker
Div #1
Div #2
Div #3
Div #4
Div #5
Div #6
Div #7
Div #8
3
3
13
AGNC
$1.25
$1.25
$1.25
$1.25
$1.25
$1.40
$1.40
$1.40
3
2
14
AI
$0.88
$0.88
$0.88
$0.88
$0.88
$0.88
$0.88
$0.88
1
2
16
AINV
$0.20
$0.20
$0.20
$0.20
$0.20
$0.28
$0.28
$0.28
4
1
1
AMTG
$0.70
$1.05
$0.85
$0.75
$0.75
$0.30
--
--
3
2
14
ARCC
$0.38
$0.43
$0.43
$0.37
$0.37
$0.36
$0.35
$0.35
2
0
11
ARI
$0.40
$0.40
$0.40
$0.40
$0.40
$0.40
$0.40
$0.40
12
1
6
BBEP
$0.48
$0.47
$0.47
$0.46
$0.46
$0.45
$0.44
$0.42
1
2
16
BKCC
$0.26
$0.26
$0.26
$0.26
$0.26
$0.26
$0.26
$0.26
0
2
17
BOE
$0.31
$0.31
$0.31
$0.41
$0.41
$0.57
$0.57
$0.57
5
2
0
CHKR
$0.69
$0.67
$0.63
$0.61
$0.66
$0.73
$0.58
--
The code you highlighted never would be executed, since I'm not using element numbers.
Do you have an older version of EXCEL?
Hmmm. Close EXCEL and restart it, then open this workbook and run the macro. See if that works to purge everything retrieved in the past.
It should execute the following two statements for each cell above:
sFormula = Replace(sFormula, "~~~~~"
.
.
.
[Ticker].Offset(
That first statement puts the ticker into the specified formula (e.g. what is in cell F2). That second statement should evaluate that resulting formula and place the value into the cell.
On Thu, Jun 13, 2013 at 1:14 PM, Kermit W. Prather <kermitp@tampabay.
Randy, I did not get the expected results. In fact, all I got was – in every cell. Any suggestions?
Fri Jun 14, 2013 1:48 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
No idea why a reboot would fix anything.
The process runs until it finds an empty ticker cell. So put the rows you
want to update at the top, followed by an empty row.
It shouldn't really update faster. It may seem that way because you can see
it updating.
On Fri, Jun 14, 2013 at 8:29 AM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
>
> Randy, I tried the table download spreadsheet this morning and it still
> would not work.****
>
> ** **
>
> So I decided to reboot since it had been several days since my last reboot.
> ****
>
> ** **
>
> Well, guess what the table download worked like a champ. It is also much
> faster.****
>
> ** **
>
> Any idea why it required a reboot? I know you keep retrieved data
> somewhere although it is a mystery to me. ****
>
> ** **
>
> I am now in the process of converting my version to use the table
> download. ****
>
> ** **
>
> Question: is there a way I can control how many rows get updated when I do
> the table update? ****
>
> I may have 200 stocks in the list but only want the first 10 updated.
> Better yet would be if I could control the range of rows to update say row
> 15 – 26****
>
> ** **
>
> If not it is not a big deal I'll just use a second worksheet to hold old
> updates. Which is what I had plan to do anyway. ****
>
> ** **
>
> Thanks, for your help as always it is quick and works. ****
>
>
>
The process runs until it finds an empty ticker cell. So put the rows you
want to update at the top, followed by an empty row.
It shouldn'
it updating.
On Fri, Jun 14, 2013 at 8:29 AM, Kermit W. Prather
<kermitp@tampabay.
>
>
> Randy, I tried the table download spreadsheet this morning and it still
> would not work.****
>
> ** **
>
> So I decided to reboot since it had been several days since my last reboot.
> ****
>
> ** **
>
> Well, guess what the table download worked like a champ. It is also much
> faster.****
>
> ** **
>
> Any idea why it required a reboot? I know you keep retrieved data
> somewhere although it is a mystery to me. ****
>
> ** **
>
> I am now in the process of converting my version to use the table
> download. ****
>
> ** **
>
> Question: is there a way I can control how many rows get updated when I do
> the table update? ****
>
> I may have 200 stocks in the list but only want the first 10 updated.
> Better yet would be if I could control the range of rows to update say row
> 15 – 26****
>
> ** **
>
> If not it is not a big deal I'll just use a second worksheet to hold old
> updates. Which is what I had plan to do anyway. ****
>
> ** **
>
> Thanks, for your help as always it is quick and works. ****
>
>
>
Fri Jun 14, 2013 3:57 pm (PDT) . Posted by:
"Ultimate Stock" ultimatestockfinder
Randy,
I have a free website http://www.ultimatestockfinder.com/ for individual investors that contains Excel spreadsheets that help my users find good stocks (StockEvaluator) and mutual funds (MutualFundEvaluator). These spreadsheets take 17 different company financial and stock price data values from the web and allow the user to set customized target limits for each data value. Each company cell that does not meet these custom limits is turned red with a conditional format command. Macro sorting commands allow the user to sort the companies with the least red cells to the top. The spreadsheet also contains Macro sorts on: % above 52 week low; Dividend Yield; Daily Stock Price Volatility; and P/E Ratio.
The "Training"; page has other articles and spreadsheet tools to help individual investors manage their investments. One of these spreadsheets is "Investment Tracker" (see attached) which will hold a complete list of the users investments by stock symbol, number of shares, buy price, current price, total current value and institution holding the investment. I had been updating the current price manually for years, but my friend, Nathan Welborne, showed me how to use the RCH Stock Market Functions last month and I am now using your functions on my personal version of the Investment Tracker spreadsheet to get current stock prices.
I would like to provide this automatic look up function as a downloadable file to all my web site users, and need to confirm with you if I can add the RCH Stock Market Functions to my website as a download my web visitors would do along with downloading the InvestmentTracker.xls file.
Also, is there any way that these RCH Stock Market Functions could be included as a worksheet in an InvestmentTracker.xls workbook so that my users would not have to download them separately, but the one download of InvestmentTracker.xls (workbook) would be ready to do the automatic stock price look ups automatically.
Thank you,
John DeCamp
www.UltimateStockFinder.com
I have a free website http://www.ultimate
The "Training"
I would like to provide this automatic look up function as a downloadable file to all my web site users, and need to confirm with you if I can add the RCH Stock Market Functions to my website as a download my web visitors would do along with downloading the InvestmentTracker.
Also, is there any way that these RCH Stock Market Functions could be included as a worksheet in an InvestmentTracker.
Thank you,
John DeCamp
www.UltimateStockFi
Attachments with this message:
1 of 1 File(s)
Tidak ada komentar:
Posting Komentar