5 New Messages
Digest #2508
Messages
Wed Feb 13, 2013 5:23 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Do either of these issues or their resolutions apply:
http://finance.groups.yahoo.com/group/smf_addin/message/21059
On Wed, Feb 13, 2013 at 6:04 AM, tw08x greif.tomas@gmail.com > wrote:
> Hi,
>
> I'm trying to get some financial data using smf plugin for the first time.
> I've followed all installation suggestions and still can't get the file
> smfGetAdvFNElement-Template-All-Line-Items.xls to work.
>
> In B4 there is always displayed "Error" whenever I put any ticker in B2.
> B2 value: GE
> B4 formula:
> =KDYŽ(VELKÁ($B$2)="NONE","--",smfGetADVFNElement($B$2,$B$3,999))
> Results in "Error"
>
> I've tested also some other formulas:
> =smfGetADVFNElement("MMM","A",1,">year end date<",,"--") produces --
> =smfGetADVFNElement("MMM","A",999) produces "Error"
> =RCHGetElementNumber("AAPL",2912) produces 13.81. (seems OK, so the plugin
> works at least partially)
>
> I have the following configuration:
> - Windows XP, SP3, updated, 32bit
> - MS Excel 2007, SP2 (12.0.6665.5003)
> - Excel language set to English
> - Excel is installed as Czech version, therefore all formulas are
> displayed in Czech version, e.g.:
> =KDYŽ(VELKÁ($B$2)="NONE","--",smfGetADVFNElement($B$2,$B$3,999))
>
> Any suggestions?
>
http://finance.
On Wed, Feb 13, 2013 at 6:04 AM, tw08x greif.tomas@
> Hi,
>
> I'm trying to get some financial data using smf plugin for the first time.
> I've followed all installation suggestions and still can't get the file
> smfGetAdvFNElement-
>
> In B4 there is always displayed "Error" whenever I put any ticker in B2.
> B2 value: GE
> B4 formula:
> =KDYŽ(VELKÁ($B$2)="
> Results in "Error"
>
> I've tested also some other formulas:
> =smfGetADVFNElement
> =smfGetADVFNElement
> =RCHGetElementNumbe
> works at least partially)
>
> I have the following configuration:
> - Windows XP, SP3, updated, 32bit
> - MS Excel 2007, SP2 (12.0.6665.5003)
> - Excel language set to English
> - Excel is installed as Czech version, therefore all formulas are
> displayed in Czech version, e.g.:
> =KDYŽ(VELKÁ($B$2)="
>
> Any suggestions?
>
Wed Feb 13, 2013 5:35 am (PST) . Posted by:
"tw08x" tw08x
Thank you, it was the redirect issue. I've added uk to smf-AdvFN-Prefix.txt file in the C:\SMF Add-in\ folder, restarted Excel and now it works. Obviously I also had to change formuls in smfGetAdvFNElement-Template-All-Line-Items.xls, e.g. C6:
=KDYŽ(VELKÁ($B$2)="NONE","--",RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&symbol= "&$B$2&"&mode="&KDYŽ($B$3="A","annual","quarterly")&"_reports",1,"Indicators",,,,ØÁDKY($6:6),"
http://uk.advfn.com/p.php?pid=financials&symbol= "&$B$2&"&mode="&KDYŽ($B$3="A","annual","quarterly")&"_reports",1,"Indicators",,,,ØÁDKY($6:6),"
smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Do either of these issues or their resolutions apply:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/21059
>
> On Wed, Feb 13, 2013 at 6:04 AM, tw08x wrote:
>
> > Hi,
> >
> > I'm trying to get some financial data using smf plugin for the first time.
> > I've followed all installation suggestions and still can't get the file
> > smfGetAdvFNElement-Template-All-Line-Items.xls to work.
> >
> > In B4 there is always displayed "Error" whenever I put any ticker in B2.
> > B2 value: GE
> > B4 formula:
> > =KDYŽ(VELKÃ($B$2)="NONE","--",smfGetADVFNElement($B$2,$B$3,999))
> > Results in "Error"
> >
> > I've tested also some other formulas:
> > =smfGetADVFNElement("MMM","A",1,">year end date<",,"--") produces --
> > =smfGetADVFNElement("MMM","A",999) produces "Error"
> > =RCHGetElementNumber("AAPL",2912) produces 13.81. (seems OK, so the plugin
> > works at least partially)
> >
> > I have the following configuration:
> > - Windows XP, SP3, updated, 32bit
> > - MS Excel 2007, SP2 (12.0.6665.5003)
> > - Excel language set to English
> > - Excel is installed as Czech version, therefore all formulas are
> > displayed in Czech version, e.g.:
> > =KDYŽ(VELKÃ($B$2)="NONE","--",smfGetADVFNElement($B$2,$B$3,999))
> >
> > Any suggestions?
> >
>
=KDYŽ(VELKÁ($B$
http://uk.advfn.
smf_addin@yahoogrou
>
> Do either of these issues or their resolutions apply:
>
> http://finance.
>
> On Wed, Feb 13, 2013 at 6:04 AM, tw08x wrote:
>
> > Hi,
> >
> > I'm trying to get some financial data using smf plugin for the first time.
> > I've followed all installation suggestions and still can't get the file
> > smfGetAdvFNElement-
> >
> > In B4 there is always displayed "Error" whenever I put any ticker in B2.
> > B2 value: GE
> > B4 formula:
> > =KDYŽ(VELKÃ($B$2)="
> > Results in "Error"
> >
> > I've tested also some other formulas:
> > =smfGetADVFNElement
> > =smfGetADVFNElement
> > =RCHGetElementNumbe
> > works at least partially)
> >
> > I have the following configuration:
> > - Windows XP, SP3, updated, 32bit
> > - MS Excel 2007, SP2 (12.0.6665.5003)
> > - Excel language set to English
> > - Excel is installed as Czech version, therefore all formulas are
> > displayed in Czech version, e.g.:
> > =KDYŽ(VELKÃ($B$2)="
> >
> > Any suggestions?
> >
>
Wed Feb 13, 2013 7:04 am (PST) . Posted by:
"1st Liberal" aprudente_99
Hi
Really like your application. Just to let you know that the above stock symbol seems to fool your comma fix routine. It seems like the Replace statement does not see the comma and the data is pushed over to the left by 1 cell. I believe the string comes back as P & F Industries, Inc.
Really like your application. Just to let you know that the above stock symbol seems to fool your comma fix routine. It seems like the Replace statement does not see the comma and the data is pushed over to the left by 1 cell. I believe the string comes back as P & F Industries, Inc.
Wed Feb 13, 2013 7:08 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmmm? What comma fix was that? I don't recall.
More details, please.
On Wed, Feb 13, 2013 at 7:58 AM, 1st Liberal aprudente_99@yahoo.com > wrote:
>
> Really like your application. Just to let you know that the above stock
> symbol seems to fool your comma fix routine. It seems like the Replace
> statement does not see the comma and the data is pushed over to the left by
> 1 cell. I believe the string comes back as P & F Industries, Inc.
>
More details, please.
On Wed, Feb 13, 2013 at 7:58 AM, 1st Liberal aprudente_99@
>
> Really like your application. Just to let you know that the above stock
> symbol seems to fool your comma fix routine. It seems like the Replace
> statement does not see the comma and the data is pushed over to the left by
> 1 cell. I believe the string comes back as P & F Industries, Inc.
>
Wed Feb 13, 2013 7:21 am (PST) . Posted by:
"Andrew" aprudente_99
Hi
I'm sorry, right problem, wrong guy.
regards,
andrew
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Wednesday, February 13, 2013 10:08 AM
Subject: Re: [smf_addin] Comma fix not working for stock symbol PFIN
Hmmm? What comma fix was that? I don't recall.
More details, please.
On Wed, Feb 13, 2013 at 7:58 AM, 1st Liberal aprudente_99@yahoo.com > wrote:
>Really like your application. Just to let you know that the above stock symbol seems to fool your comma fix routine. It seems like the Replace statement does not see the comma and the data is pushed over to the left by 1 cell. I believe the string comes back as P & F Industries, Inc.
>
I'm sorry, right problem, wrong guy.
regards,
andrew
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Wednesday, February 13, 2013 10:08 AM
Subject: Re: [smf_addin] Comma fix not working for stock symbol PFIN
Hmmm? What comma fix was that? I don't recall.
More details, please.
On Wed, Feb 13, 2013 at 7:58 AM, 1st Liberal aprudente_99@
>Really like your application. Just to let you know that the above stock symbol seems to fool your comma fix routine. It seems like the Replace statement does not see the comma and the data is pushed over to the left by 1 cell. I believe the string comes back as P & F Industries, Inc.
>
Tidak ada komentar:
Posting Komentar