16 New Messages
Digest #2914
4b
Re: RCHGetElementNumber: How can access Morn* Corporate Credit Ratin by "Randy Harmelink" rharmelink
4d
Re: RCHGetElementNumber: How can access Morn* Corporate Credit Ratin by "Randy Harmelink" rharmelink
Messages
Fri Jan 3, 2014 1:40 am (PST) . Posted by:
"Ton Sieverding" amsiev
Thanks Randy. In fact the question should have been, where can I download the latest version of SMF ? I do not remember how I have downloaded my actual version ...
Regards, Ton.
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogroups.com
Sent: Friday, January 03, 2014 12:17 AM
Subject: Re: [smf_addin] Element number defs
The most recent uploaded one is in the "Works in Progress" folder...
On Thu, Jan 2, 2014 at 1:33 PM, <ton.sieverding@scarlet.be> wrote:
Where can I download the latest version of :
RCHGetElementNumber-Element-Definitions.xls
Regards, Ton.
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogrou
Sent: Friday, January 03, 2014 12:17 AM
Subject: Re: [smf_addin] Element number defs
The most recent uploaded one is in the "Works in Progress" folder...
On Thu, Jan 2, 2014 at 1:33 PM, <ton.sieverding@
Where can I download the latest version of :
RCHGetElementNumber
Fri Jan 3, 2014 1:57 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Same answer. All changes since the last official release are in the "Works
in Progress" folder.
On Fri, Jan 3, 2014 at 2:10 AM, Ton Sieverding <ton.sieverding@scarlet.be>wrote:
>
> Thanks Randy. In fact the question should have been, where can I
> download the latest version of SMF ? I do not remember how I have
> downloaded my actual version ...
>
>
in Progress" folder.
On Fri, Jan 3, 2014 at 2:10 AM, Ton Sieverding <ton.sieverding@
>
> Thanks Randy. In fact the question should have been, where can I
> download the latest version of SMF ? I do not remember how I have
> downloaded my actual version ...
>
>
Fri Jan 3, 2014 7:04 am (PST) . Posted by:
"Ton Sieverding" amsiev
Thanks and no thanks Randy. Let's say I'm a firsttime SMF user and want to start using SMF. Therefore I must download the SMF environment. Where can I find this software ?
Should be a simple URL ...
Regards, Ton.
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogroups.com
Sent: Friday, January 03, 2014 10:57 AM
Subject: Re: [smf_addin] Element number defs
Same answer. All changes since the last official release are in the "Works in Progress" folder.
On Fri, Jan 3, 2014 at 2:10 AM, Ton Sieverding <ton.sieverding@scarlet.be> wrote:
Thanks Randy. In fact the question should have been, where can I download the latest version of SMF ? I do not remember how I have downloaded my actual version ...
Should be a simple URL ...
Regards, Ton.
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogrou
Sent: Friday, January 03, 2014 10:57 AM
Subject: Re: [smf_addin] Element number defs
Same answer. All changes since the last official release are in the "Works in Progress" folder.
On Fri, Jan 3, 2014 at 2:10 AM, Ton Sieverding <ton.sieverding@
Thanks Randy. In fact the question should have been, where can I download the latest version of SMF ? I do not remember how I have downloaded my actual version ...
Fri Jan 3, 2014 7:11 am (PST) . Posted by:
"Randy Harmelink" rharmelink
If someone can't navigate the FILES area of the group, they aren't going to
be able to use the add-in...
There are too many things in the FILES and LINKS area of the group that
SHOULD BE referred to.
On Fri, Jan 3, 2014 at 3:54 AM, Ton Sieverding <ton.sieverding@scarlet.be>wrote:
>
> Thanks and no thanks Randy. Let's say I'm a firsttime SMF user and want to
> start using SMF. Therefore I must download the SMF environment. Where can I
> find this software ?
> Should be a simple URL ...
>
>
be able to use the add-in...
There are too many things in the FILES and LINKS area of the group that
SHOULD BE referred to.
On Fri, Jan 3, 2014 at 3:54 AM, Ton Sieverding <ton.sieverding@
>
> Thanks and no thanks Randy. Let's say I'm a firsttime SMF user and want to
> start using SMF. Therefore I must download the SMF environment. Where can I
> find this software ?
> Should be a simple URL ...
>
>
Fri Jan 3, 2014 9:05 am (PST) . Posted by:
"Ton Sieverding" amsiev
New year problems Randy ? You really think this is a normal answer ? I know how to navigate the files area of a group but I suppose that an informatician like you should have put a central help file for the SMF environment. From there I can manage the problem. In stead of having to look everywhere in order to find what I need. Anyway I will have to go back to my cURL world where this exists ... Frankly I just don't understand this answer and would never have expected this from you.
Regards, Ton.
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogroups.com
Sent: Friday, January 03, 2014 4:11 PM
Subject: Re: [smf_addin] Element number defs
If someone can't navigate the FILES area of the group, they aren't going to be able to use the add-in...
There are too many things in the FILES and LINKS area of the group that SHOULD BE referred to.
On Fri, Jan 3, 2014 at 3:54 AM, Ton Sieverding <ton.sieverding@scarlet.be> wrote:
Thanks and no thanks Randy. Let's say I'm a firsttime SMF user and want to start using SMF. Therefore I must download the SMF environment. Where can I find this software ?
Should be a simple URL ...
Regards, Ton.
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogrou
Sent: Friday, January 03, 2014 4:11 PM
Subject: Re: [smf_addin] Element number defs
If someone can't navigate the FILES area of the group, they aren't going to be able to use the add-in...
There are too many things in the FILES and LINKS area of the group that SHOULD BE referred to.
On Fri, Jan 3, 2014 at 3:54 AM, Ton Sieverding <ton.sieverding@
Thanks and no thanks Randy. Let's say I'm a firsttime SMF user and want to start using SMF. Therefore I must download the SMF environment. Where can I find this software ?
Should be a simple URL ...
Fri Jan 3, 2014 7:04 am (PST) . Posted by:
infinityholdings@ymail.com
Ok tried reinstalling the add-in from scratch so here is what I am getting now
1.
Error
2.
Stock Market Functions add-in, Version 2.1.2013.10.17 (C:\Program Files\Excel Add-in; ; 1)
3. Earnings;Quarterly Earnings -- Calendar Date -- 1;http://fulldisclosure.com/company.asp?client=cb&ticker=~~~~~;7;>EARNINGS RELEASES;<TABLE;>; ;2;SPACER.GIF;0;0
4.
1/30/2014
5.
{ "Date" : "1/30/2014", "Period Ending" : "12/2013", "Estimate"; : "$1.61", "Reported"; : "--", "Surprise"; : "--", "Time" : "--" } , { "Date" : "10/24/2013", "Period Ending" : "9/2013", "Estimate"; : "$1.76", "Reported"; : "$1.78", "Surprise"; : "<div class=\"right pos positive pos_icon showinline up\">0.02 (1.14%)</div>", "Time" : "Before Open" } , { "Date" : "7/25/2013", "Period Ending" : "6/2013", "Estimate"; : "$1.70", "Reported"; : "$1.71", "Surprise"; : "<div class=\"right pos positive pos_icon showinline up\">0.01 (0.59%)</div>", "Time" : "Before Open" } , { "Date" : "4/25/2013", "Period Ending" : "3/2013", "Estimate"; : "$1.65", "Reported"; : "$1.61", "Surprise"; : "<div class=\"right neg negative neg_icon showinline down\">-0.04 (2.42%)</div>", "Time" : "Before Open" } , { "Date" : "1/24/2013", "Period Ending" : "12/2012", "Estimate"; : "$1.41", "Reported"; : "$1.41", "Surprise"; : "<div class=\"right pos_na showinline\">0.00 (0.00%)</div>", "Time" : "Before Open" } , { "Date" : "10/23/2012", "Period Ending" : "9/2012", "Estimate"; : "$1.66", "Reported"; : "$1.65", "Surprise"; : "<div class=\"right neg negative neg_icon showinline down\">-0.01 (0.60%)</div>", "Time" : "Before Open" } , { "Date" : "7/26/2012", "Period Ending" : "6/2012", "Estimate"; : "$1.65", "Reported"; : "$1.66", "Surprise"; : "<div class=\"right pos positive pos_icon showinline up\">0.01 (0.61%)</div>", "Time" : "Before Open" } , { "Date" : "4/24/2012", "Period Ending" : "3/2012", "Estimate"; : "$1.48", "Reported"; : "$1.59", "Surprise"; : "<div class=\"right pos positive pos_icon showinline up\">0.11 (7.43%)</div>", "Time" : "Before Open" } , { "Date" : "1/26/2012", "Period Ending" : "12/2011", "Estimate"; : "$1.31", "Reported"; : "$1.35", "Surprise"; : "<div class=\"right pos positive pos_icon showinline up\">0.04 (3.05%)</div>", "Time" : "Before Open" } , { "Date" : "10/25/2011", "Period Ending" : "9/2011", "Estimate"; : "$1.61", "Reported"; : "$1.52", "Surprise"; : "<div class=\"right neg negative neg_icon showinline down\">-0.09 (5.59%)</div>", "Time" : "Before Open" } , { "Date" : "7/26/2011", "Period Ending" : "6/2011", "Estimate"; : "$1.60", "Reported"; : "$1.60", "Surprise"; : "<div class=\"right pos_na showinline\">0.00 (0.00%)</div>", "Time" : "Before Open" } , { "Date" : "4/26/2011", "Period Ending" : "3/2011", "Estimate"; : "$1.43", "Reported"; : "$1.49", "Surprise"; : "<div class=\"right pos positive pos_icon showinline up\">0.06 (4.20%)</div>", "Time" : "Before Open" } , { "Date" : "1/25/2011", "Period Ending" : "12/2010", "Estimate"; : "$1.27", "Reported"; : "$1.27", "Surprise"; : "<div class=\"right pos_na showinline\">0.00 (0.00%)</div>", "Time" : "Before Open" } , { "Date" : "10/28/2010", "Period Ending" : "9/2010", "Estimate"; : "$1.51", "Reported"; : "--", "Surprise"; : "--", "Time" : "Before Open" } , { "Date" : "7/22/2010", "Period Ending" : "6/2010", "Estimate"; : "$1.48", "Reported"; : "--", "Surprise"; : "--", "Time" : "--" } , { "Date" : "4/27/2010", "Period Ending" : "3/2010", "Estimate"; : "$1.21", "Reported"; : "--", "Surprise"; : "--", "Time" : "Before Open" } , { "Date" : "1/28/2010", "Period Ending" : "12/2009", "Estimate"; : "$1.21", "Reported"; : "--", "Surprise"; : "--", "Time" : "Before Open" } , { "Date" : "10/22/2009", "Period Ending" : "9/2009", "Estimate"; : "$1.17", "Reported"; : "--", "Surprise"; : "--", "Time" : "Before Open" } , { "Date" : "7/23/2009", "Period Ending" : "6/2009", "Estimate"; : "$0.94", "Reported"; : "--", "Surprise"; : "--", "Time" : "Before Open" }
1.
Error
2.
Stock Market Functions add-in, Version 2.1.2013.10.
3. Earnings;Quarterly Earnings -- Calendar Date -- 1;http://fulldisclosu
4.
1/30/2014
5.
{ "Date" : "1/30/2014&quo
Fri Jan 3, 2014 7:09 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Item #3 shows the old element definition...
Several element definition files were changed after the 2013.10.17 add-in
release.
On Fri, Jan 3, 2014 at 8:04 AM, <coons_adam@yahoo.com> wrote:
> Ok tried reinstalling the add-in from scratch so here is what I am
> getting now
>
> 1.
>
> Error
>
> 2.
>
> Stock Market Functions add-in, Version 2.1.2013.10.17 (C:\Program
> Files\Excel Add-in; ; 1)
>
> 3. Earnings;Quarterly Earnings -- Calendar Date -- 1;
> http://fulldisclosure.com/company.asp?client=cb&ticker=~~~~~;7;>EARNINGS
> RELEASES;<TABLE;>; ;2;SPACER.GIF;0;0
>
Several element definition files were changed after the 2013.10.17 add-in
release.
On Fri, Jan 3, 2014 at 8:04 AM, <coons_adam@yahoo.
> Ok tried reinstalling the add-in from scratch so here is what I am
> getting now
>
> 1.
>
> Error
>
> 2.
>
> Stock Market Functions add-in, Version 2.1.2013.10.
> Files\Excel Add-in; ; 1)
>
> 3. Earnings;Quarterly Earnings -- Calendar Date -- 1;
> http://fulldisclosu
> RELEASES;<
>
Fri Jan 3, 2014 8:02 am (PST) . Posted by:
infinityholdings@ymail.com
Sorry to continue to use up your time but not sure what I am doing wrong. Do I need to replace the txt files as well as the excel files when updating?
Fri Jan 3, 2014 9:05 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Yes. Some of the smf-elements-*.txt files have been updated since the
add-in was last updated. The upload dates on the files should tell you
which ones.
On Fri, Jan 3, 2014 at 9:02 AM, <coons_adam@yahoo.com> wrote:
> Sorry to continue to use up your time but not sure what I am doing
> wrong. Do I need to replace the txt files as well as the excel files when
> updating?
>
add-in was last updated. The upload dates on the files should tell you
which ones.
On Fri, Jan 3, 2014 at 9:02 AM, <coons_adam@yahoo.
> Sorry to continue to use up your time but not sure what I am doing
> wrong. Do I need to replace the txt files as well as the excel files when
> updating?
>
Fri Jan 3, 2014 9:05 am (PST) . Posted by:
liucyndy
Randy,
Could you let me know the formula for getting historical volume data for a stock?
Could you let me know the formula for getting historical volume data for a stock?
Fri Jan 3, 2014 9:08 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Use the RCHGetYahooHistory() function...
On Fri, Jan 3, 2014 at 10:05 AM, <jgr1230@gmail.com> wrote:
>
> Could you let me know the formula for getting historical volume data for a
> stock?
>
>
On Fri, Jan 3, 2014 at 10:05 AM, <jgr1230@gmail.
>
> Could you let me know the formula for getting historical volume data for a
> stock?
>
>
Fri Jan 3, 2014 9:06 am (PST) . Posted by:
"devropr" devropr
Randy, how can I use RCHGetElementNumber to pull in Morn* Corporate Credit Ratings. Or should I use one of the other tools? Phil
Fri Jan 3, 2014 9:24 am (PST) . Posted by:
"Randy Harmelink" rharmelink
There's no element definition for that item. If I understand what you're
after, I think this will do the trick:
=RCHGetTableCell(smfstrExtr(smfGetTagContent("
http://quicktake.morningstar.com/stocknet/bonds.aspx?symbol=MMM","td",-1,"iframe"),"src=""",""""),1,"Credit
Rating","<tr")
On Fri, Jan 3, 2014 at 10:06 AM, devropr <devropr@cox.net> wrote:
> Randy, how can I use RCHGetElementNumber to pull in Morn* Corporate Credit
> Ratings. Or should I use one of the other tools? Phil
>
after, I think this will do the trick:
=RCHGetTableCell(
http://quicktake.
Rating"
On Fri, Jan 3, 2014 at 10:06 AM, devropr <devropr@cox.
> Randy, how can I use RCHGetElementNumber to pull in Morn* Corporate Credit
> Ratings. Or should I use one of the other tools? Phil
>
Fri Jan 3, 2014 11:35 am (PST) . Posted by:
"devropr" devropr
Randy - That gives the results I'm looking for. How do I replace the stock ticker MMM with ticker in reference cell. I tried replacing MMM with cell A5, but received error.
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> There's no element definition for that item. If I understand what you're
> after, I think this will do the trick:
>
> =RCHGetTableCell(smfstrExtr(smfGetTagContent("
> http://quicktake.morningstar.com/stocknet/bonds.aspx?symbol=MMM","td",-1,"iframe"),"src=""",""""),1,"Credit
> Rating","<tr")
>
>
> On Fri, Jan 3, 2014 at 10:06 AM, devropr <devropr@...> wrote:
>
> > Randy, how can I use RCHGetElementNumber to pull in Morn* Corporate Credit
> > Ratings. Or should I use one of the other tools? Phil
> >
>
--- In smf_addin@yahoogrou
>
> There's no element definition for that item. If I understand what you're
> after, I think this will do the trick:
>
> =RCHGetTableCell(
> http://quicktake.
> Rating"
>
>
> On Fri, Jan 3, 2014 at 10:06 AM, devropr <devropr@
>
> > Randy, how can I use RCHGetElementNumber to pull in Morn* Corporate Credit
> > Ratings. Or should I use one of the other tools? Phil
> >
>
Fri Jan 3, 2014 1:10 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Just use normal EXCEL concatenation:
"http://quicktake.morningstar.com/stocknet/bonds.aspx?symbol=" & A5
On Fri, Jan 3, 2014 at 12:35 PM, devropr <devropr@cox.net> wrote:
> Randy - That gives the results I'm looking for. How do I replace the
> stock ticker MMM with ticker in reference cell. I tried replacing MMM with
> cell A5, but received error.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > There's no element definition for that item. If I understand what you're
> > after, I think this will do the trick:
> >
> > =RCHGetTableCell(smfstrExtr(smfGetTagContent("
> > http://quicktake.morningstar.com/stocknet/bonds.aspx?symbol=MMM
> ","td",-1,"iframe"),"src=""",""""),1,"Credit
> > Rating","<tr")
> >
> >
> > On Fri, Jan 3, 2014 at 10:06 AM, devropr <devropr@...> wrote:
> >
> > > Randy, how can I use RCHGetElementNumber to pull in Morn* Corporate
> Credit
> > > Ratings. Or should I use one of the other tools? Phil
>
"http://quicktake.
On Fri, Jan 3, 2014 at 12:35 PM, devropr <devropr@cox.
> Randy - That gives the results I'm looking for. How do I replace the
> stock ticker MMM with ticker in reference cell. I tried replacing MMM with
> cell A5, but received error.
>
> --- In smf_addin@yahoogrou
> >
> > There's no element definition for that item. If I understand what you're
> > after, I think this will do the trick:
> >
> > =RCHGetTableCell(
> > http://quicktake.
> ","
> > Rating"
> >
> >
> > On Fri, Jan 3, 2014 at 10:06 AM, devropr <devropr@
> >
> > > Randy, how can I use RCHGetElementNumber to pull in Morn* Corporate
> Credit
> > > Ratings. Or should I use one of the other tools? Phil
>
Fri Jan 3, 2014 9:09 am (PST) . Posted by:
liucyndy
Randy,
Again, thank you so much for your contribution to this group. Can you kindly let me know the formula to get historical volume data for a stock? Thanks a lot!
Cindy
Again, thank you so much for your contribution to this group. Can you kindly let me know the formula to get historical volume data for a stock? Thanks a lot!
Cindy
Tidak ada komentar:
Posting Komentar