[smf_addin] Digest Number 4176

EXCEL Stock Market Functions Add-in Group

7 Messages

Digest #4176

1a

Re: The only one? by gbullr

1b

Re: The only one? by "Randy Harmelink" rharmelink

2a

Error Message for table by philip_r_small

2b

Re: Error Message for table by "Randy Harmelink" rharmelink

3a

DATA ELEMENT 809 by

3b

Re: DATA ELEMENT 809 by "Randy Harmelink" rharmelink

4a

Re: Macros for enabling/disabling the web cache by herbshack13

Messages

1a

Re: The only one?

Wed Oct 18, 2017 8:06 pm (PDT) . Posted by:

gbullr

Randy. Does SMF work w/ LibreOffice? There is a clone of the original extension on github. Thanks.

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

1b

Re: The only one?

Thu Oct 19, 2017 1:14 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It shouldn't work there.

On Wed, Oct 18, 2017 at 8:06 PM, gaston.bullrich@
​...
wrote:

>
> Randy. Does SMF work w/ LibreOffice? There is a clone of the original
> extension on github. Thanks.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

2a

Error Message for table

Thu Oct 19, 2017 7:07 am (PDT) . Posted by:

philip_r_small

HI Randy


I was bringing in economic data from the following web page
https://markets.ft.com/data/world/economic-calendar https://markets.ft.com/data/world/economic-calendar


I used RCHGetTableCell and it worked well for months but recently just gives error messages. Have they made the format unreadable?


[formula is varient of =RCHGetTableCell("https://markets.ft.com/data/world/economic-calendar",-7,">GMT",,,,1,,)) to bring in data items one at a time]


A similar formula still works fine with the following link to bring through UK data.


https://markets.ft.com/data/world/economic-calendar https://markets.ft.com/data/world/economic-calendar


Thanks in advance for your thoughts on this.

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Re: Error Message for table

Thu Oct 19, 2017 11:45 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I can't answer this one way or the other, because there is no data on the
web page I see at that URL. It apparently require a sign-in.

On Thu, Oct 19, 2017 at 7:03 AM, Philip_R_Small@
​...
wrote:

> I was bringing in economic data from the following web page
>
> *https://markets.ft.com/data/world/economic-calendar*
> <https://markets.ft.com/data/world/economic-calendar>
>
>
> I used RCHGetTableCell and it worked well for months but recently just
> gives error messages. Have they made the format unreadable?
>
>
> [formula is varient of =RCHGetTableCell("https://
> markets.ft.com/data/world/economic-calendar",-7,">GMT",,,,1,,)) to bring
> in data items one at a time]
>
>
> A similar formula still works fine with the following link to bring
> through UK data.
>
>
> *https://markets.ft.com/data/world/economic-calendar*
> <https://markets.ft.com/data/world/economic-calendar>
>
>
> Thanks in advance for your thoughts on this.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3a

DATA ELEMENT 809

Thu Oct 19, 2017 8:57 am (PDT) . Posted by:

Hi Randy,


Have been using DE 809 for quite some time. Now got "ERROR".


Any clues? COrrections?


Thanks


Armando

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3b

Re: DATA ELEMENT 809

Thu Oct 19, 2017 12:23 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried:

=RCHGetElementNumber("DE",809)

...and it appears to be working fine here. Temporary website glitch, maybe?

On Thu, Oct 19, 2017 at 8:57 AM, armando@
​...
wrote:

> Have been using DE 809 for quite some time. Now got "ERROR".
>
> Any clues? COrrections?
>
> ​​
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

4a

Re: Macros for enabling/disabling the web cache

Thu Oct 19, 2017 12:03 pm (PDT) . Posted by:

herbshack13

"RCHGetURLData() routine for the case when we get errors"

I personally love this idea.

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• Privacy • Unsubscribe • Terms of Use