Jumat, 21 Februari 2014

[smf_addin] Digest Number 2975

10 Messages

Digest #2975

Messages

Thu Feb 20, 2014 5:04 am (PST) . Posted by:

philip_r_small

Hi Randy

I am getting an error in one of my formula this morning:

=RCHGetTableCell("http://uk.standardlifeinvestments.com/consumer/our_funds/fund_prices/multi_asset_funds.html",3,"Fund name",,,,7,,)
The code is to extract the unit price for the Global Absolute Return Strategies fund.
It has been working fine for weeks and other Cells are populating fine. As far as I can see there is no change to the underlying page.
Any assitance on tracking down the cause would be appreciated


Thu Feb 20, 2014 6:53 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you. I just cut and pasted your formula, and it works
fine here...

Try visiting the web page with the EXCEL Web Query dialog (keyboard
shortcut alt+d+d+w), and see if you go directly to that web page. The first
time I tried the web page, I got a splash screen instead of the data. Do
you get the data page or the splash screen?

On Thu, Feb 20, 2014 at 6:04 AM, <Philip_R_Small@hotmail.com> wrote:

>
> I am getting an error in one of my formula this morning:
>
> =RCHGetTableCell("
> http://uk.standardlifeinvestments.com/consumer/our_funds/fund_prices/multi_asset_funds.html",3,"Fund
> name",,,,7,,)
>
> The code is to extract the unit price for the Global Absolute Return
> Strategies fund.
>
> It has been working fine for weeks and other Cells are populating fine. As
> far as I can see there is no change to the underlying page.
>
> Any assitance on tracking down the cause would be appreciated
>

Thu Feb 20, 2014 8:52 am (PST) . Posted by:

philip_r_small

It has been working finr for weeks and just getting the error message today. IT have been messing with my machine doing other things, so i'll check internet settings. In the meantime I have got the price from another site and the RchGetTableCell works.


Thu Feb 20, 2014 6:08 am (PST) . Posted by:

"Nicholas" nikolasp

Thank you for the reply. I will continue to do as you suggested, clicking on "Continue"; as it seems to work anyway. Thanks again!

 
What haven't you noticed lately?

Thu Feb 20, 2014 8:32 am (PST) . Posted by:

nikolasp

A related question, is there a better way to get "real time" Yahoo quotes other than using the RunOnTime sub routine? It seems to be running very slow to the point of being unusable. I have set the # of seconds for the updates to 20 and the # of updates to 1000.

Thank you!

Thu Feb 20, 2014 12:26 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sounds like you need to array-enter the RCHGetYahooQuotes() formulas into
fewer formulas, to reduce the number of Internet accesses. But that won't
help if you're doing a number of functions other than RCHGetYahooQuotes().

On Thu, Feb 20, 2014 at 9:32 AM, <nikolasp@yahoo.com> wrote:

>
> A related question, is there a better way to get "real time" Yahoo quotes
> other than using the RunOnTime sub routine? It seems to be running very
> slow to the point of being unusable. I have set the # of seconds for the
> updates to 20 and the # of updates to 1000.
>

Thu Feb 20, 2014 9:49 am (PST) . Posted by:

devropr

Randy, it appears RCHGetElementNUmber 15014 for magic formula Return on Capital I no longer returning the value. Phil

Thu Feb 20, 2014 12:57 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I just tried it for MMM and IBM, and they worked fine for me.

The formula uses these elements -- which are not working for you?

=RCHGetElementNumber("MMM";,960)
=RCHGetElementNumber("MMM";,964)
=RCHGetElementNumber("MMM";,10026)

BTW, that was just a quick & dirty definition. Not nearly as detailed as
the one used by the Magic Formula.

On Thu, Feb 20, 2014 at 10:49 AM, <devropr@cox.net> wrote:

>
> Randy, it appears RCHGetElementNUmber 15014 for magic formula Return on
> Capital I no longer returning the value. Phil
>

Thu Feb 20, 2014 1:13 pm (PST) . Posted by:

rr76012

Hi Randy, Before I ever make any additions or changes to your file directly, I have learned a best practice is ask you first.


So, I presently use version: Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program Files\SMF Add-In; 1)


To use rchgetelementnumber #13946 "( BTW, element #13946 is no longer obsolete. It was reinstated on 2013-11-06. )".


Should I delete all the files under my smfaddin directory and download and replace all the files?


I am always afraid my spreadsheets won't work if I mess up and do something wrong.


Thanks,
rr76012




Thu Feb 20, 2014 1:53 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You shouldn't need to delete anything. Just extract all the files from the
ZIP archive into the folder, replacing any file when it gives you the
warning about a file already existing. You should exit EXCEL first, so
everything is loaded afresh when you restart EXCEL.

Note that there are already some new and redefined element definitions
since the last official release.

On Thu, Feb 20, 2014 at 2:12 PM, <rr76012@yahoo.com> wrote:

>
> Before I ever make any additions or changes to your file directly, I have
> learned a best practice is ask you first.
>
> So, I presently use version: Stock Market Functions add-in, Version
> 2.1.2012.12.29 (C:\Program Files\SMF Add-In; 1)
>
> To use rchgetelementnumber #13946 "( BTW, element #13946 is no longer
> obsolete. It was reinstated on 2013-11-06. )".
>
> Should I delete all the files under my smfaddin directory and download and
> replace all the files?
>
> I am always afraid my spreadsheets won't work if I mess up and do
> something wrong.
>
>
Diposting oleh EXCEL FEED LEARNING di 00.39

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)