12 New Messages
Digest #2915
1b
Re: RCHGetElementNumber: How can access Morn* Corporate Credit Ratin by "Randy Harmelink" rharmelink
Messages
Fri Jan 3, 2014 1:24 pm (PST) . Posted by:
"devropr" devropr
Randy, I entered =RCHGetTableCell(smfStrExtr(smfGetTagContent("http://quicktake.morningstar.com/stocknet/bonds.aspx?symbol=" & A6,"td",-1,"iframe"),"src=""",""""),1,"Credit Rating","<tr") but returned error.
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> 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
> >
>
--- In smf_addin@yahoogrou
>
> Just use normal EXCEL concatenation:
>
> "http://quicktake.
>
> On Fri, Jan 3, 2014 at 12:35 PM, 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@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:29 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
That works for me. I put ticker symbol MMM in cell A6, then changed it to
IBM. Got "AA" and then "AA-".
On Fri, Jan 3, 2014 at 2:24 PM, devropr <devropr@cox.net> wrote:
> Randy, I entered =RCHGetTableCell(smfStrExtr(smfGetTagContent("
> http://quicktake.morningstar.com/stocknet/bonds.aspx?symbol=" &
> A6,"td",-1,"iframe"),"src=""",""""),1,"Credit Rating","<tr") but returned
> error.
>
IBM. Got "AA" and then "AA-"
On Fri, Jan 3, 2014 at 2:24 PM, devropr <devropr@cox.
> Randy, I entered =RCHGetTableCell(
> http://quicktake.
> A6,"td"
> error.
>
Fri Jan 3, 2014 1:39 pm (PST) . Posted by:
"devropr" devropr
Randy, thank you. I must be having a problem on my end.
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That works for me. I put ticker symbol MMM in cell A6, then changed it to
> IBM. Got "AA" and then "AA-".
>
> On Fri, Jan 3, 2014 at 2:24 PM, devropr <devropr@...> wrote:
>
> > Randy, I entered =RCHGetTableCell(smfStrExtr(smfGetTagContent("
> > http://quicktake.morningstar.com/stocknet/bonds.aspx?symbol=" &
> > A6,"td",-1,"iframe"),"src=""",""""),1,"Credit Rating","<tr") but returned
> > error.
> >
>
--- In smf_addin@yahoogrou
>
> That works for me. I put ticker symbol MMM in cell A6, then changed it to
> IBM. Got "AA" and then "AA-"
>
> On Fri, Jan 3, 2014 at 2:24 PM, devropr <devropr@
>
> > Randy, I entered =RCHGetTableCell(
> > http://quicktake.
> > A6,"td"
> > error.
> >
>
Fri Jan 3, 2014 1:48 pm (PST) . Posted by:
"devropr" devropr
Randy - working fine now. Thanks again. You really are the best!
--- In smf_addin@yahoogroups.com, "devropr" <devropr@...> wrote:
>
> Randy, thank you. I must be having a problem on my end.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > That works for me. I put ticker symbol MMM in cell A6, then changed it to
> > IBM. Got "AA" and then "AA-".
> >
> > On Fri, Jan 3, 2014 at 2:24 PM, devropr <devropr@> wrote:
> >
> > > Randy, I entered =RCHGetTableCell(smfStrExtr(smfGetTagContent("
> > > http://quicktake.morningstar.com/stocknet/bonds.aspx?symbol=" &
> > > A6,"td",-1,"iframe"),"src=""",""""),1,"Credit Rating","<tr") but returned
> > > error.
> > >
> >
>
--- In smf_addin@yahoogrou
>
> Randy, thank you. I must be having a problem on my end.
>
> --- In smf_addin@yahoogrou
> >
> > That works for me. I put ticker symbol MMM in cell A6, then changed it to
> > IBM. Got "AA" and then "AA-"
> >
> > On Fri, Jan 3, 2014 at 2:24 PM, devropr <devropr@
> >
> > > Randy, I entered =RCHGetTableCell(
> > > http://quicktake.
> > > A6,"td"
> > > error.
> > >
> >
>
Fri Jan 3, 2014 2:10 pm (PST) . Posted by:
y072055
Are you a COMPLETE fucking idiot?
Randy develops the add-in, makes it freely available and offers constant support. Never asks for a thing from anyone and you just show up with an attitude.
Why don't you piss off and never have anything to do with this group or Randy's add-in? That'll teach him.
asshole
Randy develops the add-in, makes it freely available and offers constant support. Never asks for a thing from anyone and you just show up with an attitude.
Why don't you piss off and never have anything to do with this group or Randy's add-in? That'll teach him.
asshole
Fri Jan 3, 2014 2:24 pm (PST) . Posted by:
"PC_BABE" cs.holdings
I have to agree with the arachnid
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of 2manyspiders@gmail.com
Sent: Friday, January 3, 2014 5:10 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Element number defs
Are you a COMPLETE fucking idiot?
Randy develops the add-in, makes it freely available and offers constant support. Never asks for a thing from anyone and you just show up with an attitude.
Why don't you piss off and never have anything to do with this group or Randy's add-in? That'll teach him.
asshole
From: smf_addin@yahoogrou
Sent: Friday, January 3, 2014 5:10 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Element number defs
Are you a COMPLETE fucking idiot?
Randy develops the add-in, makes it freely available and offers constant support. Never asks for a thing from anyone and you just show up with an attitude.
Why don't you piss off and never have anything to do with this group or Randy's add-in? That'll teach him.
asshole
Fri Jan 3, 2014 2:56 pm (PST) . Posted by:
"Jim Ranum" amt2100
You're kind of an ungrateful bitch, aren't you.
(Randy is too nice to say it.)
Go pay someone for all this.
Oh wait. There is no one.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Ton Sieverding
Sent: Friday, January 03, 2014 11:53 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Element number defs
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 <mailto:rharmelink@gmail.com>
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 ...
(Randy is too nice to say it.)
Go pay someone for all this.
Oh wait. There is no one.
From: smf_addin@yahoogrou
Sent: Friday, January 03, 2014 11:53 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Element number defs
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 <mailto:rharmelink@gmail.
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 3:02 pm (PST) . Posted by:
who1012000
Hello,
Happy New Year to all.
I am using a query to bring in ^DJI (5EDJI) price history. I actually page through itmultiple times and getting it from Yahoo.
But the Volume is wrong. Does anyone know where I might be able to get the same data as is on Yahoo, but with the correct volume? I am trying to get back to around year 2000. All of the web sites I have found do not show tables, only graphs.
Google has the data, but I can not figure out how to page through the data to get allof the data.
Thanks,
David
Happy New Year to all.
I am using a query to bring in ^DJI (5EDJI) price history. I actually page through itmultiple times and getting it from Yahoo.
But the Volume is wrong. Does anyone know where I might be able to get the same data as is on Yahoo, but with the correct volume? I am trying to get back to around year 2000. All of the web sites I have found do not show tables, only graphs.
Google has the data, but I can not figure out how to page through the data to get allof the data.
Thanks,
David
Fri Jan 3, 2014 3:25 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The daily file from here:
http://www.masterdatacsv.com/Downloads/Composites/NonSub.htm
...has data back to 1990. You can grab it with:
=smfGetCSVFile("
http://www.masterdatacsv.com/lite/DJ30Daily-CompositeStats.csv")
On Fri, Jan 3, 2014 at 4:02 PM, <who1012000@yahoo.com> wrote:
> I am using a query to bring in ^DJI (5EDJI) price history. I actually
> page through itmultiple times and getting it from Yahoo.
>
> But the Volume is wrong. Does anyone know where I might be able to get the
> same data as is on Yahoo, but with the correct volume? I am trying to get
> back to around year 2000. All of the web sites I have found do not show
> tables, only graphs.
>
> Google has the data, but I can not figure out how to page through the data
> to get allof the data.
>
http://www.masterda
...has data back to 1990. You can grab it with:
=smfGetCSVFile(
http://www.masterda
On Fri, Jan 3, 2014 at 4:02 PM, <who1012000@yahoo.
> I am using a query to bring in ^DJI (5EDJI) price history. I actually
> page through itmultiple times and getting it from Yahoo.
>
> But the Volume is wrong. Does anyone know where I might be able to get the
> same data as is on Yahoo, but with the correct volume? I am trying to get
> back to around year 2000. All of the web sites I have found do not show
> tables, only graphs.
>
> Google has the data, but I can not figure out how to page through the data
> to get allof the data.
>
Fri Jan 3, 2014 3:36 pm (PST) . Posted by:
"rex" bios007a
who1012000@yahoo.com <who1012000@yahoo.com> [2014-01-03 15:02]:
> I am using a query to bring in ^DJI (5EDJI) price history. I actually page
> through itmultiple times and getting it from Yahoo.
>
> But the Volume is wrong. Does anyone know where I might be able to get the
> same data as is on Yahoo, but with the correct volume? I am trying to get
> back to around year 2000. All of the web sites I have found do not show
> tables, only graphs.
This site has downloadable ^DJI, including volume, back to 2000.
http://www.tr4der.com/historical-prices/%5EDJI/
If you'd like the history back to 1928, send me an email. Data looks
like this:
op, hi, lo, cl, vol
1928-10-01,239.43,242.46,238.24,240.01,3500000
1928-10-02,240.01,241.54,235.42,238.14,3850000
1928-10-03,238.14,239.14,233.60,237.75,4060000
[...]
2013-12-30,16484.51,16504.35,16476.87,16504.29,54221109
2013-12-31,16512.38,16588.25,16511.48,16576.66,78759705
Happy New Year all, and a special thanks to Randy for his peerless
support.
HTH,
-rex
--
"Man is a credulous animal and must believe something. In the absence of
good grounds for belief, he will be satisfied with bad ones."
--Bertrand Russell, British philosopher (1872-1970)
> I am using a query to bring in ^DJI (5EDJI) price history. I actually page
> through itmultiple times and getting it from Yahoo.
>
> But the Volume is wrong. Does anyone know where I might be able to get the
> same data as is on Yahoo, but with the correct volume? I am trying to get
> back to around year 2000. All of the web sites I have found do not show
> tables, only graphs.
This site has downloadable ^DJI, including volume, back to 2000.
http://www.tr4der.
If you'd like the history back to 1928, send me an email. Data looks
like this:
op, hi, lo, cl, vol
1928-10-01,239.
1928-10-02,240.
1928-10-03,238.
[...]
2013-12-30,16484.
2013-12-31,16512.
Happy New Year all, and a special thanks to Randy for his peerless
support.
HTH,
-rex
--
"Man is a credulous animal and must believe something. In the absence of
good grounds for belief, he will be satisfied with bad ones."
--Bertrand Russell, British philosopher (1872-1970)
Fri Jan 3, 2014 4:04 pm (PST) . Posted by:
"David" who1012000
Thank you very much. I looked all over the place and could not find it.
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Friday, January 3, 2014 3:25 PM
>Subject: Re: [smf_addin] DJI historic price & volume
>
>
>
>
>
>
>
>The daily file from here:
>
>http://www.masterdatacsv.com/Downloads/Composites/NonSub.htm
>
>...has data back to 1990. You can grab it with:
>
>=smfGetCSVFile("http://www.masterdatacsv.com/lite/DJ30Daily-CompositeStats.csv")
>
>
>
>On Fri, Jan 3, 2014 at 4:02 PM, <who1012000@yahoo.com> wrote:
>
>I am using a query to bring in ^DJI (5EDJI) price history. I actually page through itmultiple times and getting it from Yahoo.
>>But the Volume is wrong. Does anyone know where I might be able to get the same data as is on Yahoo, but with the correct volume? I am trying to get back to around year 2000. All of the web sites I have found do not show tables, only graphs.
>>Google has the data, but I can not figure out how to page through the data to get allof the data.
>>
>
>
>
>
>
>
>________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Friday, January 3, 2014 3:25 PM
>Subject: Re: [smf_addin] DJI historic price & volume
>
>
>
>
>
>
>
>The daily file from here:
>
>http://www.masterda
>
>...has data back to 1990. You can grab it with:
>
>=smfGetCSVFile(
>
>
>
>On Fri, Jan 3, 2014 at 4:02 PM, <who1012000@yahoo.
>
>I am using a query to bring in ^DJI (5EDJI) price history. I actually page through itmultiple times and getting it from Yahoo.
>>But the Volume is wrong. Does anyone know where I might be able to get the same data as is on Yahoo, but with the correct volume? I am trying to get back to around year 2000. All of the web sites I have found do not show tables, only graphs.
>>Google has the data, but I can not figure out how to page through the data to get allof the data.
>>
>
>
>
>
>
>
Fri Jan 3, 2014 4:04 pm (PST) . Posted by:
"David" who1012000
Thank you vry much.
David
>________________________________
> From: rex <rex@nosyntax.net>
>To: smf_addin@yahoogroups.com
>Sent: Friday, January 3, 2014 3:36 PM
>Subject: Re: [smf_addin] DJI historic price & volume
>
>
>who1012000@yahoo.com <who1012000@yahoo.com> [2014-01-03 15:02]:
>> I am using a query to bring in ^DJI (5EDJI) price history. I actually page
>> through itmultiple times and getting it from Yahoo.
>>
>> But the Volume is wrong. Does anyone know where I might be able to get the
>> same data as is on Yahoo, but with the correct volume? I am trying to get
>> back to around year 2000. All of the web sites I have found do not show
>> tables, only graphs.
>
>This site has downloadable ^DJI, including volume, back to 2000.
>
>http://www.tr4der.com/historical-prices/%5EDJI/
>
>If you'd like the history back to 1928, send me an email. Data looks
>like this:
>
>op, hi, lo, cl, vol
>1928-10-01,239.43,242.46,238.24,240.01,3500000
>1928-10-02,240.01,241.54,235.42,238.14,3850000
>1928-10-03,238.14,239.14,233.60,237.75,4060000
>[...]
>2013-12-30,16484.51,16504.35,16476.87,16504.29,54221109
>2013-12-31,16512.38,16588.25,16511.48,16576.66,78759705
>
>Happy New Year all, and a special thanks to Randy for his peerless
>support.
>
>HTH,
>
>-rex
>--
>"Man is a credulous animal and must believe something. In the absence of
>good grounds for belief, he will be satisfied with bad ones."
>--Bertrand Russell, British philosopher (1872-1970)
>
>
>------------------------------------
>
>Yahoo Groups Links
>
>
>
>
>
>
David
>________
> From: rex <rex@nosyntax.
>To: smf_addin@yahoogrou
>Sent: Friday, January 3, 2014 3:36 PM
>Subject: Re: [smf_addin] DJI historic price & volume
>
>
>who1012000@yahoo.
>> I am using a query to bring in ^DJI (5EDJI) price history. I actually page
>> through itmultiple times and getting it from Yahoo.
>>
>> But the Volume is wrong. Does anyone know where I might be able to get the
>> same data as is on Yahoo, but with the correct volume? I am trying to get
>> back to around year 2000. All of the web sites I have found do not show
>> tables, only graphs.
>
>This site has downloadable ^DJI, including volume, back to 2000.
>
>http://www.tr4der.
>
>If you'd like the history back to 1928, send me an email. Data looks
>like this:
>
>op, hi, lo, cl, vol
>1928-10-
>1928-10-
>1928-10-
>[...]
>2013-12-
>2013-12-
>
>Happy New Year all, and a special thanks to Randy for his peerless
>support.
>
>HTH,
>
>-rex
>--
>"Man is a credulous animal and must believe something. In the absence of
>good grounds for belief, he will be satisfied with bad ones."
>--Bertrand Russell, British philosopher (1872-1970)
>
>
>--------
>
>Yahoo Groups Links
>
>
>
>
>
>
Tidak ada komentar:
Posting Komentar