Jumat, 05 Februari 2016

[smf_addin] Digest Number 3625

7 Messages

Digest #3625

Messages

Thu Feb 4, 2016 6:49 am (PST) . Posted by:

lezm001

Something changed, I'm no longer able to pull in values for some element numbers 4880 - 4887, 4674, 4811 and some others. I'm still able to pull in values for other elements numbers(5059,4949, 4950, 4938, 5102, 5109. I've noticed that some of the element definitions were recently update so I've updated those files on my computer. Any idea what else has changed that would prevent these values from being pulled into my file?

Thu Feb 4, 2016 8:45 am (PST) . Posted by:

"Randy Harmelink" rharmelink

It looks like MorningStar has deleted the web page that those statistics
were coming from, and it is now redirecting to their main web pages
instead. That is, the data items not working for you used to come from here:

http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=SPY

...which no longer exists.

The numbers that are working for you come from Yahoo web pages.

On Thu, Feb 4, 2016 at 7:49 AM, dlezman@steelcase.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Something changed, I'm no longer able to pull in values for some element
> numbers 4880 - 4887, 4674, 4811 and some others. I'm still able to pull
> in values for other elements numbers(5059,4949, 4950, 4938, 5102, 5109.
> I've noticed that some of the element definitions were recently update so
> I've updated those files on my computer. Any idea what else has changed
> that would prevent these values from being pulled into my file?
>

Thu Feb 4, 2016 8:52 am (PST) . Posted by:

nanastasakis

I'm using some of those same Morningstar numbers, do you have a fix or work-around in mind?

Thu Feb 4, 2016 9:15 am (PST) . Posted by:

"Randy Harmelink" rharmelink

It's a matter of remapping them to their new static web pages, such as:

http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY

...but I haven't gotten around to it. It's always more difficult to fix
mappings than to create them in the first place, especially when sometimes
the new data source doesn't quite mean the same thing. I think these are
pretty much one-for-one, but I haven't looked at it in detail. NAV vs Price
may be an issue.

They've now split the data up between 5 or 6 pages, instead of having
everything available on one nice print page like before.

On Thu, Feb 4, 2016 at 9:52 AM, nanastasakis@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I'm using some of those same Morningstar numbers, do you have a fix or
> work-around in mind?
>
>

Thu Feb 4, 2016 10:07 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Sigh. I remember why I stopped looking at it before -- ETFs and Mutual fund
pages are different. And they split up returns between price and NAV. And
the indexes are parameter driven instead of fixed for each equity.

There really is no one-on-one mapping between old and new.

Sigh.

On Thu, Feb 4, 2016 at 9:52 AM, nanastasakis@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I'm using some of those same Morningstar numbers, do you have a fix or
> work-around in mind?
>

Thu Feb 4, 2016 8:35 am (PST) . Posted by:

DefelRadar

Randy,

I am using trying to use the UpdateDownloadTable method of updating all my RCHGetElementNumber() functions and it seems to work great for instance where I only use one RCHGetElementNumber() function.


I have many cells where I use the RCHGetElementNumber() + RCHGetElementNumber() to add the results of both the function calls. I also have formula results that are much more complicated that the above but I was wondering if you can use the UpdateDownloadTable method by putting RCHGetElementNumber() + RCHGetElementNumber() in one cell above the headers or are you restricted to putting in a single RCHGetElementNumber() call per cell?


thanks,


Aaron

Thu Feb 4, 2016 9:06 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You can do formulas in the field definition.

You can even do hard-coded referbacks like:

IF(~~~3~~~<rNow,~~~4~~~,~~~3~~~)

...where "~~~3~~~" says to get the value from three columns earlier, and
"~~~4~~~" says to get the value from four columns earlier. However, this
gets dangerous, because if you insert or delete a column, those hard-coded
reference get all fouled up. So now I'm doing a more complicated:

="IF(~~~"&COLUMNS(E:H)-1&"~~~<rNow,~~~"&COLUMNS(D:H)-1&"~~~,~~~"&COLUMNS(E:H)-1&"~~~)"

...which is in column H and says to get the values from columns E and D.
So, now if column G is deleted, the referback on the columns adjusts
automatically.

Note also that both of the above formulas have a named range of "rNow". As
long as that is a fixed location, it can be used in a formula.

I've also gone a step further, to make something like that last formula
more readable. For example:

="IF(ISNUMBER("&cBid2&"),(MIN("&cStrike2&","&cPrice&")+"&cBid2&")/"&cPrice&"-1,""--"")"

...where "cBId2" (for column U) is a named range with a definition of:

=TEXT(COLUMNS(U:$Q)-1,"~~~0~~~")

Each of the other named ranges in the formula are similar, to automatically
create that referback value. Right now, if I were to convert that formula
to hard-coded referbacks, it would look like this:

IF(ISNUMBER(~~~4~~~),(MIN(~~~3~~~,~~~14~~~)+~~~4~~~)/~~~14~~~-1,"--")

But a hard-coded 14-column referback can really be a problem if I start
inserting and deleting columns, or moving things around.

It can get a bit tricky. :)

On Thu, Feb 4, 2016 at 9:35 AM, defelradar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I am using trying to use the UpdateDownloadTable method of updating all my
> RCHGetElementNumber() functions and it seems to work great for instance
> where I only use one RCHGetElementNumber() function.
>
> I have many cells where I use the RCHGetElementNumber() +
> RCHGetElementNumber() to add the results of both the function calls. I
> also have formula results that are much more complicated that the above but
> I was wondering if you can use the UpdateDownloadTable method by putting RCHGetElementNumber()
> + RCHGetElementNumber() in one cell above the headers or are you restricted
> to putting in a single RCHGetElementNumber() call per cell?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar