Selasa, 31 Mei 2016

[smf_addin] Digest Number 3715

12 Messages

Digest #3715
1b
Re: smfGetAdvFN no longer working by "Randy Harmelink" rharmelink
1d
Re: smfGetAdvFN no longer working by "Randy Harmelink" rharmelink
1f
Re: smfGetAdvFN no longer working by "Randy Harmelink" rharmelink
3b
Re: Extracting data from etnet by "Randy Harmelink" rharmelink
3d
Re: Extracting data from etnet by "Randy Harmelink" rharmelink

Messages

Mon May 30, 2016 6:35 am (PDT) . Posted by:

jsawyermib

Hi Randy


I really appreciate all your great work, so many thanks.


I have been using the below template to pull in historic P&L data for a little while and it has worked fine, Last year, Advfn changed the url's and you very kindly pointed me to the new ones. It was working fine up to about a month ago, but when I tried to run it today it wasn't pulling in any data, so I was wondering if the url has changed again and if you might be able to help.


I have updated for your most recent addins, but that wasn't able to resolve the issue unfortunately. The template I tried was the one below on your site: I also tried running it on another machine in case something on the original setup might have changed, but this didn't resolve the issue.


http://ogres-crypt.com/SMF/Templates/#smfGetAdvFNElement() http://ogres-crypt.com/SMF/Templates/#smfGetAdvFNElement()
me Size Last Modified Description smfGetAdvFNElement-Template-All-Line-Items.xls http://ogres-crypt.com/SMF/Templates/smfGetAdvFNElement-Template-All-Line-Items.xls 3249664 2015-10-28 04:00 AM

kind regards


John

Mon May 30, 2016 10:03 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmm. Just tried both templates from the website with ticker symbol MMM and
they populated normally here. What do you get with:

=RCHGetElementNumber("Version")

On Mon, May 30, 2016 at 6:35 AM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I really appreciate all your great work, so many thanks.
>
> I have been using the below template to pull in historic P&L data for a
> little while and it has worked fine, Last year, Advfn changed the url's and
> you very kindly pointed me to the new ones. It was working fine up to about
> a month ago, but when I tried to run it today it wasn't pulling in any
> data, so I was wondering if the url has changed again and if you might be
> able to help.
>
> I have updated for your most recent addins, but that wasn't able to
> resolve the issue unfortunately. The template I tried was the one below on
> your site: I also tried running it on another machine in case something on
> the original setup might have changed, but this didn't resolve the issue.
>
> http://ogres-crypt.com/SMF/Templates/#smfGetAdvFNElement()
> *me* *Size* *Last Modified* *Description*
> smfGetAdvFNElement-Template-All-Line-Items.xls
> <http://ogres-crypt.com/SMF/Templates/smfGetAdvFNElement-Template-All-Line-Items.xls>
> 3249664 2015-10-28 04:00 AM
>
>
> kind regards
>
>
> John
>
>
>
>

Mon May 30, 2016 11:57 pm (PDT) . Posted by:

jsawyermib

Hi Randy

I get the following result:

Stock Market Functions add-in, Version 2.1.2016.04.19 (C:\Add-ins\RCH_Stock_Market_Functions; www; Local; 44)


NB, the folder in which I have loaded your add-in is called "C:\Add-ins&#92;RCH_Stock_Market_Functions"


kind regards


John

Tue May 31, 2016 12:03 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Since you're in the UK, don't you get redirected to something other than
the "www" site?

When you say it wasn't pulling any data, what results WERE you getting?

On Mon, May 30, 2016 at 11:57 PM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I get the following result:
>
> Stock Market Functions add-in, Version 2.1.2016.04.19
> (C:\Add-ins\RCH_Stock_Market_Functions; www; Local; 44)
>
>
> NB, the folder in which I have loaded your add-in is called
> "C:\Add-ins&#92;RCH_Stock_Market_Functions"
>
>

Tue May 31, 2016 12:30 am (PDT) . Posted by:

jsawyermib

Hi Randy


I get the below result. The "C:\Add-ins&#92;RCH_Stock_Market_Functions" is the directory folder that I have downloaded your add-in to.

Stock Market Functions add-in, Version 2.1.2016.04.19 (C:\Add-ins\RCH_Stock_Market_Functions; www; Local; 44)


Kind Regards


Ajohn

Tue May 31, 2016 12:35 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I meant what result are you getting on the templates? You said they're not
pulling data. What are they giving you?

Where are you located? Do you need to set a prefix for AdvFN? When were
AdvFN functions last working?

On Tue, May 31, 2016 at 12:30 AM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I get the below result. The "C:\Add-ins&#92;RCH_Stock_Market_Functions" is the
> directory folder that I have downloaded your add-in to.
>
> Stock Market Functions add-in, Version 2.1.2016.04.19
> (C:\Add-ins\RCH_Stock_Market_Functions; www; Local; 44)
>
>
>

Mon May 30, 2016 11:01 am (PDT) . Posted by:

jterrenceho

Randy,

Thanks, I think I am getting it a little.

Mon May 30, 2016 6:21 pm (PDT) . Posted by:

alankc_mok

Dear Randy,

Thanks for your reply.

I am also trying to extract data from the below site https://webb-site.com/ccass/choldings.asp?issue=44 https://webb-site.com/ccass/choldings.asp?issue=44
In particular, I am looking for CCASS ID A00003, Holding, Last Change, Stake, Cumul. Stake.

Thanks

Alan

Mon May 30, 2016 8:01 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetTagContent("https://webb-site.com/ccass/choldings.asp?issue=44
","td",2,">Row",">A00003",,,1)
=smfGetTagContent("https://webb-site.com/ccass/choldings.asp?issue=44
","td",3,">Row",">A00003",,,1)
=smfGetTagContent("https://webb-site.com/ccass/choldings.asp?issue=44
","td",4,">Row",">A00003",,,1)
=smfGetTagContent("https://webb-site.com/ccass/choldings.asp?issue=44
","td",5,">Row",">A00003",,,1)

On Mon, May 30, 2016 at 6:21 PM, alankc_mok@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I am also trying to extract data from the below site
> https://webb-site.com/ccass/choldings.asp?issue=44
>
> In particular, I am looking for CCASS ID A00003, Holding, Last Change,
> Stake, Cumul. Stake.
>

Mon May 30, 2016 11:28 pm (PDT) . Posted by:

alankc_mok

Randy,

Thanks for your prompt reply.

I try the above , but cant retrieve the data.

Regards,

Alan

Mon May 30, 2016 11:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you. I just copied and pasted from the message, and
they worked fine for me.

What results are you seeing?

On Mon, May 30, 2016 at 11:28 PM, alankc_mok@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I try the above , but cant retrieve the data.
>
>

Tue May 31, 2016 1:59 am (PDT) . Posted by:

alankc_mok

Randy,

It is working now after I upgraded the Add in to the latest version.

Thanks

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

Tidak ada komentar:

Poskan Komentar