Selasa, 21 Juni 2011

[smf_addin] Digest Number 1863

Messages In This Digest (7 Messages)

Messages

1a.

Re: FX Rates

Posted by: "bushpilote" bushpilote@yahoo.ca   bushpilote

Mon Jun 20, 2011 6:08 am (PDT)



Hi Randy,
I just ran the "Pacific-Exchange-Rate" template for USD-EUR-GBP and was able to retrieve the croos-rates from January 1, 2011. However, when I change the start date to June 1, 2011 nothing shows up.

In addition, I have a simple spreadsheet, which uses "array-entered formulas" to pick up the exchange rates of the US$ against a bunch of other currencies on two different dates (point in time), that exhibits a similar behaviour. It likes some dates better than others and dates that work one day will not necessarly work the next day.

Is there something in my set up that's causing both the template and spreadsheet to behave this way?

--- In smf_addin@yahoogroups.com, "bushpilote" <bushpilote@...> wrote:
>
> Got it. Thanks
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > You need to array-enter the formula over a range -- here's the result I get:
> >
> > Jul.Day YYYY/MM/DD Wdy EUR/USD 2455716 2011/06/03 Fri 0.68475
> > But if you only enter the formula in a single cell, all you'd get is the
> > value for the first row and first column of the table.
> >
> > On Tue, Jun 7, 2011 at 5:12 AM, bushpilote <bushpilote@> wrote:
> >
> > >
> > > Works fine for you meaning that you are getting USDEUR rate of .6848?
> > >
> > > At my end the formula results in "Jul.Day". Formatting the cell in not an
> > > issue.
> > >
> >
>

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

Re: FX Rates

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

Mon Jun 20, 2011 8:29 am (PDT)



Not sure what to tell you -- I just tried the template with a 2011-06-01
starting date for USD-EUR-GBP and it worked fine for me...

I don't do anything with exchange rates, so I'm not familiar with the site's
reliability.

On Mon, Jun 20, 2011 at 6:07 AM, bushpilote <bushpilote@yahoo.ca> wrote:

>
> I just ran the "Pacific-Exchange-Rate" template for USD-EUR-GBP and was
> able to retrieve the croos-rates from January 1, 2011. However, when I
> change the start date to June 1, 2011 nothing shows up.
>
> In addition, I have a simple spreadsheet, which uses "array-entered
> formulas" to pick up the exchange rates of the US$ against a bunch of other
> currencies on two different dates (point in time), that exhibits a similar
> behaviour. It likes some dates better than others and dates that work one
> day will not necessarly work the next day.
>
> Is there something in my set up that's causing both the template and
> spreadsheet to behave this way?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2a.

Re: Use of smf_addins cause excel to hang (i.e. not respond)

Posted by: "E Spray" espray@optimum.net   espray

Mon Jun 20, 2011 8:21 am (PDT)



Hi Randy,

Thank you for the instructions on locating the XML Library version. I had the MSXML 3.0, which has now been updated to version 6.0. As suspected, no change in smf_addin functionality.

I have CA's security software on my machine. While initiating a Web Query, I can monitor the out / in bound traffic through the security software. I see the out bound data request as expected, but the in bound reply is being denied by something.

I'm searching through the IE8 settings and the security software for something that might work..... no success yet.

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

Re: Use of smf_addins cause excel to hang (i.e. not respond)

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

Mon Jun 20, 2011 11:15 am (PDT)



Hi Randy,

I have the same problem also (Excel 2010 with IE8). In my situation it appears to be the virus software that is causing the problem. Originally, when I had the problem, I was using Mcafee. When I uninstalled it from my system, I had no hangups when running the smfaddin. I then installed Microsoft security essentials thinking that it would be more compatible with Excel 2010. However, I am having the same problem again. Is there an appropriate setting in the anti-virus software that will not interfere with the add-in. Your help is much appreciated. Thanks.

--- In smf_addin@yahoogroups.com, "E Spray" <espray@...> wrote:
>
> Hi Randy,
>
> Thank you for the instructions on locating the XML Library version. I had the MSXML 3.0, which has now been updated to version 6.0. As suspected, no change in smf_addin functionality.
>
> I have CA's security software on my machine. While initiating a Web Query, I can monitor the out / in bound traffic through the security software. I see the out bound data request as expected, but the in bound reply is being denied by something.
>
> I'm searching through the IE8 settings and the security software for something that might work..... no success yet.
>

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

Different Search

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

Mon Jun 20, 2011 12:59 pm (PDT)



I have created alot of programs in excel using this wonderful addin. I have a question though about extracting information from a particular website for example: http://www.tricountyls.net/Market%20Report.htm

I am atempting to pull a specific weight class and the two numbers next to it. I am running into some trouble (alot) and completely coming up blank. Any assistance would be appreciated. Thanks.

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

Re: Different Search

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

Mon Jun 20, 2011 1:47 pm (PDT)



Try something like:

=RCHGetTableCell(URL,1,"Number of head:","under 300")
=RCHGetTableCell(URL,2,"Number of head:","under 300")
=RCHGetTableCell(URL,1,"Number of head:","under 300","under 300")
=RCHGetTableCell(URL,2,"Number of head:","under 300","under 300")

Don't use the "LBS." portion -- that appears to be after a line break in the
source code of the web page, so they'll screw up your data retrieval.

On Mon, Jun 20, 2011 at 12:58 PM, miketmpb <miketmpb@yahoo.com> wrote:

> I have created alot of programs in excel using this wonderful addin. I
> have a question though about extracting information from a particular
> website for example: http://www.tricountyls.net/Market%20Report.htm
>
> I am atempting to pull a specific weight class and the two numbers next to
> it. I am running into some trouble (alot) and completely coming up blank.
> Any assistance would be appreciated. Thanks.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4.

How to get "Annual Total Revenue" figure using Google Finance

Posted by: "dinesh s" dinesh_sstr@yahoo.co.in   dinesh_sstr

Tue Jun 21, 2011 2:19 am (PDT)



Randy,

How to get "Annual Total Revenue" figure using Google Finance & Yahoo Finance.

Thanks,
Dinesh.S
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
Recent Activity
Visit Your Group
Yahoo! Groups

Small Business Group

Improve your business

by community exchange

Check out the

Y! Groups blog

Stay up to speed

on all things Groups!

Need traffic?

Drive customers

With search ads

on Yahoo!

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
MARKETPLACE

Find useful articles and helpful tips on living with Fibromyalgia. Visit the Fibromyalgia Zone today!

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 04.03

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)