Jumat, 11 September 2015

[smf_addin] Digest Number 3508

10 Messages

Digest #3508

Messages

Thu Sep 10, 2015 3:16 am (PDT) . Posted by:

"Ranto Sb" sojuaon

Hi Randy and all,

I need your help how to get data exchange rate from yahoo finance.

thnx in advance.

regards,

//ranto

Thu Sep 10, 2015 3:20 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's just a matter of using Yahoo's special "ticker symbol" with the
RCHGetYahooQuotes() function. For example:

=RCHGetYahooQuotes("USDCAD=X","l1")

=RCHGetYahooQuotes("CADUSD=X","l1")

On Thu, Sep 10, 2015 at 3:11 AM, Ranto Sb rantosb@itb98.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I need your help how to get data exchange rate from yahoo finance.
>
>
>

Thu Sep 10, 2015 7:00 pm (PDT) . Posted by:

"Ranto Sb" sojuaon

thnx Randy, but how can if i want to get data with date range (eq. from
year 2010 to 2015)

regards,

//ranto

2015-09-10 17:20 GMT+07:00 Randy Harmelink rharmelink@gmail.com [smf_addin]
<smf_addin@yahoogroups.com>:

>
>
> It's just a matter of using Yahoo's special "ticker symbol" with the
> RCHGetYahooQuotes() function. For example:
>
> =RCHGetYahooQuotes("USDCAD=X","l1")
>
> =RCHGetYahooQuotes("CADUSD=X","l1")
>
> On Thu, Sep 10, 2015 at 3:11 AM, Ranto Sb rantosb@itb98.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> I need your help how to get data exchange rate from yahoo finance.
>>
>>
>>
>
>

Thu Sep 10, 2015 7:42 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

As far as I know, Yahoo doesn't carry historical data for exchange rates.

Try the RCHGetTableCell-Template-Pacific-Exchange-Rate.xls template from
the FILES area of the Yahoo group. I think it allows going back for four
years of data.

On Thu, Sep 10, 2015 at 7:00 PM, Ranto Sb rantosb@itb98.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> thnx Randy, but how can if i want to get data with date range (eq. from
> year 2010 to 2015)
>
> 2015-09-10 17:20 GMT+07:00 Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com>:
>
>>
>> It's just a matter of using Yahoo's special "ticker symbol" with the
>> RCHGetYahooQuotes() function. For example:
>>
>> =RCHGetYahooQuotes("USDCAD=X","l1")
>>
>> =RCHGetYahooQuotes("CADUSD=X","l1")
>>
>> On Thu, Sep 10, 2015 at 3:11 AM, Ranto Sb rantosb@itb98.com [smf_addin] <
>> smf_addin@yahoogroups.com> wrote:
>>
>>>
>>> I need your help how to get data exchange rate from yahoo finance.
>>>
>>>
>>>

Thu Sep 10, 2015 8:39 pm (PDT) . Posted by:

"Ranto Sb" sojuaon

Thnx Randy, do you have an information either yahoo finance to get exchange
rates historical data?is any, please share for me. i just see in index
mundi by graph not table.

regards,

thnx,

//ranto

2015-09-11 9:35 GMT+07:00 Randy Harmelink rharmelink@gmail.com [smf_addin] <
smf_addin@yahoogroups.com>:

>
>
> As far as I know, Yahoo doesn't carry historical data for exchange rates.
>
> Try the RCHGetTableCell-Template-Pacific-Exchange-Rate.xls template from
> the FILES area of the Yahoo group. I think it allows going back for four
> years of data.
>
> On Thu, Sep 10, 2015 at 7:00 PM, Ranto Sb rantosb@itb98.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> thnx Randy, but how can if i want to get data with date range (eq. from
>> year 2010 to 2015)
>>
>> 2015-09-10 17:20 GMT+07:00 Randy Harmelink rharmelink@gmail.com
>> [smf_addin] <smf_addin@yahoogroups.com>:
>>
>>>
>>> It's just a matter of using Yahoo's special "ticker symbol" with the
>>> RCHGetYahooQuotes() function. For example:
>>>
>>> =RCHGetYahooQuotes("USDCAD=X","l1")
>>>
>>> =RCHGetYahooQuotes("CADUSD=X","l1")
>>>
>>> On Thu, Sep 10, 2015 at 3:11 AM, Ranto Sb rantosb@itb98.com [smf_addin]
>>> <smf_addin@yahoogroups.com> wrote:
>>>
>>>>
>>>> I need your help how to get data exchange rate from yahoo finance.
>>>>
>>>>
>>>>
>
>

Thu Sep 10, 2015 8:47 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Do a search on the message archives and you may find something. I don't do
exchange rates myself, so I'm not familiar with other data sources. But as
I said, as far as I know, Yahoo doesn't have historical data for exchange
rates.

On Thu, Sep 10, 2015 at 8:39 PM, Ranto Sb rantosb@itb98.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thnx Randy, do you have an information either yahoo finance to get
> exchange rates historical data?is any, please share for me. i just see in
> index mundi by graph not table.
>
>

Thu Sep 10, 2015 5:18 pm (PDT) . Posted by:

markknutson2005

Randy, Did IBD reformat their site? All my data points just say error. I checked your template and it also says errors through out.


Thanks, Mark

Thu Sep 10, 2015 6:46 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried the template from the web site's Templates page, and it's
working fine for me.

Make sure you're logged in correctly to the IBD website, using the EXCEL
Web Query dialog.

On Thu, Sep 10, 2015 at 5:18 PM, mknu@juno.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Randy, Did IBD reformat their site? All my data points just say error. I
> checked your template and it also says errors through out.
>

Thu Sep 10, 2015 8:17 pm (PDT) . Posted by:

freefaller6

Hi Randy,


I found some interesting data on GuruFocus, and implemented the beta add-in to retrieve some of it. The sheet posted on the ogres website (smfGetGuruFocusItem-Full-Template.xls http://ogres-crypt.com/SMF/Works-In-Progress/smfGetGuruFocusItem-Full-Template.xls) works great through Item 137, but each Item thereafter retrieves all errors. Are you seeing the same thing?


Thanks (as always),
Brent

Thu Sep 10, 2015 8:57 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried the template from the web site, using ticker symbol MMM, and
items 138 thru 172 worked fine for me. I wouldn't expect 173 thru 185 to
work for MMM, since they are data items for financial companies.

But items 173 thru 185 work fine for me using ticker symbol WFC, although
some other data items no longer did, since they don't apply to financial
companies.

However, data items 138 and up are only available to subscribers. Are you
not logged in, or not a subscriber? I was hoping those data items would
return "Premium" instead of "Error" for those two situations.

On Thu, Sep 10, 2015 at 8:17 PM, freefaller6@... wrote:

> I found some interesting data on GuruFocus, and implemented the beta
> add-in to retrieve some of it. The sheet posted on the ogres website (
> smfGetGuruFocusItem-Full-Template.xls
> <http://ogres-crypt.com/SMF/Works-In-Progress/smfGetGuruFocusItem-Full-Template.xls>
> ) works great through Item 137, but each Item thereafter retrieves all
> errors. Are you seeing the same thing?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar