Sabtu, 27 Desember 2014

[smf_addin] Digest Number 3277

8 Messages

Digest #3277
1a
Re: SMF Add In by "Bernie Dudek" berniedudek
1b
Re: SMF Add In by "Randy Harmelink" rharmelink
1c
Re: SMF Add In by "Bernie Dudek" berniedudek
1d
Re: SMF Add In by "Bernie Dudek" berniedudek
1e
Re: SMF Add In by gaeisen
1f
Re: SMF Add In by "Randy Harmelink" rharmelink
1g
Re: SMF Add In by "Bernie Dudek" berniedudek
1h
Re: SMF Add In by "Bernie Dudek" berniedudek

Messages

Fri Dec 26, 2014 11:05 am (PST) . Posted by:

"Bernie Dudek" berniedudek

That made quite a difference and worked. Part of the key was the small l. I was using the piping symbol (|) which caused me problems. Is there a way to update the quotes without opening and closing the file. I tried refresh all under the data ribbon and that doesn't seem to work.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, December 25, 2014 4:24 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Add In

Try:

=RCHGetYahooQuotes("IBM","l1")

That 2-charter "l1" a lower case letter L and a number 1. I'm assuming they did it because it's kind of like, "Last one". :)

On Thu, Dec 25, 2014 at 2:29 PM, 'Bernie Dudek' bdudek1172@... wrote:

I'm still having trouble on figuring out how to code =RCHGetYahooQuotes to get the last price for IBM. I know the example you referenced me to show the last price as |1 but I can't find an element number for |1.

Fri Dec 26, 2014 11:12 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You need to run the smfForceRecalculation macro to update SMF functions.
See the "Tips and FAQs" web page for more detail on the macro.

On Fri, Dec 26, 2014 at 12:05 PM, 'Bernie Dudek' bdudek1172@... wrote:

>
> That made quite a difference and worked. Part of the key was the small l.
> I was using the piping symbol (|) which caused me problems. Is there a way
> to update the quotes without opening and closing the file. I tried refresh
> all under the data ribbon and that doesn't seem to work.
>

Fri Dec 26, 2014 12:25 pm (PST) . Posted by:

"Bernie Dudek" berniedudek

That worked!

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, December 26, 2014 1:13 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Add In

You need to run the smfForceRecalculation macro to update SMF functions. See the "Tips and FAQs" web page for more detail on the macro.

On Fri, Dec 26, 2014 at 12:05 PM, 'Bernie Dudek' bdudek1172@... wrote:

That made quite a difference and worked. Part of the key was the small l. I was using the piping symbol (|) which caused me problems. Is there a way to update the quotes without opening and closing the file. I tried refresh all under the data ribbon and that doesn't seem to work.

Fri Dec 26, 2014 12:55 pm (PST) . Posted by:

"Bernie Dudek" berniedudek

Do you know what the symbols the SMF functions use to get the Dow Jones Industrial Average and the NASDAQ Composite?

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, December 26, 2014 1:13 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Add In

You need to run the smfForceRecalculation macro to update SMF functions. See the "Tips and FAQs" web page for more detail on the macro.

On Fri, Dec 26, 2014 at 12:05 PM, 'Bernie Dudek' bdudek1172@... wrote:

That made quite a difference and worked. Part of the key was the small l. I was using the piping symbol (|) which caused me problems. Is there a way to update the quotes without opening and closing the file. I tried refresh all under the data ribbon and that doesn't seem to work.

Fri Dec 26, 2014 1:10 pm (PST) . Posted by:

gaeisen

I get the current price for the dow and the nasdaq by using:

=RCHGetTableCell("http://finance.yahoo.com/q/hp?s=%5EDJI+Historical+Prices",0,"Adj Close*",,,,2)

=RCHGetTableCell("http://finance.yahoo.com/q/hp?s=%5EIXIC+Historical+Prices",0,"Adj Close*",,,,2)

it seems to work.
Greg Eisen

----- Original Message -----

From: "'Bernie Dudek' bdudek1172@comcast.net [smf_addin]" <smf_addin@yahoogroups.com>
To: "smf addin" <smf_addin@yahoogroups.com>
Sent: Friday, December 26, 2014 12:56:01 PM
Subject: RE: [smf_addin] SMF Add In

Do you know what the symbols the SMF functions use to get the Dow Jones Industrial Average and the NASDAQ Composite?

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, December 26, 2014 1:13 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Add In

You need to run the smfForceRecalculation macro to update SMF functions. See the "Tips and FAQs" web page for more detail on the macro.

On Fri, Dec 26, 2014 at 12:05 PM, 'Bernie Dudek' bdudek1172@... wrote:

That made quite a difference and worked. Part of the key was the small l. I was using the piping symbol (|) which caused me problems. Is there a way to update the quotes without opening and closing the file. I tried refresh all under the data ribbon and that doesn't seem to work.

Fri Dec 26, 2014 1:30 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

As Greg noted, the symbols are ^DJI and ^IXIC.

However, ^DJI (and all other Dow Jones indexes) will not work with either
the RCHGetYahooQuotes() or RCHGetYahooHistory() functions. That's because
several years ago, Dow Jones tightened up the licensing on their indexes
and won't allow Yahoo to include their quotes in the CSV files they create.

I just use the ETF equivalents. I think they're better anyway, because when
looking at historical quotes and total returns, they include the dividends.
Unless you're actually trading index options, or something like that.

On Fri, Dec 26, 2014 at 1:56 PM, 'Bernie Dudek' bdudek1172@... wrote:

>
> Do you know what the symbols the SMF functions use to get the Dow Jones
> Industrial Average and the NASDAQ Composite?
>

Fri Dec 26, 2014 1:53 pm (PST) . Posted by:

"Bernie Dudek" berniedudek

Thanks.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, December 26, 2014 3:30 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Add In

As Greg noted, the symbols are ^DJI and ^IXIC.

However, ^DJI (and all other Dow Jones indexes) will not work with either the RCHGetYahooQuotes() or RCHGetYahooHistory() functions. That's because several years ago, Dow Jones tightened up the licensing on their indexes and won't allow Yahoo to include their quotes in the CSV files they create.

I just use the ETF equivalents. I think they're better anyway, because when looking at historical quotes and total returns, they include the dividends. Unless you're actually trading index options, or something like that.

On Fri, Dec 26, 2014 at 1:56 PM, 'Bernie Dudek' bdudek1172@... wrote:

Do you know what the symbols the SMF functions use to get the Dow Jones Industrial Average and the NASDAQ Composite?

Fri Dec 26, 2014 1:53 pm (PST) . Posted by:

"Bernie Dudek" berniedudek

Thanks

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, December 26, 2014 3:10 PM
To: smf addin
Subject: Re: [smf_addin] SMF Add In

I get the current price for the dow and the nasdaq by using:

=RCHGetTableCell("http://finance.yahoo.com/q/hp?s=%5EDJI+Historical+Prices",0,"Adj Close*",,,,2)

=RCHGetTableCell("http://finance.yahoo.com/q/hp?s=%5EIXIC+Historical+Prices",0,"Adj Close*",,,,2)

it seems to work.

Greg Eisen

_____

From: "'Bernie Dudek' bdudek1172@comcast.net [smf_addin]" <smf_addin@yahoogroups.com>
To: "smf addin" <smf_addin@yahoogroups.com>
Sent: Friday, December 26, 2014 12:56:01 PM
Subject: RE: [smf_addin] SMF Add In

Do you know what the symbols the SMF functions use to get the Dow Jones Industrial Average and the NASDAQ Composite?

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, December 26, 2014 1:13 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Add In

You need to run the smfForceRecalculation macro to update SMF functions. See the "Tips and FAQs" web page for more detail on the macro.

On Fri, Dec 26, 2014 at 12:05 PM, 'Bernie Dudek' bdudek1172@... wrote:

That made quite a difference and worked. Part of the key was the small l. I was using the piping symbol (|) which caused me problems. Is there a way to update the quotes without opening and closing the file. I tried refresh all under the data ribbon and that doesn't seem to work.

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

Tidak ada komentar:

Posting Komentar