Kamis, 26 April 2012

[smf_addin] Digest Number 2188

Messages In This Digest (10 Messages)

Messages

1a.

Re: Anyone have problems getting the AdvFN financial statements data

Posted by: "twoq2bstr8" simongbalzer@gmail.com   twoq2bstr8

Wed Apr 25, 2012 5:08 am (PDT)




Hi

Yes I'm having the same problem, I ran the AdvFN Fianacial Statements template in February and now coming up with error messages. I have checked the security settings as per the fix posted back in 2010.

Regards
Simon

--- In smf_addin@yahoogroups.com, "vallarinoanalytics" <vallarinoanalytics@...> wrote:
>
> Hi, Thanks for responding. I'm not sure which fix you are referring to. The Advfn data was working fine until about a week ago when nothing but error would come up. I do not believe I touched anything on my computer. Thanks
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Have you tried the "fix" mentioned in the "Links" area of the group?
> >
> > On Mon, Apr 16, 2012 at 7:41 AM, vallarinoanalytics <
> > vallarinoanalytics@> wrote:
> >
> > > It doesn't seem to work from my end...
> > >
> >
>

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

Re: Anyone have problems getting the AdvFN financial statements data

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

Wed Apr 25, 2012 5:40 am (PDT)



See if anything here helps:

http://www.oldschoolvalue.com/blog/forum/report-errors/attention-for-non-usa-users-how-to-fix-spreadsheets/

On Wed, Apr 25, 2012 at 2:29 AM, twoq2bstr8 <simongbalzer@gmail.com> wrote:

>
> Yes I'm having the same problem, I ran the AdvFN Fianacial Statements
> template in February and now coming up with error messages. I have checked
> the security settings as per the fix posted back in 2010.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2a.

Mutual Fund Rank in Category % - 3Yr

Posted by: "addison.ingle" addison.ingle@gmail.com   addison.ingle

Wed Apr 25, 2012 7:11 am (PDT)



Randy,

This data is element number 5043, and pulls from Yahoo. You have noted in earlier posts that if the return is NA, then Yahoo is no longer reporting the data. That does indeed seem to be the case. However, it appears that Morningstar is still providing that data on their website. I have experimented with GetTableCell quicktake....printreport without success, as well as =RCHGetTableCell("http://portfolios.morningstar.com/fund/summary?t="&$B3,1,"Rank in category & 3 yr"), also with no luck.

Could you possibly take a look at this? Many thanks in advance.....

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

Re: Mutual Fund Rank in Category % - 3Yr

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

Wed Apr 25, 2012 9:02 am (PDT)



I don't even see a rank in category on that web page. The performance tab,
as well as the print version of the performance tab, are both dynamically
generated web pages, so there are no values in the source code from which
to extract data.

And I don't see values on the old extractable print report:

http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=VFINX

On Wed, Apr 25, 2012 at 7:11 AM, addison.ingle <addison.ingle@gmail.com>wrote:

>
> This data is element number 5043, and pulls from Yahoo. You have noted in
> earlier posts that if the return is NA, then Yahoo is no longer reporting
> the data. That does indeed seem to be the case. However, it appears that
> Morningstar is still providing that data on their website. I have
> experimented with GetTableCell quicktake....printreport without success, as
> well as =RCHGetTableCell("
> http://portfolios.morningstar.com/fund/summary?t="&$B3,1,"Rank in
> category & 3 yr"), also with no luck.
>
> Could you possibly take a look at this? Many thanks in advance.....
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2c.

Re: Mutual Fund Rank in Category % - 3Yr

Posted by: "addison.ingle" addison.ingle@gmail.com   addison.ingle

Wed Apr 25, 2012 9:41 am (PDT)



Thanks for the reply.

I can see the number under the "Quote" tab, under Performance, % Rank in Cat, and then 3 and 5 year values. Should I assume that this page, too, is dynamically generated and thus does not have extractable data?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I don't even see a rank in category on that web page. The performance tab,
> as well as the print version of the performance tab, are both dynamically
> generated web pages, so there are no values in the source code from which
> to extract data.
>
> And I don't see values on the old extractable print report:
>
> http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=VFINX
>
> On Wed, Apr 25, 2012 at 7:11 AM, addison.ingle <addison.ingle@...>wrote:
>
> >
> > This data is element number 5043, and pulls from Yahoo. You have noted in
> > earlier posts that if the return is NA, then Yahoo is no longer reporting
> > the data. That does indeed seem to be the case. However, it appears that
> > Morningstar is still providing that data on their website. I have
> > experimented with GetTableCell quicktake....printreport without success, as
> > well as =RCHGetTableCell("
> > http://portfolios.morningstar.com/fund/summary?t="&$B3,1,"Rank in
> > category & 3 yr"), also with no luck.
> >
> > Could you possibly take a look at this? Many thanks in advance.....
> >
>

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

Re: Mutual Fund Rank in Category % - 3Yr

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

Wed Apr 25, 2012 9:55 am (PDT)



The "Quote" tab is also dynamically generated. Sorry.

On Wed, Apr 25, 2012 at 9:40 AM, addison.ingle <addison.ingle@gmail.com>wrote:

>
> I can see the number under the "Quote" tab, under Performance, % Rank in
> Cat, and then 3 and 5 year values. Should I assume that this page, too, is
> dynamically generated and thus does not have extractable data?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2e.

Re: Mutual Fund Rank in Category % - 3Yr

Posted by: "addison.ingle" addison.ingle@gmail.com   addison.ingle

Wed Apr 25, 2012 10:18 am (PDT)



Hey, you saved my bacon plenty already, Randy. Thanks for your help....

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The "Quote" tab is also dynamically generated. Sorry.
>
> On Wed, Apr 25, 2012 at 9:40 AM, addison.ingle <addison.ingle@...>wrote:
>
> >
> > I can see the number under the "Quote" tab, under Performance, % Rank in
> > Cat, and then 3 and 5 year values. Should I assume that this page, too, is
> > dynamically generated and thus does not have extractable data?
> >
>

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

Re: Latest user posting seems in error

Posted by: "Ron Spruell" hashky@yahoo.com   hashky

Wed Apr 25, 2012 10:48 am (PDT)



Here is what is going on.

I upload the file using Firefox.  The file gets hosed.  I get a hex display.

I upload the file using Internet Explorer.  The file is an .xls file.

I will contact Yahoo.  They may have a clue as to what is going on.

BTW, I am glad someone is using the file - or at least downloading it.

Ron Spruell

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Monday, April 23, 2012 9:43 AM
>Subject: Re: [smf_addin] Latest user posting seems in error
>
>
> 
>I agree. I got a hex display output page when I click on the link.
>
>
>On Mon, Apr 23, 2012 at 7:25 AM, Ryalmokas <ryalmokas@hotmail.com> wrote:
>
>I may be mistaken (won't be the first time), but Hashky's latest file posting ("Calls") seems not to be an xls file???
>>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4a.

Re: Call/Put Spreadsheet

Posted by: "bobc94595" conlonrc@comcast.net   bobc94595

Wed Apr 25, 2012 10:54 pm (PDT)



Thanks for the reference to Links. I have reviewed 9.5 and 9.4.2 in "Links." I am using Excel 2010 on a Win7 machine, and I have toggled "Every time..." per 9.4.2.

Under 9.5, where do I get, or how do I determine the macro name to type into the macro dialog window?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Check out items 9.5 and 9.4.2 in the "Links" area of the Yahoo group.
>
> On Fri, Mar 30, 2012 at 9:38 AM, bobc94595 <conlonrc@...> wrote:
>
> >
> > It appears that the spreadsheet works as intended at your end, but that I
> > cannot get it to work on my Win7 machine. Can you point me to the
> > smfForceRecalculation method. I have tried F9, Cntl-F9, Cntl-Shift-"r".
> >
> > Also, in a Win7 machine Internet Options site, what particular tab would I
> > go to to enable the refresh set up?
> >
>

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

Re: Call/Put Spreadsheet

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

Wed Apr 25, 2012 11:04 pm (PDT)



Just type in the full name: smfForceRecalculation

At that point, the buttons should activate.

On Wed, Apr 25, 2012 at 10:54 PM, bobc94595 <conlonrc@comcast.net> wrote:

>
> Under 9.5, where do I get, or how do I determine the macro name to type
> into the macro dialog window?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
Recent Activity
Visit Your Group
Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

Yahoo! News

Odd News

You won't believe

it, but it's true

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.18

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)