5 New Messages
Digest #2657
3a
Re: How Can I Include RCH Stock Market Functions in a Spreadsheet fo by "Randy Harmelink" rharmelink
Messages
Sat Jun 15, 2013 3:00 am (PDT) . Posted by:
"nuagesolutions" nuagesolutions
Hi,
I saw this post and I would be interested by the .net accessibility for this add-in.
I am using vb.net and it would be great to use this add-in functions through vb.net.
Can somebody help ?
Thanks.
--- In smf_addin@yahoogroups.com , "jackoblacko1" <jackoblacko1@...> wrote:
>
> Hi, I'm thinking about porting your code to VB.NET and post it on CodeGallery. I will give you all the credit for it and point people to this group.
>
> I assume that's ok with you. Let me know if it's not.
>
> .luca
>
I saw this post and I would be interested by the .net accessibility for this add-in.
I am using vb.net and it would be great to use this add-in functions through vb.net.
Can somebody help ?
Thanks.
--- In smf_addin@yahoogrou
>
> Hi, I'm thinking about porting your code to VB.NET and post it on CodeGallery. I will give you all the credit for it and point people to this group.
>
> I assume that's ok with you. Let me know if it's not.
>
> .luca
>
Sat Jun 15, 2013 4:31 am (PDT) . Posted by:
"JCHyjun" JCHyjun
It seems that marketocracy.com has more precise dividend history than dividata.com - just compare
http://www.marketocracy.com/cgi-bin/WebObjects/Portfolio.woa/ps/StockActionsPage?symbol=ggp&submit=quote
with
www.dividata.com/stock/GGP/dividend
It would be very useful to create similar table for marketocracy.com
--- In smf_addin@yahoogroups.com , "JCHyjun" <jchyjun@...> wrote:
>
> 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@>
> >
>
http://www.marketoc
with
www.dividata.
It would be very useful to create similar table for marketocracy.
--- In smf_addin@yahoogrou
>
> 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@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@
> >
>
Sat Jun 15, 2013 5:34 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Thanks, I'll definitely check it out.
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of JCHyjun
Sent: Saturday, June 15, 2013 7:31 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: New file uploaded to smf_addin
It seems that marketocracy.com has more precise dividend history than
dividata.com - just compare
http://www.marketocracy.com/cgi-bin/WebObjects/Portfolio.woa/ps/StockActions
Page?symbol=ggp&submit=quote
with
www.dividata.com/stock/GGP/dividend
It would be very useful to create similar table for marketocracy.com
--- In smf_addin@yahoogroups.com , "JCHyjun" <jchyjun@...> wrote:
>
> 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%2
> > 0members/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.h
> > tml
> > Regards,
> >
> > kermitpra <kermitp@>
> >
>
------------------------------------
Yahoo! Groups Links
-----Original Message-----
From: smf_addin@yahoogrou
Of JCHyjun
Sent: Saturday, June 15, 2013 7:31 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: New file uploaded to smf_addin
It seems that marketocracy.
dividata.com - just compare
http://www.marketoc
Page?symbol=
with
www.dividata.
It would be very useful to create similar table for marketocracy.
--- In smf_addin@yahoogrou
>
> 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@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.
> > 0members/EX-
> >
> > To learn more about file sharing for your group, please visit:
> > http://help.
> > tml
> > Regards,
> >
> > kermitpra <kermitp@
> >
>
------------
Yahoo! Groups Links
Sat Jun 15, 2013 7:58 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
JC, I looked at several stocks on the webpage you supplied. I think I'll
leave it to you or other to create a spreadsheet from that site. It is 31
tables before you get to the data I would be interested in, not that make it
any more difficult.
With Randy's assistance I have almost got my spreadsheet where I want it.
At this time, I just can't see starting over and putting in several days to
create what I have now.
If you decide to take it on, please keep us inform on your progress.
Kermit
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of JCHyjun
Sent: Saturday, June 15, 2013 7:31 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: New file uploaded to smf_addin
It seems that marketocracy.com has more precise dividend history than
dividata.com - just compare
http://www.marketocracy.com/cgi-bin/WebObjects/Portfolio.woa/ps/StockActions
Page?symbol=ggp&submit=quote
with
www.dividata.com/stock/GGP/dividend
It would be very useful to create similar table for marketocracy.com
--- In smf_addin@yahoogroups.com , "JCHyjun" <jchyjun@...> wrote:
>
> 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%2
> > 0members/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.h
> > tml
> > Regards,
> >
> > kermitpra <kermitp@>
> >
>
------------------------------------
Yahoo! Groups Links
leave it to you or other to create a spreadsheet from that site. It is 31
tables before you get to the data I would be interested in, not that make it
any more difficult.
With Randy's assistance I have almost got my spreadsheet where I want it.
At this time, I just can't see starting over and putting in several days to
create what I have now.
If you decide to take it on, please keep us inform on your progress.
Kermit
-----Original Message-----
From: smf_addin@yahoogrou
Of JCHyjun
Sent: Saturday, June 15, 2013 7:31 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: New file uploaded to smf_addin
It seems that marketocracy.
dividata.com - just compare
http://www.marketoc
Page?symbol=
with
www.dividata.
It would be very useful to create similar table for marketocracy.
--- In smf_addin@yahoogrou
>
> 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@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.
> > 0members/EX-
> >
> > To learn more about file sharing for your group, please visit:
> > http://help.
> > tml
> > Regards,
> >
> > kermitpra <kermitp@
> >
>
------------
Yahoo! Groups Links
Sat Jun 15, 2013 6:39 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
To make the workbooks portable, you would need to copy the applicable
modules to the workbook. There are several examples in the group, in the
FILES area:
Files > Templates and Examples > SMFLite
I think the RCHGetElementNumber() function is the only one that doesn't
work well for this, because the element definitions are in external files.
The disadvantage of doing this is that if I make updates to the add-in, the
updates would need to be manually done to each of the stand-alone workbooks.
On Fri, Jun 14, 2013 at 3:45 PM, Ultimate Stock <
ultimatestockfinder@yahoo.com > wrote:
>
> 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
>
modules to the workbook. There are several examples in the group, in the
FILES area:
Files > Templates and Examples > SMFLite
I think the RCHGetElementNumber
work well for this, because the element definitions are in external files.
The disadvantage of doing this is that if I make updates to the add-in, the
updates would need to be manually done to each of the stand-alone workbooks.
On Fri, Jun 14, 2013 at 3:45 PM, Ultimate Stock <
ultimatestockfinder
>
> Randy,
> I have a free website http://www.ultimate
> investors that contains Excel spreadsheets that help my users find good
> stocks (StockEvaluator) and mutual funds (MutualFundEvaluato
> 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"
> 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.
>
> Also, is there any way that these RCH Stock Market Functions could be
> included as a worksheet in an InvestmentTracker.
> users would not have to download them separately, but the one download of
> InvestmentTracker.
> price look ups automatically.
>
> Thank you,
> John DeCamp
> www.UltimateStockFi
>
Tidak ada komentar:
Posting Komentar