[smf_addin] Digest Number 2190

EXCEL Stock Market Functions Add-in

Messages In This Digest (25 Messages)

1.1.

smfGetAdvFNElement From: gusto.duel

1.2.

Re: smfGetAdvFNElement From: Randy Harmelink

1.3.

Re: smfGetAdvFNElement From: gusto.duel

1.4.

Re: smfGetAdvFNElement From: Randy Harmelink

1.5.

Re: smfGetAdvFNElement From: gusto.duel

1.6.

Re: smfGetAdvFNElement From: gusto.duel

1.7.

Re: smfGetAdvFNElement From: Randy Harmelink

1.8.

Re: smfGetAdvFNElement From: gusto.duel

1.9.

Re: smfGetAdvFNElement From: Randy Harmelink

1.10.

Re: smfGetAdvFNElement From: gusto.duel

1.11.

Re: smfGetAdvFNElement From: Randy Harmelink

1.12.

Re: smfGetAdvFNElement From: gusto.duel

1.13.

Re: smfGetAdvFNElement From: Randy Harmelink

1.14.

Re: smfGetAdvFNElement From: gusto.duel

1.15.

Re: smfGetAdvFNElement From: gusto.duel

1.16.

Re: smfGetAdvFNElement From: Randy Harmelink

1.17.

Re: smfGetAdvFNElement From: gusto.duel

1.18.

Re: smfGetAdvFNElement From: Randy Harmelink

1.19.

Re: smfGetAdvFNElement From: gusto.duel

2.1.

Re: New file uploaded to smf_addin From: lezm001

2.2.

Re: New file uploaded to smf_addin From: Randy Harmelink

3a.

Re: MSN elements not working anymore From: codyklein

3b.

Re: MSN elements not working anymore From: Randy Harmelink

3c.

Re: MSN elements not working anymore From: Lawrence

4.1.

New file uploaded to smf_addin From: smf_addin@yahoogroups.com

View All Topics | Create New Topic

Messages

1.1.

smfGetAdvFNElement

Posted by: "gusto.duel" gusto.duel@yahoo.com   gusto.duel

Fri Apr 27, 2012 1:27 am (PDT)

Dear Randy,

I was wondering if the Templates illustrating smfGetAdvFNElement should work? They do not on my computer.

I get #NAME? all over the place.
I use Excel 2010 and the formula in B3 (ie)(Template All Line Items) is:

=IF(UPPER($B$2)="NONE","--",'C:\Program Files\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetADVFNElement($B$2,$B$3,999))

The ADD In is installed in "C:\Program Files\SMF Add-in".

I would appreciate any assistance.

Best regards,

Gusto

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.2.

Re: smfGetAdvFNElement

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Apr 27, 2012 1:33 am (PDT)

See the "Location Errors" entry in the "Links" area of the group.

On Fri, Apr 27, 2012 at 1:27 AM, gusto.duel <gusto.duel@yahoo.com> wrote:

>
> I was wondering if the Templates illustrating smfGetAdvFNElement should
> work? They do not on my computer.
>
> I get #NAME? all over the place.
> I use Excel 2010 and the formula in B3 (ie)(Template All Line Items) is:
>
> =IF(UPPER($B$2)="NONE","--",'C:\Program Files\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!smfGetADVFNElement($B$2,$B$3,999))
>
> The ADD In is installed in "C:\Program Files\SMF Add-in".
>
> I would appreciate any assistance.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.3.

Re: smfGetAdvFNElement

Posted by: "gusto.duel" gusto.duel@yahoo.com   gusto.duel

Fri Apr 27, 2012 1:56 am (PDT)

I have tried the OLDSCHOOLVALUE fix by adding uk before www:

Sub LoadAdvFNPrefix()
sAdvFNPrefix = "uk.www"
On Error GoTo ErrorExit
Open ThisWorkbook.Path & "\smf-AdvFN-Prefix.txt" For Input As #1
Line Input #1, sAdvFNPrefix
Close #1
ErrorExit:
End Sub

Still it works not.

FOr instance B3 in Template All Line Items:

=IF(UPPER($B$2)="NONE","--",smfGetADVFNElement($B$2,$B$3,999))
delivers "Error".

Everything other cell delivers #NAME and I see no formulas in them (but #NAME)

--- In smf_addin@yahoogroups.com, "gusto.duel" <gusto.duel@...> wrote:
>
> Dear Randy,
>
> I was wondering if the Templates illustrating smfGetAdvFNElement should work? They do not on my computer.
>
> I get #NAME? all over the place.
> I use Excel 2010 and the formula in B3 (ie)(Template All Line Items) is:
>
> =IF(UPPER($B$2)="NONE","--",'C:\Program Files\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetADVFNElement($B$2,$B$3,999))
>
> The ADD In is installed in "C:\Program Files\SMF Add-in".
>
> I would appreciate any assistance.
>
> Best regards,
>
> Gusto
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.4.

Re: smfGetAdvFNElement

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Apr 27, 2012 2:07 am (PDT)

If you change it to "uk" and you don't need to, it will CAUSE the error.

On Fri, Apr 27, 2012 at 1:56 AM, gusto.duel <gusto.duel@yahoo.com> wrote:

> I have tried the OLDSCHOOLVALUE fix by adding uk before www:
>
> Sub LoadAdvFNPrefix()
> sAdvFNPrefix = "uk.www"
> On Error GoTo ErrorExit
> Open ThisWorkbook.Path & "\smf-AdvFN-Prefix.txt" For Input As #1
> Line Input #1, sAdvFNPrefix
> Close #1
> ErrorExit:
> End Sub
>
> Still it works not.
>
> FOr instance B3 in Template All Line Items:
>
> =IF(UPPER($B$2)="NONE","--",smfGetADVFNElement($B$2,$B$3,999))
> delivers "Error".
>
> Everything other cell delivers #NAME and I see no formulas in them (but
> #NAME)
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.5.

Re: smfGetAdvFNElement

Posted by: "gusto.duel" gusto.duel@yahoo.com   gusto.duel

Fri Apr 27, 2012 2:10 am (PDT)

Thank you for this.

I have made some progress by fixing the location error:

Now in Template All Line Items, .
I see all of the formula.

But for some reason although I introduced MMM in B2 the result of the formulas is like it contains "NONE" so I get only "--" everywhere except:

- column C where I have the text headings
- cell B4 where I have "error"

Regards

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> See the "Location Errors" entry in the "Links" area of the group.
>
> On Fri, Apr 27, 2012 at 1:27 AM, gusto.duel <gusto.duel@...> wrote:
>
> >
> > I was wondering if the Templates illustrating smfGetAdvFNElement should
> > work? They do not on my computer.
> >
> > I get #NAME? all over the place.
> > I use Excel 2010 and the formula in B3 (ie)(Template All Line Items) is:
> >
> > =IF(UPPER($B$2)="NONE","--",'C:\Program Files\SMF
> > Add-in\RCH_Stock_Market_Functions.xla'!smfGetADVFNElement($B$2,$B$3,999))
> >
> > The ADD In is installed in "C:\Program Files\SMF Add-in".
> >
> > I would appreciate any assistance.
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.6.

Re: smfGetAdvFNElement

Posted by: "gusto.duel" gusto.duel@yahoo.com   gusto.duel

Fri Apr 27, 2012 2:15 am (PDT)

I did change it back.

However to have the column C text populated I had to make the following change:

IF(UPPER($B$2)="NONE","--",RCHGetTableCell("http://uk.advfn.com/p.php?pid=financials&symbol="&$B$2&"&mode="&IF($B$3="A","annual","quarterly")&"_reports",1,"Indicators",,,,ROWS($6:7),"</TABLE",,"--"))

When I type ADVFN in the browser it returns:

http://uk.advfn.com/

So now column C works. The rest is #NAME, except B4 which is "error"

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> If you change it to "uk" and you don't need to, it will CAUSE the error.
>
> On Fri, Apr 27, 2012 at 1:56 AM, gusto.duel <gusto.duel@...> wrote:
>
> > I have tried the OLDSCHOOLVALUE fix by adding uk before www:
> >
> > Sub LoadAdvFNPrefix()
> > sAdvFNPrefix = "uk.www"
> > On Error GoTo ErrorExit
> > Open ThisWorkbook.Path & "\smf-AdvFN-Prefix.txt" For Input As #1
> > Line Input #1, sAdvFNPrefix
> > Close #1
> > ErrorExit:
> > End Sub
> >
> > Still it works not.
> >
> > FOr instance B3 in Template All Line Items:
> >
> > =IF(UPPER($B$2)="NONE","--",smfGetADVFNElement($B$2,$B$3,999))
> > delivers "Error".
> >
> > Everything other cell delivers #NAME and I see no formulas in them (but
> > #NAME)
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.7.

Re: smfGetAdvFNElement

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Apr 27, 2012 2:22 am (PDT)

OK. That means you DO need the "uk" prefix. However, you still need to
remove all location paths, or EXCEL will be treating them as unresolved
links and never update them.

On Fri, Apr 27, 2012 at 2:15 AM, gusto.duel <gusto.duel@yahoo.com> wrote:

>
> When I type ADVFN in the browser it returns:
>
> http://uk.advfn.com/
>
> So now column C works. The rest is #NAME, except B4 which is "error"
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.8.

Re: smfGetAdvFNElement

Posted by: "gusto.duel" gusto.duel@yahoo.com   gusto.duel

Fri Apr 27, 2012 2:35 am (PDT)

Thank you for the quick feedback.

In the VBA I was only able to change here:
Sub LoadAdvFNPrefix()
sAdvFNPrefix = "uk"
On Error GoTo ErrorExit
Open ThisWorkbook.Path & "\smf-AdvFN-Prefix.txt" For Input As #1
Line Input #1, sAdvFNPrefix
Close #1
ErrorExit:
End Sub

That did not solve the B4 "error" and the ubiquitous #name

Is there another place where I shall replace "www" with "uk". I cannot find it neither in the "modGetADVFNElement" nor in the Excel workbook....

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> OK. That means you DO need the "uk" prefix. However, you still need to
> remove all location paths, or EXCEL will be treating them as unresolved
> links and never update them.
>
> On Fri, Apr 27, 2012 at 2:15 AM, gusto.duel <gusto.duel@...> wrote:
>
> >
> > When I type ADVFN in the browser it returns:
> >
> > http://uk.advfn.com/
> >
> > So now column C works. The rest is #NAME, except B4 which is "error"
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.9.

Re: smfGetAdvFNElement

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Apr 27, 2012 3:03 am (PDT)

Actually, you shouldn't be changing the VBA code at all. That is a new
routine I added so the prefix can be stored externally from the VBA code.
That way, you don't need to go change the VBA code every time there is a
new update to the add-in.

What you DO need to do is create a file in the same folder as add-in,
called "smf-AdvFN-Prefix.txt", All the file should contain is the two
letters "uk". You can create the file with notepad.

As noted in the "Links" entry item, the #NAME? errors have to be resolved
manually. I usually use the smfFixLinks macro, which is included in the
add-in.

On Fri, Apr 27, 2012 at 2:35 AM, gusto.duel <gusto.duel@yahoo.com> wrote:

>
> Thank you for the quick feedback.
>
> In the VBA I was only able to change here:
> Sub LoadAdvFNPrefix()
> sAdvFNPrefix = "uk"
> On Error GoTo ErrorExit
> Open ThisWorkbook.Path & "\smf-AdvFN-Prefix.txt" For Input As #1
> Line Input #1, sAdvFNPrefix
> Close #1
> ErrorExit:
> End Sub
>
> That did not solve the B4 "error" and the ubiquitous #name
>
> Is there another place where I shall replace "www" with "uk". I cannot
> find it neither in the "modGetADVFNElement" nor in the Excel workbook....
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.10.

Re: smfGetAdvFNElement

Posted by: "gusto.duel" gusto.duel@yahoo.com   gusto.duel

Fri Apr 27, 2012 3:35 am (PDT)

Thank you again.

I followed instructions (created smf-AdvFN-Prefix.txt, fixed the #NAME) and made more progress.

Still:

- it retrieves no data for any symbol but sees the B2 value as "NONE" and returns "--" except Column C where I see text values
- in B4 it displays "FALSE".

I reverted the VBA to original:

Sub LoadAdvFNPrefix()
sAdvFNPrefix = "www"
On Error GoTo ErrorExit
Open ThisWorkbook.Path & "\smf-AdvFN-Prefix.txt" For Input As #1
Line Input #1, sAdvFNPrefix
Close #1
ErrorExit:
End Sub

Below is the link I get for KO's financial statement on ADVFN site:

http://uk.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NYSE%3AKO

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Actually, you shouldn't be changing the VBA code at all. That is a new
> routine I added so the prefix can be stored externally from the VBA code.
> That way, you don't need to go change the VBA code every time there is a
> new update to the add-in.
>
> What you DO need to do is create a file in the same folder as add-in,
> called "smf-AdvFN-Prefix.txt", All the file should contain is the two
> letters "uk". You can create the file with notepad.
>
> As noted in the "Links" entry item, the #NAME? errors have to be resolved
> manually. I usually use the smfFixLinks macro, which is included in the
> add-in.
>
> On Fri, Apr 27, 2012 at 2:35 AM, gusto.duel <gusto.duel@...> wrote:
>
> >
> > Thank you for the quick feedback.
> >
> > In the VBA I was only able to change here:
> > Sub LoadAdvFNPrefix()
> > sAdvFNPrefix = "uk"
> > On Error GoTo ErrorExit
> > Open ThisWorkbook.Path & "\smf-AdvFN-Prefix.txt" For Input As #1
> > Line Input #1, sAdvFNPrefix
> > Close #1
> > ErrorExit:
> > End Sub
> >
> > That did not solve the B4 "error" and the ubiquitous #name
> >
> > Is there another place where I shall replace "www" with "uk". I cannot
> > find it neither in the "modGetADVFNElement" nor in the Excel workbook....
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.11.

Re: smfGetAdvFNElement

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Apr 27, 2012 3:57 am (PDT)

What do you get for:

=RCHGetElementNumber("Version")
=RCHGetTableCell("
http://uk.advfn.com/p.php?pid=financials&symbol=KO&mode=annual_reports&start_date=0",
1, "year end date")

On Fri, Apr 27, 2012 at 3:35 AM, gusto.duel <gusto.duel@yahoo.com> wrote:

>
> I followed instructions (created smf-AdvFN-Prefix.txt, fixed the #NAME)
> and made more progress.
>
> Still:
>
> - it retrieves no data for any symbol but sees the B2 value as "NONE" and
> returns "--" except Column C where I see text values
> - in B4 it displays "FALSE".
>
> I reverted the VBA to original:
>
> Sub LoadAdvFNPrefix()
> sAdvFNPrefix = "www"
> On Error GoTo ErrorExit
> Open ThisWorkbook.Path & "\smf-AdvFN-Prefix.txt" For Input As #1
> Line Input #1, sAdvFNPrefix
> Close #1
> ErrorExit:
> End Sub
>
> Below is the link I get for KO's financial statement on ADVFN site:
>
>
> http://uk.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NYSE%3AKO
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.12.

Re: smfGetAdvFNElement

Posted by: "gusto.duel" gusto.duel@yahoo.com   gusto.duel

Fri Apr 27, 2012 4:05 am (PDT)

Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program Files\SMF Add-in; 1)
1993/12

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> What do you get for:
>
> =RCHGetElementNumber("Version")
> =RCHGetTableCell("
> http://uk.advfn.com/p.php?pid=financials&symbol=KO&mode=annual_reports&start_date=0",
> 1, "year end date")
>
> On Fri, Apr 27, 2012 at 3:35 AM, gusto.duel <gusto.duel@...> wrote:
>
> >
> > I followed instructions (created smf-AdvFN-Prefix.txt, fixed the #NAME)
> > and made more progress.
> >
> > Still:
> >
> > - it retrieves no data for any symbol but sees the B2 value as "NONE" and
> > returns "--" except Column C where I see text values
> > - in B4 it displays "FALSE".
> >
> > I reverted the VBA to original:
> >
> > Sub LoadAdvFNPrefix()
> > sAdvFNPrefix = "www"
> > On Error GoTo ErrorExit
> > Open ThisWorkbook.Path & "\smf-AdvFN-Prefix.txt" For Input As #1
> > Line Input #1, sAdvFNPrefix
> > Close #1
> > ErrorExit:
> > End Sub
> >
> > Below is the link I get for KO's financial statement on ADVFN site:
> >
> >
> > http://uk.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NYSE%3AKO
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.13.

Re: smfGetAdvFNElement

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Apr 27, 2012 4:10 am (PDT)

Hmmm. Those work correctly.

What do you get for:

=smfGetAdvFNElement("KO","A",999)
=smfGetAdvFNElement("KO","A",1,">year end date<")

On Fri, Apr 27, 2012 at 4:05 AM, gusto.duel <gusto.duel@yahoo.com> wrote:

> Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program
> Files\SMF Add-in; 1)
> 1993/12
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > What do you get for:
> >
> > =RCHGetElementNumber("Version")
> > =RCHGetTableCell("
> http://uk.advfn.com/p.php?pid=financials&symbol=KO&mode=annual_reports&start_date=0",1,
> "year end date")
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.14.

Re: smfGetAdvFNElement

Posted by: "gusto.duel" gusto.duel@yahoo.com   gusto.duel

Fri Apr 27, 2012 4:12 am (PDT)

Error
Error

I have Excel 2010

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Hmmm. Those work correctly.
>
> What do you get for:
>
> =smfGetAdvFNElement("KO","A",999)
> =smfGetAdvFNElement("KO","A",1,">year end date<")
>
> On Fri, Apr 27, 2012 at 4:05 AM, gusto.duel <gusto.duel@...> wrote:
>
> > Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program
> > Files\SMF Add-in; 1)
> > 1993/12
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > What do you get for:
> > >
> > > =RCHGetElementNumber("Version")
> > > =RCHGetTableCell("
> > http://uk.advfn.com/p.php?pid=financials&symbol=KO&mode=annual_reports&start_date=0",1,
> > "year end date")
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.15.

Re: smfGetAdvFNElement

Posted by: "gusto.duel" gusto.duel@yahoo.com   gusto.duel

Fri Apr 27, 2012 4:13 am (PDT)

Error
Error

I have Excel 2010

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Hmmm. Those work correctly.
>
> What do you get for:
>
> =smfGetAdvFNElement("KO","A",999)
> =smfGetAdvFNElement("KO","A",1,">year end date<")
>
> On Fri, Apr 27, 2012 at 4:05 AM, gusto.duel <gusto.duel@...> wrote:
>
> > Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program
> > Files\SMF Add-in; 1)
> > 1993/12
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > What do you get for:
> > >
> > > =RCHGetElementNumber("Version")
> > > =RCHGetTableCell("
> > http://uk.advfn.com/p.php?pid=financials&symbol=KO&mode=annual_reports&start_date=0",1,
> > "year end date")
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.16.

Re: smfGetAdvFNElement

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Apr 27, 2012 4:17 am (PDT)

Not sure what to say, without stepping through the VBA code to see where
the error is occurring. From my side, it looks like those should work if
the previous RCHGetTableCell() function worked.

Long shot -- did you need to do the IE fix suggested by the AdvFN entry in
the "Links" area of the group?

In the VBA code, do you get to the RCHGetTableCell() invocation in the
function? What do the parameters look like?

On Fri, Apr 27, 2012 at 4:12 AM, gusto.duel <gusto.duel@yahoo.com> wrote:

> Error
> Error
>
> I have Excel 2010
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > Hmmm. Those work correctly.
> >
> > What do you get for:
> >
> > =smfGetAdvFNElement("KO","A",999)
> > =smfGetAdvFNElement("KO","A",1,">year end date<")
> >
> > On Fri, Apr 27, 2012 at 4:05 AM, gusto.duel <gusto.duel@...> wrote:
> >
> > > Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program
> > > Files\SMF Add-in; 1)
> > > 1993/12
> > >
> > > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > > >
> > > > What do you get for:
> > > >
> > > > =RCHGetElementNumber("Version")
> > > > =RCHGetTableCell("
> > >
> http://uk.advfn.com/p.php?pid=financials&symbol=KO&mode=annual_reports&start_date=0
> ",1,
> > > "year end date")
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.17.

Re: smfGetAdvFNElement

Posted by: "gusto.duel" gusto.duel@yahoo.com   gusto.duel

Fri Apr 27, 2012 4:33 am (PDT)

I was using Chrome
Changed Default to IE. Did not help.

Sorry - not able to answer VBA related questions.

I noted that when I open Excel it searches for the addin at the previous location c:\\SMF ...

Although I changed the location for to c:\\ Program Files... etc

EXcel seems to remember only the old location. I will re-install EXcel.

Maybe that will help.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Not sure what to say, without stepping through the VBA code to see where
> the error is occurring. From my side, it looks like those should work if
> the previous RCHGetTableCell() function worked.
>
> Long shot -- did you need to do the IE fix suggested by the AdvFN entry in
> the "Links" area of the group?
>
> In the VBA code, do you get to the RCHGetTableCell() invocation in the
> function? What do the parameters look like?
>
> On Fri, Apr 27, 2012 at 4:12 AM, gusto.duel <gusto.duel@...> wrote:
>
> > Error
> > Error
> >
> > I have Excel 2010
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > Hmmm. Those work correctly.
> > >
> > > What do you get for:
> > >
> > > =smfGetAdvFNElement("KO","A",999)
> > > =smfGetAdvFNElement("KO","A",1,">year end date<")
> > >
> > > On Fri, Apr 27, 2012 at 4:05 AM, gusto.duel <gusto.duel@> wrote:
> > >
> > > > Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program
> > > > Files\SMF Add-in; 1)
> > > > 1993/12
> > > >
> > > > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > > > >
> > > > > What do you get for:
> > > > >
> > > > > =RCHGetElementNumber("Version")
> > > > > =RCHGetTableCell("
> > > >
> > http://uk.advfn.com/p.php?pid=financials&symbol=KO&mode=annual_reports&start_date=0
> > ",1,
> > > > "year end date")
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.18.

Re: smfGetAdvFNElement

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Apr 27, 2012 4:35 am (PDT)

Re-installing EXCEL shouldn't do anything.

IE doesn't need to be the default browser. Microsoft products use the same
Internet Engine, regardless.

On Fri, Apr 27, 2012 at 4:33 AM, gusto.duel <gusto.duel@yahoo.com> wrote:

> I was using Chrome
> Changed Default to IE. Did not help.
>
> Sorry - not able to answer VBA related questions.
>
> I noted that when I open Excel it searches for the addin at the previous
> location c:\\SMF ...
>
> Although I changed the location for to c:\\ Program Files... etc
>
> EXcel seems to remember only the old location. I will re-install EXcel.
>
> Maybe that will help.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

1.19.

Re: smfGetAdvFNElement

Posted by: "gusto.duel" gusto.duel@yahoo.com   gusto.duel

Fri Apr 27, 2012 5:01 am (PDT)

Dear Randy,

Maybe it was due to the previous location of the addin.
Might it have forgotten about it after re-installing the addin (and Excel, too before reading your line)?

I am glad to say that it now works.
Thank you for the help and for the addin

Best regards.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Re-installing EXCEL shouldn't do anything.
>
> IE doesn't need to be the default browser. Microsoft products use the same
> Internet Engine, regardless.
>
> On Fri, Apr 27, 2012 at 4:33 AM, gusto.duel <gusto.duel@...> wrote:
>
> > I was using Chrome
> > Changed Default to IE. Did not help.
> >
> > Sorry - not able to answer VBA related questions.
> >
> > I noted that when I open Excel it searches for the addin at the previous
> > location c:\\SMF ...
> >
> > Although I changed the location for to c:\\ Program Files... etc
> >
> > EXcel seems to remember only the old location. I will re-install EXcel.
> >
> > Maybe that will help.
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (39)

2.1.

Re: New file uploaded to smf_addin

Posted by: "lezm001" lezm001@yahoo.com   lezm001

Fri Apr 27, 2012 6:36 am (PDT)

I noticed that element number 25 (last price) is not pulling in the last price. It appears to be pulling in the price from the day prior.

--- In smf_addin@yahoogroups.com, smf_addin@yahoogroups.com wrote:
>
>
> Hello,
>
> This email message is a notification to let you know that
> a file has been uploaded to the Files area of the smf_addin
> group.
>
> File : /Works-In-Progress/smf-elements-1.txt
> Uploaded by : rharmelink <rharmelink@...>
> Description : Contains updates to MSN data element definitions, which had to be redefined because of URL and page layout changes made by MSN. These definitions are used by the RCHGetElementNumber() function.
>
> You can access this file at the URL:
> http://groups.yahoo.com/group/smf_addin/files/Works-In-Progress/smf-elements-1.txt
>
> To learn more about file sharing for your group, please visit:
> http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
> Regards,
>
> rharmelink <rharmelink@...>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (260)

2.2.

Re: New file uploaded to smf_addin

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Apr 27, 2012 6:51 am (PDT)

Looks like an MSN problem -- that's what I saw on the web page the data was
retrieved from.

It looks fine now, so it could have been an issue with them resetting
things for the new day, since the error occurred prior to the day's opening
(including the 15-minute delay of the quote).

In any case, you should be using RCHGetYahooQuotes() instead of element 25.
I have always regretted creating that element and have come very close to
obsoleting it several times.

On Fri, Apr 27, 2012 at 6:36 AM, lezm001 <lezm001@yahoo.com> wrote:

> I noticed that element number 25 (last price) is not pulling in the last
> price. It appears to be pulling in the price from the day prior.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (260)

3a.

Re: MSN elements not working anymore

Posted by: "codyklein" codyklein@alum.drexel.edu   codyklein

Fri Apr 27, 2012 6:46 am (PDT)

Hi Randy, element number 13862 (company name) still does not appear to be working in the updated smf-elements-1 file

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Thanks for the heads up.
>
> Doing a "Find and Replace All" on the definitions file from:
>
> http://moneycentral.msn.com/investor/research/sreport.asp?
>
> ...to:
>
> http://investing.money.msn.com/investments/stock-report?
>
> ...appears to fix most of the errors, but I still have a number of elements
> still coming up error. They may have changed the content or layout of the
> page for those elements, or obsoleted them altogether.
>
> I won't release a new definitions file until more of the errors are gone.
>
> This is the fourth time in three years that MSN has changed the URLs of
> their website.
>
> On Thu, Apr 26, 2012 at 7:18 PM, MikeM <mikemcq802@...> wrote:
>
> > It seems MSN may have reconfigured their site. The element numbers 25 and
> > 46 are not working for any ticker (the only two I tried). If I type the
> > url from the smf-elements-txt file it shows a web page for creating a
> > report but you must select the items you want.
> >
> > This is the version I am using:
> > Stock Market Functions add-in, Version 2.1.2012.02.17
> >
> > This is a sample retrieval that is not working (gets "error").
> > =RCHGetElementNumber("VFC",25,,)
> >
> > Here's the url from the elements file:
> >
> > http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=VFC
> >
> > Interestingly, this page shows info:
> > http://investing.money.msn.com/investments/stock-price?Symbol=vfc&ocid=qbeb
> >
> > I tried the beta version 2012.04.07 too but that gave same results.
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

3b.

Re: MSN elements not working anymore

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Apr 27, 2012 7:02 am (PDT)

Just uploaded a new copy with a fix for that element...

On Fri, Apr 27, 2012 at 6:46 AM, codyklein <codyklein@alum.drexel.edu>wrote:

> Hi Randy, element number 13862 (company name) still does not appear to be
> working in the updated smf-elements-1 file
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

3c.

Re: MSN elements not working anymore

Posted by: "Lawrence" lawrence.leesh@gmail.com   lawleesh

Fri Apr 27, 2012 8:06 am (PDT)

Hi Randy

Where can I find this fix?

regards

LL

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Just uploaded a new copy with a fix for that element...
>
> On Fri, Apr 27, 2012 at 6:46 AM, codyklein <codyklein@...>wrote:
>
> > Hi Randy, element number 13862 (company name) still does not appear to be
> > working in the updated smf-elements-1 file
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

4.1.

New file uploaded to smf_addin

Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com

Fri Apr 27, 2012 7:01 am (PDT)

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Works-In-Progress/smf-elements-1.txt
Uploaded by : rharmelink <rharmelink@gmail.com>
Description : Contains updates to MSN data element definitions, which had to be redefined because of URL and page layout changes made by MSN. These definitions are used by the RCHGetElementNumber() function.

You can access this file at the URL:
http://groups.yahoo.com/group/smf_addin/files/Works-In-Progress/smf-elements-1.txt

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,

rharmelink <rharmelink@gmail.com>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (260)

Recent Activity

•  102
  New Members
•  2
  New Files

Visit Your Group

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Fashion News

What's the word on

fashion and style?

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe