Senin, 30 April 2012

[smf_addin] Digest Number 2193

Messages In This Digest (5 Messages)

Messages

1.1.

Re: smfGetAdvFNElement

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

Sun Apr 29, 2012 6:27 am (PDT)



If you are using third party addons you should use excel32. Read this from microsoft:
http://office.microsoft.com/en-us/excel-help/choose-the-32-bit-or-64-bit-version-of-microsoft-office-HA010369476.aspx

Although the addin should work but I've run into other problems with 64 bit applications like IE until I switched over to 32 bit IE.
I use 32 on a 64 machine and I doubt I would notice the difference between the two.

--- In smf_addin@yahoogroups.com, "chrispycrunch" <cgl888@...> wrote:
>
> Unrelated question for this add-on. How do you make the VBA compatible for excel 64? The system keeps prompting me to add PTRSafe around the code to make it x64 compatible.
>
> --- 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 (44)
2.1.

Re: New file uploaded to smf_addin

Posted by: "ccrunning22" erikhove22@gmail.com   ccrunning22

Sun Apr 29, 2012 9:50 am (PDT)



Thanks for the update!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> 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 (261)
3a.

Having trouble adding a new element to smf-elements-20.txt

Posted by: "MikeM" mikemcq802@yahoo.com   mikemcq802

Sun Apr 29, 2012 7:38 pm (PDT)



I tried to follow the instructions in the LINKS section about user-defined functions but I can't get my first attempt to work.

I created a text file named smf-elements-20.txt in the SMF directory. It contains 1 line:

19000;WSJ;Company Name;=smfGetTagContent("http://quotes.wsj.com/~~~~~/company-people","p",1,"cr_company_desc")

This formula works fine when typed directly in my spreadsheet. The cell that tries to use this new function is simply:

=RCHGetElementNumber(ticker,19000)

this also works fine if I just change 19000 to some known good number so proves I haven't made a simple typo elsewhere.

Can you see what I've done wrong?

I'm using the 2012.04.07 version. I exit and restart Excel between each change/retry.

Oh, is it necessary to add the smf-elements-20.txt file name to the list of files in the smf-elements-text.info file? I've tried it both ways without effect but am hoping it's not necessary (to avoid trying to remember not to overlay it the next install).

Thanks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.

Re: Having trouble adding a new element to smf-elements-20.txt

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

Sun Apr 29, 2012 9:44 pm (PDT)



Unfortunately, one drawback of that way of defining an element is that it
uses the EVAL() VBA function. That has problems with long strings -- it
errors out if an internal string is over 255 bytes.

For example, the first formula here works, but the second gives a #VALUE!
error:

=smfEval("Rept(2,255)")
=smfEval("Rept(2,256)")

On Sun, Apr 29, 2012 at 7:38 PM, MikeM <mikemcq802@yahoo.com> wrote:

> I tried to follow the instructions in the LINKS section about user-defined
> functions but I can't get my first attempt to work.
>
> I created a text file named smf-elements-20.txt in the SMF directory. It
> contains 1 line:
>
> 19000;WSJ;Company Name;=smfGetTagContent("
> http://quotes.wsj.com/~~~~~/company-people","p",1,"cr_company_desc")
>
> This formula works fine when typed directly in my spreadsheet. The cell
> that tries to use this new function is simply:
>
> =RCHGetElementNumber(ticker,19000)
>
> this also works fine if I just change 19000 to some known good number so
> proves I haven't made a simple typo elsewhere.
>
> Can you see what I've done wrong?
>
> I'm using the 2012.04.07 version. I exit and restart Excel between each
> change/retry.
>
> Oh, is it necessary to add the smf-elements-20.txt file name to the list
> of files in the smf-elements-text.info file? I've tried it both ways
> without effect but am hoping it's not necessary (to avoid trying to
> remember not to overlay it the next install).
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4.

File upload notification

Posted by: "bizmark_ee" dustinsmoak@live.com   bizmark_ee

Mon Apr 30, 2012 12:55 am (PDT)



How do I get notified when a new file has been uploaded? Thanks.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
Recent Activity
Visit Your Group
Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

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
Diposting oleh EXCEL FEED LEARNING di 01.06

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)