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
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.
>
>
>
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.
>>
>>
>>
>
>
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.
>>>
>>>
>>>
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.
>>>>
>>>>
>>>>
>
>
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:
>>>
>>>
>>>
>>>
>>>
>>>
>
>
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.
>
>
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
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.
>
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
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?
>
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:
Posting Komentar