[smf_addin] Digest Number 3322

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #3322

1a

Re: FX rates from Oanda by bushpilote

1b

Re: FX rates from Oanda by "Randy Harmelink" rharmelink

1c

Re: FX rates from Oanda by "Manish Sahajwani" manish_sahajwani

1d

Re: FX rates from Oanda by "Randy Harmelink" rharmelink

Messages

1a

Re: FX rates from Oanda

Thu Feb 12, 2015 4:58 am (PST) . Posted by:

bushpilote

Randy, at my end, the formula picks up the word "Currency";. What am I missing?

Thanks.

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

1b

Re: FX rates from Oanda

Thu Feb 12, 2015 5:02 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Sounds like you're just entering the formula into a single worksheet cell,
so you'd just get the first row and first column of the HTML table. If you
want the whole table, you need to array-enter the formula over a worksheet
range.

On Thu, Feb 12, 2015 at 5:58 AM, bushpilote@... wrote:

>
> Randy, at my end, the formula picks up the word "Currency";. What am I
> missing?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

1c

Re: FX rates from Oanda

Thu Feb 12, 2015 7:52 am (PST) . Posted by:

"Manish Sahajwani" manish_sahajwani

Hi Randy,

I was just wondering if it is not possible to create a few more functions
that allow you to directly read the api for fx calls rather than relying on
the html table?

Thanks,
Manish

On Thu, Feb 12, 2015 at 6:32 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Sounds like you're just entering the formula into a single worksheet cell,
> so you'd just get the first row and first column of the HTML table. If you
> want the whole table, you need to array-enter the formula over a worksheet
> range.
>
> On Thu, Feb 12, 2015 at 5:58 AM, bushpilote@... wrote:
>
>>
>> Randy, at my end, the formula picks up the word "Currency";. What am I
>> missing?
>>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

1d

Re: FX rates from Oanda

Thu Feb 12, 2015 5:16 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

What API are you referring to?

On Thu, Feb 12, 2015 at 8:52 AM, Manish Sahajwani msahajwani@...wrote:

>
> I was just wondering if it is not possible to create a few more functions
> that allow you to directly read the api for fx calls rather than relying on
> the html table?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 20

• Privacy • Unsubscribe • Terms of Use