[smf_addin] Digest Number 4513

EXCEL Stock Market Functions Add-in Group

6 Messages

Digest #4513

1a

Currency rate by descormiersg@videotron.ca

1b

Re: Currency rate by "Randy Harmelink" rharmelink

1c

Re: Currency rate by "Higrm" higrm

1d

Re: Currency rate by descormiersg@videotron.ca

2a

Index SPY data at specific times by richardrobbins28

2b

Re: Index SPY data at specific times by "Randy Harmelink" rharmelink

Messages

1a

Currency rate

Fri Apr 5, 2019 8:30 am (PDT) . Posted by:

descormiersg@videotron.ca

Hi

Is there a possibility to get a currency rate (Cad/USD) for a date.

I would like to have the currency rate for the last day of each month.

I am also a gurufocus member. I don't know how to get the ticker for the
Cad/USD.

Thanks in advance

Guy

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

1b

Re: Currency rate

Fri Apr 5, 2019 9:47 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

An old example if getting historical quotes on exchange rates that still
appears to work:

=smfGetCSVFile("
http://fx.sauder.ubc.ca/cgi/fxdata?b=USD&c=EUR&c=GBP&rd=&y=daily&f=CSV&fd=1&fm=12&fy=2006
")

On Fri, Apr 5, 2019 at 9:10 AM descormiersg@... wrote:

>
>
> Is there a possibility to get a currency rate (Cad/USD) for a date.
>
> I would like to have the currency rate for the last day of each month.
>
>
>
>
>

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

1c

Re: Currency rate

Fri Apr 5, 2019 10:30 am (PDT) . Posted by:

"Higrm" higrm

I use this formula to get historic exchange rates from xe.com
=RCHGetTableCell("https://www.xe.com/currencytables/?from=USD&date="&TEXT(F11,"YYYY-MM-DD"),3,"Units per USD",">CAD")
you need a date in field F11, and it cannot be a holiday or you may get an error.  Depending on the currency, you may need to change the last two parameters in quotation marks.  To go from a different currency just change the "from=USD" to what you need.
I just love this add on.

On Friday, April 5, 2019, 7:00:47 PM GMT+2, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

An old example if getting historical quotes on exchange rates that still appears to work:
=smfGetCSVFile("http://fx.sauder.ubc.ca/cgi/fxdata?b=USD&c=EUR&c=GBP&rd=&y=daily&f=CSV&fd=1&fm=12&fy=2006")

On Fri, Apr 5, 2019 at 9:10 AM descormiersg@... wrote:

 

Is there a possibility to get a currency rate (Cad/USD) for a date.

I would like to have the currency rate for the last day of each month.

 

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

1d

Re: Currency rate

Fri Apr 5, 2019 11:47 am (PDT) . Posted by:

descormiersg@videotron.ca

Thanks a lot

De : smf_addin@yahoogroups.com <smf_addin@yahoogroups.com>
Envoyé : 5 avril 2019 13:31
À : Randy Harmelink rharmelink@gmail.com [smf_addin]
<smf_addin@yahoogroups.com>
Objet : Re: [smf_addin] Currency rate

I use this formula to get historic exchange rates from xe.com

=RCHGetTableCell("https://www.xe.com/currencytables/?from=USD
<https://www.xe.com/currencytables/?from=USD&date=>
&date="&TEXT(F11,"YYYY-MM-DD"),3,"Units per USD",">CAD")

you need a date in field F11, and it cannot be a holiday or you may get an
error. Depending on the currency, you may need to change the last two
parameters in quotation marks. To go from a different currency just change
the "from=USD" to what you need.

I just love this add on.

On Friday, April 5, 2019, 7:00:47 PM GMT+2, Randy Harmelink
rharmelink@gmail.com <mailto:rharmelink@gmail.com> [smf_addin]
<smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

An old example if getting historical quotes on exchange rates that still
appears to work:

=smfGetCSVFile("http://fx.sauder.ubc.ca/cgi/fxdata?b=USD
<http://fx.sauder.ubc..ca/cgi/fxdata?b=USD&c=EUR&c=GBP&rd=&y=daily&f=CSV&fd=
1&fm=12&fy=2006> &c=EUR&c=GBP&rd=&y=daily&f=CSV&fd=1&fm=12&fy=2006")

On Fri, Apr 5, 2019 at 9:10 AM descormiersg@... wrote:

Is there a possibility to get a currency rate (Cad/USD) for a date.

I would like to have the currency rate for the last day of each month.

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

2a

Index SPY data at specific times

Fri Apr 5, 2019 11:25 am (PDT) . Posted by:

richardrobbins28

Is there an existing function that would allow you to capture price information at a specific time of the day? The data obviously exists because yahoo graphs on a tick by tick basis. I just didn't know if there was a way to capture the information.

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

2b

Re: Index SPY data at specific times

Sat Apr 6, 2019 12:14 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm not sure it's true that Yahoo charts on a tick by tick basis?

I played around with intraday data a while back and found the data wasn't
reliable.

You can get the JSON file with something like:

https://query1.finance.yahoo.com/v8/finance/chart/MMM?symbol=MMM&period1=1554361747&period2=1554534547&interval=1m

....but you'd need to parse it out manually. There's no function to automate
the extraction.

On Fri, Apr 5, 2019 at 11:38 AM richardrobbins28@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Is there an existing function that would allow you to capture price
> information at a specific time of the day? The data obviously exists
> because yahoo graphs on a tick by tick basis. I just didn't know if there
> was a way to capture the information.
>
>

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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use