8 Messages
Digest #3277
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.
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(
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@.
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.
>
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@.
>
> 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.
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 smfForceRecalculati
On Fri, Dec 26, 2014 at 12:05 PM, 'Bernie Dudek' bdudek1172@.
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.
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 smfForceRecalculati
On Fri, Dec 26, 2014 at 12:05 PM, 'Bernie Dudek' bdudek1172@.
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.
=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 smfForceRecalculati
On Fri, Dec 26, 2014 at 12:05 PM, 'Bernie Dudek' bdudek1172@.
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?
>
However, ^DJI (and all other Dow Jones indexes) will not work with either
the RCHGetYahooQuotes(
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@.
>
> 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?
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(
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@.
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.
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 smfForceRecalculati
On Fri, Dec 26, 2014 at 12:05 PM, 'Bernie Dudek' bdudek1172@.
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