11 New Messages
Digest #2739
Messages
Mon Aug 19, 2013 6:54 am (PDT) . Posted by:
"john.kalkanis" john.kalkanis
how frequently are data from OX updated?
what does the underlying price refer to (last, bid, ask)?
thanks
what does the underlying price refer to (last, bid, ask)?
thanks
Mon Aug 19, 2013 8:01 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
As far as I know, the quotes on OX are constantly updated. But your
workbook will only update if you run the smfForceRecalculation macro (see
LINKS area of Yahoo group for more info).
The underlying price is the last traded price of the equity the option is
based on.
On Mon, Aug 19, 2013 at 6:54 AM, john.kalkanis <john.kalkanis@yahoo.com >wrote:
> how frequently are data from OX updated?
> what does the underlying price refer to (last, bid, ask)?
>
workbook will only update if you run the smfForceRecalculati
LINKS area of Yahoo group for more info).
The underlying price is the last traded price of the equity the option is
based on.
On Mon, Aug 19, 2013 at 6:54 AM, john.kalkanis <john.kalkanis@
> how frequently are data from OX updated?
> what does the underlying price refer to (last, bid, ask)?
>
Mon Aug 19, 2013 8:30 am (PDT) . Posted by:
"john.kalkanis" john.kalkanis
SSYS has been trading above $106 during the last hour while smfGetOptionQuotes is still giving me $99.23 since more than one hour. i have run the smfForceRecalculation macro. why could that be?
by the way how did you add che smfForceRecalculation button on your excel Quick Access Toolbar?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> As far as I know, the quotes on OX are constantly updated. But your
> workbook will only update if you run the smfForceRecalculation macro (see
> LINKS area of Yahoo group for more info).
>
> The underlying price is the last traded price of the equity the option is
> based on.
>
> On Mon, Aug 19, 2013 at 6:54 AM, john.kalkanis <john.kalkanis@...>wrote:
>
> > how frequently are data from OX updated?
> > what does the underlying price refer to (last, bid, ask)?
> >
>
by the way how did you add che smfForceRecalculati
--- In smf_addin@yahoogrou
>
> As far as I know, the quotes on OX are constantly updated. But your
> workbook will only update if you run the smfForceRecalculati
> LINKS area of Yahoo group for more info).
>
> The underlying price is the last traded price of the equity the option is
> based on.
>
> On Mon, Aug 19, 2013 at 6:54 AM, john.kalkanis <john.kalkanis@
>
> > how frequently are data from OX updated?
> > what does the underlying price refer to (last, bid, ask)?
> >
>
Mon Aug 19, 2013 8:31 am (PDT) . Posted by:
"john.kalkanis" john.kalkanis
is there a way to get the ask price for the underlying?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> As far as I know, the quotes on OX are constantly updated. But your
> workbook will only update if you run the smfForceRecalculation macro (see
> LINKS area of Yahoo group for more info).
>
> The underlying price is the last traded price of the equity the option is
> based on.
>
> On Mon, Aug 19, 2013 at 6:54 AM, john.kalkanis <john.kalkanis@...>wrote:
>
> > how frequently are data from OX updated?
> > what does the underlying price refer to (last, bid, ask)?
> >
>
--- In smf_addin@yahoogrou
>
> As far as I know, the quotes on OX are constantly updated. But your
> workbook will only update if you run the smfForceRecalculati
> LINKS area of Yahoo group for more info).
>
> The underlying price is the last traded price of the equity the option is
> based on.
>
> On Mon, Aug 19, 2013 at 6:54 AM, john.kalkanis <john.kalkanis@
>
> > how frequently are data from OX updated?
> > what does the underlying price refer to (last, bid, ask)?
> >
>
Mon Aug 19, 2013 1:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Did you read the second item in the LINKS area related to
smfForceRecalculation? You may have to change your Internet Options so that
IE isn't caching web pages. You need to make sure that IE is always getting
a fresh copy of the web page from the Internet.
In EXCEL 2007, just choose to customize the QAT and then add the macro...
http://www.dummies.com/how-to/content/how-to-add-an-excel-2007-macro-to-the-quick-access.html
On Mon, Aug 19, 2013 at 8:30 AM, john.kalkanis <john.kalkanis@yahoo.com >wrote:
> SSYS has been trading above $106 during the last hour while
> smfGetOptionQuotes is still giving me $99.23 since more than one hour. i
> have run the smfForceRecalculation macro. why could that be?
>
> by the way how did you add che smfForceRecalculation button on your excel
> Quick Access Toolbar?
>
smfForceRecalculati
IE isn't caching web pages. You need to make sure that IE is always getting
a fresh copy of the web page from the Internet.
In EXCEL 2007, just choose to customize the QAT and then add the macro...
http://www.dummies.
On Mon, Aug 19, 2013 at 8:30 AM, john.kalkanis <john.kalkanis@
> SSYS has been trading above $106 during the last hour while
> smfGetOptionQuotes is still giving me $99.23 since more than one hour. i
> have run the smfForceRecalculati
>
> by the way how did you add che smfForceRecalculati
> Quick Access Toolbar?
>
Mon Aug 19, 2013 1:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Use the RCHGetYahooQuotes() function.
=RCHGetYahooQuotes("SSYS","a")
On Mon, Aug 19, 2013 at 8:31 AM, john.kalkanis <john.kalkanis@yahoo.com >wrote:
> is there a way to get the ask price for the underlying?
>
=RCHGetYahooQuotes(
On Mon, Aug 19, 2013 at 8:31 AM, john.kalkanis <john.kalkanis@
> is there a way to get the ask price for the underlying?
>
Mon Aug 19, 2013 9:14 am (PDT) . Posted by:
"chrisksjdfsdlfhakljifsd" chrisksjdfsdlfhakljifsd
I am receiving error codes on the IBD stock checkup example as of today. Are other people having an issue with this? Has there been an update to the codes that has made the current ones not work? I had this working on last Monday.
Thanks,
Chris
Thanks,
Chris
Mon Aug 19, 2013 11:49 am (PDT) . Posted by:
"chrisksjdfsdlfhakljifsd" chrisksjdfsdlfhakljifsd
--- In smf_addin@yahoogrou
>
> I am receiving error codes on the IBD stock checkup example as of today. Are other people having an issue with this? Has there been an update to the codes that has made the current ones not work? I had this working on last Monday.
>
> Thanks,
> Chris
>
Please Ignore, i have worked out the issue.
Mon Aug 19, 2013 1:20 pm (PDT) . Posted by:
"Sheldon" sheldon.eden
When using the RCHGetYahooHistory function, is it possible to extract the date information out of another cell? Specifically, I'm doing some data analysis to track price changes over time, and I want to get the Open and Close values of the stock for my date range. I am able to use the formula to reference a cell for the symbol, and I would like to be able to do the same for the date.
My formula so far is like so:
=RCHGetYahooHistory([symbolCell],2013,8,5,2013,8,5,,"OC",0)
In this case, what I would like to do is be able to replace the two Date parameters with a reference to another cell, so that it might wind up like this:
=RCHGetYahooHistory([symbolCell],[startDateCell],[endDateCell],,"OC",0)
My reasoning for this is so that I can use the same worksheet and list of stocks, but I could set a filter on my Date column to adjust my start date.
Is this possible?
My formula so far is like so:
=RCHGetYahooHistory
In this case, what I would like to do is be able to replace the two Date parameters with a reference to another cell, so that it might wind up like this:
=RCHGetYahooHistory
My reasoning for this is so that I can use the same worksheet and list of stocks, but I could set a filter on my Date column to adjust my start date.
Is this possible?
Mon Aug 19, 2013 1:28 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sure. For the most part, you can treat them like any other EXCEL function.
Just do the cell references.
But you can't give it values for just one of beginning and ending
dates...you need to either do none, or both.
On Mon, Aug 19, 2013 at 12:51 PM, Sheldon <sheldon.eden@yahoo.com > wrote:
> When using the RCHGetYahooHistory function, is it possible to extract the
> date information out of another cell? Specifically, I'm doing some data
> analysis to track price changes over time, and I want to get the Open and
> Close values of the stock for my date range. I am able to use the formula
> to reference a cell for the symbol, and I would like to be able to do the
> same for the date.
>
> My formula so far is like so:
>
> =RCHGetYahooHistory([symbolCell],2013,8,5,2013,8,5,,"OC",0)
>
> In this case, what I would like to do is be able to replace the two Date
> parameters with a reference to another cell, so that it might wind up like
> this:
>
> =RCHGetYahooHistory([symbolCell],[startDateCell],[endDateCell],,"OC",0)
>
> My reasoning for this is so that I can use the same worksheet and list of
> stocks, but I could set a filter on my Date column to adjust my start date.
>
> Is this possible?
>
Just do the cell references.
But you can't give it values for just one of beginning and ending
dates...you need to either do none, or both.
On Mon, Aug 19, 2013 at 12:51 PM, Sheldon <sheldon.eden@
> When using the RCHGetYahooHistory function, is it possible to extract the
> date information out of another cell? Specifically, I'm doing some data
> analysis to track price changes over time, and I want to get the Open and
> Close values of the stock for my date range. I am able to use the formula
> to reference a cell for the symbol, and I would like to be able to do the
> same for the date.
>
> My formula so far is like so:
>
> =RCHGetYahooHistory
>
> In this case, what I would like to do is be able to replace the two Date
> parameters with a reference to another cell, so that it might wind up like
> this:
>
> =RCHGetYahooHistory
>
> My reasoning for this is so that I can use the same worksheet and list of
> stocks, but I could set a filter on my Date column to adjust my start date.
>
> Is this possible?
>
Mon Aug 19, 2013 1:34 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Got it all working again.
Turns out the update to my Logitech drivers re-added the Setpoint.exe file to my startup. That will screw up DDE, for anyone else that uses it.
The other big one that I actually had to figure out myself because none of the "experts" on any of the Microsoft support sites would answer it was opening and running Excel as Administrator, turns out that fixes DDE problems.
So now I have both DDE and SMF add-in working together. Life in harmony.
Thanks,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Sunday, August 18, 2013 11:58 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Excel hanging and add-in instructions changing by themselves
I would have thought it would have remained. But if you were installing driver updates and other things, it may have "reset" some things with EXCEL. The Devil is in the details. That might be what happened to your DDE process as well?
As far as keeping smfFixLinks on the toolbar, just create the button and assign the macro to it. In EXCEL 2007, it's called the QAT (Quick Access Toolbar).
On Sun, Aug 18, 2013 at 8:31 PM, Jim Ranum <amt2100@gmail.com > wrote:
Thanks Randy. Yes, I wondered about the add-in still being in the list of active add-in's and it wasn't. I only shut the computer down and reopened it. The add-in should remain installed and active, correct? What made it drop out?
I found your message 11346, talking about the smfFixLinks. Couldn't find it anywhere else. It says you created a macro for it. How would you keep that on your toolbar?
Turns out the update to my Logitech drivers re-added the Setpoint.exe file to my startup. That will screw up DDE, for anyone else that uses it.
The other big one that I actually had to figure out myself because none of the "experts" on any of the Microsoft support sites would answer it was opening and running Excel as Administrator, turns out that fixes DDE problems.
So now I have both DDE and SMF add-in working together. Life in harmony.
Thanks,
Jim
From: smf_addin@yahoogrou
Sent: Sunday, August 18, 2013 11:58 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Excel hanging and add-in instructions changing by themselves
I would have thought it would have remained. But if you were installing driver updates and other things, it may have "reset" some things with EXCEL. The Devil is in the details. That might be what happened to your DDE process as well?
As far as keeping smfFixLinks on the toolbar, just create the button and assign the macro to it. In EXCEL 2007, it's called the QAT (Quick Access Toolbar).
On Sun, Aug 18, 2013 at 8:31 PM, Jim Ranum <amt2100@gmail.
Thanks Randy. Yes, I wondered about the add-in still being in the list of active add-in's and it wasn't. I only shut the computer down and reopened it. The add-in should remain installed and active, correct? What made it drop out?
I found your message 11346, talking about the smfFixLinks. Couldn't find it anywhere else. It says you created a macro for it. How would you keep that on your toolbar?
Tidak ada komentar:
Posting Komentar