[smf_addin] Digest Number 3279

EXCEL Stock Market Functions Add-in Group

6 Messages

Digest #3279

1a

Re: Any news to the Options Problem? by "Randy Harmelink" rharmelink

2a

Retrieving currency data by lawleesh

2b

Re: Retrieving currency data by "Randy Harmelink" rharmelink

2c

Re: Retrieving currency data by lawleesh

2d

Re: Retrieving currency data by "Randy Harmelink" rharmelink

3a

Re: Full Stock Name by "Paul Stobbe" stobbepe

Messages

1a

Re: Any news to the Options Problem?

Sun Dec 28, 2014 6:43 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I think most went back to the beta version before the Yahoo changes were
made:

http://ogres-crypt.com/SMF/Works-In-Progress/RCH_Stock_Market_Functions-2.1.2014.05.25.zip

...or are using OptionsXPress as the data source instead of Yahoo.

On Sun, Dec 28, 2014 at 2:45 AM, Axel Ronnisch aronnisch@... wrote:

>
> are there any news to the problem with the smfGetOptionQuotes and the
> changes Yahoo did?
> I am lost in Space without.
>
>

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

2a

Retrieving currency data

Sun Dec 28, 2014 7:42 am (PST) . Posted by:

lawleesh

Hi Randy


Is there a way to retrieve JPY/USD by specifying the dates?


thanks

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

2b

Re: Retrieving currency data

Sun Dec 28, 2014 9:59 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Take a look at this template in the FILES area of the Yahoo Group:

RCHGetTableCell-Template-Pacific-Exchange-Rate.xls

On Sun, Dec 28, 2014 at 8:42 AM, lawrence.leesh@...wrote:

>
> Is there a way to retrieve JPY/USD by specifying the dates?
>

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

2c

Re: Retrieving currency data

Sun Dec 28, 2014 2:21 pm (PST) . Posted by:

lawleesh

Is the file still working on your end? When I opened, all the cells below the column titles are blank. I only see four column titles - Date, Wdy, EUR/USD and Error.

thanks

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

2d

Re: Retrieving currency data

Sun Dec 28, 2014 3:18 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I had to change the date. 2006 was too far back. 2006 was fine when I
created the template years ago. :)

On Sun, Dec 28, 2014 at 3:21 PM, lawrence.leesh@... wrote:

>
> Is the file still working on your end? When I opened, all the cells below
> the column titles are blank. I only see four column titles - Date, Wdy,
> EUR/USD and Error.
>
>
>

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

3a

Re: Full Stock Name

Sun Dec 28, 2014 9:59 am (PST) . Posted by:

"Paul Stobbe" stobbepe

Hi Randy, fair point on the time involved, thanks for the reply.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, December 27, 2014 6:57 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Full Stock Name

The "full name" will depend on whatever you use as your data source.

If you have a different data source that you prefer, one of the SMF functions may be able to extract it from there. But scraping a web page, one ticker at a time, can take a while if you have a number of tickers. Is the extra time worth the effort?

On Sat, Dec 27, 2014 at 6:38 PM, 'Paul Stobbe' stobbepe@... wrote:

The Yahoo lookup URL returns the first 17 characters of a stock or fund. Is there a way to lookup or return the full name of the stock or fund using the ticker symbol?

Thanks for any help on this issue.

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

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

Visit Your Group

• New Members 38

• Privacy • Unsubscribe • Terms of Use