11 New Messages
Digest #2545
Messages
Thu Mar 14, 2013 2:26 am (PDT) . Posted by:
"kristian_dms" kristian_dms
Thankyou, maybe I rushed my choice of function, I'll give smfPricesByDates() a shot, and see how that works out for me.
Thanks alot!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I don't know how using 50 Internet accesses makes the workload lighter...
>
> I think you'd be better off cloning a copy of the smfPricesByDates()
> function and modifying it to get adjusted opening prices instead of
> adjusted closing prices when you retrieve your set of dates in one Internet
> access...
>
> I think you'd just need to change the parameters of the
> RCHGetYahooHistory() function that it invokes.
>
> On Wed, Mar 13, 2013 at 11:51 PM, kristian_dms <thorup.dk@...> wrote:
>
> > Im sorry i should have explained this better. I have a list of dates from
> > which i want the opening price of the month of which that date belongs. I
> > refrain from doing it as an array, since grabbing 50+ arrays takes quite
> > some time, so i've made a sub that wil validate the data when i fetch it,
> > and hard-code it to excel to make the workload lighter when i calculate the
> > sheet.
> >
> > I have done some troubleshooting, and excel does not seem pleased with me
> > using "p" "m" and "O" so i tried removing the "", which let me move on. Not
> > sure what the correct workaround is here.
> >
> > Specifying the same beginning and end date enables me to get the monthly
> > opening to any historical date - April 1st 2009 will give me the opening
> > price of that month. This can possibly be done more elegant, but i havent
> > found a simpler method yet.
> >
> > I divide by 100 since the function for some reason returns 100.00 as 10000
> > on danish equity.
> >
> > To the target array is only one cell. Ive thought about using dim1:=1 ,
> > dim2:=2 but im not that well acquainted with the dim1,dim2 statements.
> >
> > Hope this all makes better sense. :)
> >
>
Thanks alot!
--- In smf_addin@yahoogrou
>
> I don't know how using 50 Internet accesses makes the workload lighter...
>
> I think you'd be better off cloning a copy of the smfPricesByDates(
> function and modifying it to get adjusted opening prices instead of
> adjusted closing prices when you retrieve your set of dates in one Internet
> access...
>
> I think you'd just need to change the parameters of the
> RCHGetYahooHistory(
>
> On Wed, Mar 13, 2013 at 11:51 PM, kristian_dms <thorup.dk@
>
> > Im sorry i should have explained this better. I have a list of dates from
> > which i want the opening price of the month of which that date belongs. I
> > refrain from doing it as an array, since grabbing 50+ arrays takes quite
> > some time, so i've made a sub that wil validate the data when i fetch it,
> > and hard-code it to excel to make the workload lighter when i calculate the
> > sheet.
> >
> > I have done some troubleshooting, and excel does not seem pleased with me
> > using "p" "m" and "O" so i tried removing the ""
> > sure what the correct workaround is here.
> >
> > Specifying the same beginning and end date enables me to get the monthly
> > opening to any historical date - April 1st 2009 will give me the opening
> > price of that month. This can possibly be done more elegant, but i havent
> > found a simpler method yet.
> >
> > I divide by 100 since the function for some reason returns 100.00 as 10000
> > on danish equity.
> >
> > To the target array is only one cell. Ive thought about using dim1:=1 ,
> > dim2:=2 but im not that well acquainted with the dim1,dim2 statements.
> >
> > Hope this all makes better sense. :)
> >
>
Thu Mar 14, 2013 2:38 am (PDT) . Posted by:
"weekeewawa" weekeewawa
additonally, there is a problem,
in the =RCHGetHTMLTable("http://finance.yahoo.com/q/mh?s=MMM ",">Top
Institutional",-1,"",2)
code for example. the s=MMM refers to 3M
however, i have a ticker at Cell A1 where i key in the symbol in it
how do i refer the Cell A1 to the code?
thanks
--- In smf_addin@yahoogroups.com , "weekeewawa" <weekeewawa@...> wrote:
>
> works well!
> but there is a problem with %out
>
> it seems that as this is an array, upon entering the % command to %out, it display for example 110% instead of 1.1%
>
> is there a way to overcome that?
> thanks
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > You need to array-enter them over a range, not a single cell. The first
> > cell *is* blank.
> >
> > On Thu, Mar 14, 2013 at 1:36 AM, weekeewawa <weekeewawa@> wrote:
> >
> > >
> > > it seems that the codes that are given is not working as it shows a blank
> > > cell. thanks
> > >
> > > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > > > Try:
> > > >
> > > > =RCHGetHTMLTable("http://finance.yahoo.com/q/mh?s=MMM ",">Top
> > > > Institutional",-1,"",2)
> > > > =RCHGetHTMLTable("http://finance.yahoo.com/q/mh?s=MMM ",">Top Mutual
> > > > Fund",-1,"",2)
> > >
> >
>
in the =RCHGetHTMLTable(
Institutional"
code for example. the s=MMM refers to 3M
however, i have a ticker at Cell A1 where i key in the symbol in it
how do i refer the Cell A1 to the code?
thanks
--- In smf_addin@yahoogrou
>
> works well!
> but there is a problem with %out
>
> it seems that as this is an array, upon entering the % command to %out, it display for example 110% instead of 1.1%
>
> is there a way to overcome that?
> thanks
>
> --- In smf_addin@yahoogrou
> >
> > You need to array-enter them over a range, not a single cell. The first
> > cell *is* blank.
> >
> > On Thu, Mar 14, 2013 at 1:36 AM, weekeewawa <weekeewawa@
> >
> > >
> > > it seems that the codes that are given is not working as it shows a blank
> > > cell. thanks
> > >
> > > --- In smf_addin@yahoogrou
> > > > Try:
> > > >
> > > > =RCHGetHTMLTable(
> > > > Institutional"
> > > > =RCHGetHTMLTable(
> > > > Fund",-
> > >
> >
>
Thu Mar 14, 2013 2:39 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's the way the table is presented, so that's the way it is retrieved.
You can do whatever you want with the data once it's retrieved -- add a
format that does what you want, add a work column where you divide by 100,
etc.
Alternatively, you could retrieve each data item with RCHGetTableCell(),
and divide those table items by 100.
On Thu, Mar 14, 2013 at 1:59 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
> works well!
> but there is a problem with %out
>
> it seems that as this is an array, upon entering the % command to %out, it
> display for example 110% instead of 1.1%
>
> is there a way to overcome that?
>
You can do whatever you want with the data once it's retrieved -- add a
format that does what you want, add a work column where you divide by 100,
etc.
Alternatively, you could retrieve each data item with RCHGetTableCell(
and divide those table items by 100.
On Thu, Mar 14, 2013 at 1:59 AM, weekeewawa <weekeewawa@yahoo.
> works well!
> but there is a problem with %out
>
> it seems that as this is an array, upon entering the % command to %out, it
> display for example 110% instead of 1.1%
>
> is there a way to overcome that?
>
Thu Mar 14, 2013 2:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
See: http://finance.groups.yahoo.com/group/smf_addin/message/21680
On Thu, Mar 14, 2013 at 2:38 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
> additonally, there is a problem,
>
> in the =RCHGetHTMLTable("http://finance.yahoo.com/q/mh?s=MMM ",">Top
> Institutional",-1,"",2)
>
> code for example. the s=MMM refers to 3M
>
> however, i have a ticker at Cell A1 where i key in the symbol in it
>
> how do i refer the Cell A1 to the code?
>
On Thu, Mar 14, 2013 at 2:38 AM, weekeewawa <weekeewawa@yahoo.
> additonally, there is a problem,
>
> in the =RCHGetHTMLTable(
> Institutional"
>
> code for example. the s=MMM refers to 3M
>
> however, i have a ticker at Cell A1 where i key in the symbol in it
>
> how do i refer the Cell A1 to the code?
>
Thu Mar 14, 2013 7:12 am (PDT) . Posted by:
"iamruf" iamruf
Concatenate I can do!
Many thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Just the normal EXCEL concatenation process. For example:
>
> ="...string1..."&A2
> =A2&"...string1..."
> ="...string1..."&A2&"...string2..."
>
> On Wed, Mar 13, 2013 at 2:38 PM, iamruf <iamruf@...> wrote:
>
> > Great - is there a way of grabbing cell A2 within the formula (containing
> > symbol GWW)?
> > Thanks
> >
>
Many thanks
--- In smf_addin@yahoogrou
>
> Just the normal EXCEL concatenation process. For example:
>
> ="...string1.
> =A2&"
> ="...string1.
>
> On Wed, Mar 13, 2013 at 2:38 PM, iamruf <iamruf@.
>
> > Great - is there a way of grabbing cell A2 within the formula (containing
> > symbol GWW)?
> > Thanks
> >
>
Thu Mar 14, 2013 9:15 am (PDT) . Posted by:
"jmkoeck" jmkoeck
Hello,
Is there an ElementNumber or another syntax (e.g. RCHGetWebData) that can utilize the the SML add-in to pull Morningstar Star Rating and Moat Rating for stocks into an excel spreadsheet?
Thanks.
Is there an ElementNumber or another syntax (e.g. RCHGetWebData) that can utilize the the SML add-in to pull Morningstar Star Rating and Moat Rating for stocks into an excel spreadsheet?
Thanks.
Thu Mar 14, 2013 9:25 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Check out the RCHGetTableCell-Template-Morningstar-Stock-Grades.xls
template in the FILES area of the group. I just updated it for a web page
issue...
On Thu, Mar 14, 2013 at 9:15 AM, jmkoeck <jmkoeck@hotmail.com > wrote:
>
> Is there an ElementNumber or another syntax (e.g. RCHGetWebData) that can
> utilize the the SML add-in to pull Morningstar Star Rating and Moat Rating
> for stocks into an excel spreadsheet?
>
template in the FILES area of the group. I just updated it for a web page
issue...
On Thu, Mar 14, 2013 at 9:15 AM, jmkoeck <jmkoeck@hotmail.
>
> Is there an ElementNumber or another syntax (e.g. RCHGetWebData) that can
> utilize the the SML add-in to pull Morningstar Star Rating and Moat Rating
> for stocks into an excel spreadsheet?
>
Thu Mar 14, 2013 11:00 am (PDT) . Posted by:
"jmkoeck" jmkoeck
Thanks for the update. Still having a bit of an issue when attempting to add the correct syntax into my own spreadsheet (based on your template). For example, for M* Rating I get "#VALUE!" and for Econ Moat and FV Uncert I get "Premium". Note: Growth, Profitability, and Fincl Health all work just fine.
Any thoughts? Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Check out the RCHGetTableCell-Template-Morningstar-Stock-Grades.xls
> template in the FILES area of the group. I just updated it for a web page
> issue...
>
> On Thu, Mar 14, 2013 at 9:15 AM, jmkoeck <jmkoeck@...> wrote:
>
> >
> > Is there an ElementNumber or another syntax (e.g. RCHGetWebData) that can
> > utilize the the SML add-in to pull Morningstar Star Rating and Moat Rating
> > for stocks into an excel spreadsheet?
> >
>
Any thoughts? Thanks.
--- In smf_addin@yahoogrou
>
> Check out the RCHGetTableCell-
> template in the FILES area of the group. I just updated it for a web page
> issue...
>
> On Thu, Mar 14, 2013 at 9:15 AM, jmkoeck <jmkoeck@
>
> >
> > Is there an ElementNumber or another syntax (e.g. RCHGetWebData) that can
> > utilize the the SML add-in to pull Morningstar Star Rating and Moat Rating
> > for stocks into an excel spreadsheet?
> >
>
Thu Mar 14, 2013 12:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sounds like you haven't created the IE security cookie. Those are
proprietary items on the MorningStar print report page, from where the data
is extracted.
On Thu, Mar 14, 2013 at 11:00 AM, jmkoeck <jmkoeck@hotmail.com > wrote:
> Thanks for the update. Still having a bit of an issue when attempting to
> add the correct syntax into my own spreadsheet (based on your template).
> For example, for M* Rating I get "#VALUE!" and for Econ Moat and FV Uncert
> I get "Premium". Note: Growth, Profitability, and Fincl Health all work
> just fine.
>
> Any thoughts? Thanks.
>
proprietary items on the MorningStar print report page, from where the data
is extracted.
On Thu, Mar 14, 2013 at 11:00 AM, jmkoeck <jmkoeck@hotmail.
> Thanks for the update. Still having a bit of an issue when attempting to
> add the correct syntax into my own spreadsheet (based on your template).
> For example, for M* Rating I get "#VALUE!
> I get "Premium"
> just fine.
>
> Any thoughts? Thanks.
>
Thu Mar 14, 2013 11:22 am (PDT) . Posted by:
"iamruf" iamruf
Hi Randy,
I don't see a code in the RCHGetYahooQuotes()function documentation for Shares Outstanding. Is this not recorded by Yahoo?
Regards
I don't see a code in the RCHGetYahooQuotes(
Regards
Thu Mar 14, 2013 12:42 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not available on their CSV file, as far as I know. They do have float, but
they display it with commas, which is NOT a good thing in a CSV file -- the
commas cause it to be parsed into separate fields.
FinViz has both float and outstanding shares on their screener CSV file
(see LINKS area for more info).
On Thu, Mar 14, 2013 at 11:22 AM, iamruf <iamruf@yahoo.com > wrote:
>
> I don't see a code in the RCHGetYahooQuotes()function documentation for
> Shares Outstanding. Is this not recorded by Yahoo?
>
they display it with commas, which is NOT a good thing in a CSV file -- the
commas cause it to be parsed into separate fields.
FinViz has both float and outstanding shares on their screener CSV file
(see LINKS area for more info).
On Thu, Mar 14, 2013 at 11:22 AM, iamruf <iamruf@yahoo.
>
> I don't see a code in the RCHGetYahooQuotes(
> Shares Outstanding. Is this not recorded by Yahoo?
>
Tidak ada komentar:
Posting Komentar