Messages In This Digest (15 Messages)

1a.: Re: Automatic Refresh of Stock Prices From: Martin Topper
1b.: Re: Automatic Refresh of Stock Prices From: Michael Thomas
1c.: Re: Automatic Refresh of Stock Prices From: sudhir agarwal
1d.: Re: Automatic Refresh of Stock Prices From: Michael Thomas
1e.: Re: Automatic Refresh of Stock Prices From: sudhir agarwal

2a.: SMF Addin and RCH From: thomas91112
2b.: Re: SMF Addin and RCH From: Randy Harmelink

3a.: smf_addin issue From: nrothfuss@dalpos.com
3b.: Re: smf_addin issue From: Randy Harmelink
3c.: Re: smf_addin issue From: Rothfuss, Neal

4a.: Re: Retrieving Yahoo Option Data From: Bob Farkaly
4b.: Re: Retrieving Yahoo Option Data From: Bob Farkaly
4c.: Re: Retrieving Yahoo Option Data From: Randy Harmelink

5a.: =RCHGetElementNumber(Ticker, 13932) Showing Error From: ps_clemens
5b.: Re: =RCHGetElementNumber(Ticker, 13932) Showing Error From: Randy Harmelink

View All Topics | Create New Topic

Messages

1a.: Re: Automatic Refresh of Stock Prices

Posted by: "Martin Topper" mtopper@yahoo.com mtopper

Wed Mar 21, 2012 11:18 am (PDT)

just curious.........

will you be sitting in front of the computer waiting for the update EVERY TWO MINUTES?

Or will you occasionally glance at your computer during the day and want the prices to be no more than 2 minutes old? (In which case it seems like smfforcerecalc is the way to go)

________________________________
From: thomas91112 <thomas91112@yahoo.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, March 20, 2012 7:53 PM
Subject: [smf_addin] Automatic Refresh of Stock Prices

Have downloaded current stock prices but would now like to have the workbook automatically update the stock prices every 2 minutes throughout the day. Don't want to have to keep hitting ForceRecalc every 2 minutes in order to see how the prices are performing. Is there a VBA routine or some other method that can activate a periodic refresh function for prices?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
1b.: Re: Automatic Refresh of Stock Prices

Posted by: "Michael Thomas" thomas91112@yahoo.com thomas91112

Wed Mar 21, 2012 11:44 am (PDT)

Have a routine that when the my stock indicators hit a certain level, it will automatically email my broker with the name and price so he can make the trade. That is why it needs to be a frequent real-time update.

--- On Wed, 3/21/12, Martin Topper <mtopper@yahoo.com> wrote:

From: Martin Topper <mtopper@yahoo.com>
Subject: Re: [smf_addin] Automatic Refresh of Stock Prices
To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
Date: Wednesday, March 21, 2012, 11:18 AM

just curious.........
will you be sitting in front of the computer waiting for the update EVERY TWO MINUTES?

Or will you occasionally glance at your computer during the day and want the prices to be no more than 2 minutes old? (In which case it seems like smfforcerecalc is the way to go)

From:
thomas91112 <thomas91112@yahoo.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, March 20, 2012 7:53 PM
Subject: [smf_addin] Automatic Refresh of Stock Prices

Have downloaded current stock prices but would now like to have the workbook automatically update the stock prices every 2 minutes throughout the day. Don't want to have to keep hitting ForceRecalc every 2 minutes in order to see how the prices are performing. Is there a VBA routine or some other method that can activate a periodic refresh function for prices?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
1c.: Re: Automatic Refresh of Stock Prices

Posted by: "sudhir agarwal" Agarwal.sudhir@gmail.com sudhir_agarwal1

Wed Mar 21, 2012 12:16 pm (PDT)

If the Excel is Open, it will refresh every 2 mins. So whenever you look at
the quote, it will not be more than 2 mins old.
If you keep glancing, you will see a change in 2 mins.. :) if that is the
refresh frequency set..
Sudhir

On Wed, Mar 21, 2012 at 2:18 PM, Martin Topper <mtopper@yahoo.com> wrote:

> **
>
>
> just curious.........
>
> will you be sitting in front of the computer waiting for the update EVERY
> TWO MINUTES?
>
> Or will you occasionally glance at your computer during the day and want
> the prices to be no more than 2 minutes old? (In which case it seems like
> smfforcerecalc is the way to go)
>
>
>
>
> ------------------------------
> *From:* thomas91112 <thomas91112@yahoo.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Tuesday, March 20, 2012 7:53 PM
> *Subject:* [smf_addin] Automatic Refresh of Stock Prices
>
>
> Have downloaded current stock prices but would now like to have the
> workbook automatically update the stock prices every 2 minutes throughout
> the day. Don't want to have to keep hitting ForceRecalc every 2 minutes in
> order to see how the prices are performing. Is there a VBA routine or some
> other method that can activate a periodic refresh function for prices?
>
>
>
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
1d.: Re: Automatic Refresh of Stock Prices

Posted by: "Michael Thomas" thomas91112@yahoo.com thomas91112

Wed Mar 21, 2012 12:25 pm (PDT)

The download file you kindly provided was for MSN Money which I assume updates every 2 minutes - is that correct?

--- On Wed, 3/21/12, sudhir agarwal <Agarwal.sudhir@gmail.com> wrote:

From: sudhir agarwal <Agarwal.sudhir@gmail.com>
Subject: Re: [smf_addin] Automatic Refresh of Stock Prices
To: smf_addin@yahoogroups.com
Date: Wednesday, March 21, 2012, 12:16 PM

If the Excel is Open, it will refresh every 2 mins. So whenever you look at the quote, it will not be more than 2 mins old.
If you keep glancing, you will see a change in 2 mins.. :) if that is the refresh frequency set..
Sudhir

On Wed, Mar 21, 2012 at 2:18 PM, Martin Topper <mtopper@yahoo.com> wrote:

just curious.........

will you be sitting in front of the computer waiting for the update EVERY TWO MINUTES?

Or will you occasionally glance at your computer during the day and want the prices to be no more than 2 minutes old? (In which case it seems like smfforcerecalc is the way to go)

From: thomas91112 <thomas91112@yahoo.com>
To: smf_addin@yahoogroups.com

Sent: Tuesday, March 20, 2012 7:53 PM
Subject: [smf_addin] Automatic Refresh of Stock Prices

Have downloaded current stock prices but would now like to have the workbook automatically update the stock prices every 2 minutes throughout the day. Don't want to have to keep hitting ForceRecalc every 2 minutes in order to see how the prices are performing. Is there a VBA routine or some other method that can activate a periodic refresh function for prices?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
1e.: Re: Automatic Refresh of Stock Prices

Posted by: "sudhir agarwal" Agarwal.sudhir@gmail.com sudhir_agarwal1

Wed Mar 21, 2012 4:33 pm (PDT)

You can right click on the result selection and then right Click and select
"Data Range Properties" and set the refresh rates/time.
To make the selection, you will have to do the cell selection on the Top
Left (next to Fx button).

Sudhir

On Wed, Mar 21, 2012 at 3:25 PM, Michael Thomas <thomas91112@yahoo.com>wrote:

> **
>
>
> The download file you kindly provided was for MSN Money which I assume
> updates every 2 minutes - is that correct?
>
>
> --- On *Wed, 3/21/12, sudhir agarwal <Agarwal.sudhir@gmail.com>* wrote:
>
>
> From: sudhir agarwal <Agarwal.sudhir@gmail.com>
> Subject: Re: [smf_addin] Automatic Refresh of Stock Prices
> To: smf_addin@yahoogroups.com
> Date: Wednesday, March 21, 2012, 12:16 PM
>
>
>
>
> If the Excel is Open, it will refresh every 2 mins. So whenever you look
> at the quote, it will not be more than 2 mins old.
> If you keep glancing, you will see a change in 2 mins.. :) if that is the
> refresh frequency set..
> Sudhir
>
> On Wed, Mar 21, 2012 at 2:18 PM, Martin Topper <mtopper@yahoo.com<http://mc/compose?to=mtopper@yahoo.com>
> > wrote:
>
> **
>
>
> just curious.........
>
> will you be sitting in front of the computer waiting for the update EVERY
> TWO MINUTES?
>
> Or will you occasionally glance at your computer during the day and want
> the prices to be no more than 2 minutes old? (In which case it seems like
> smfforcerecalc is the way to go)
>
>
>
>
> ------------------------------
> *From:* thomas91112 <thomas91112@yahoo.com<http://mc/compose?to=thomas91112@yahoo.com>
> >
> *To:* smf_addin@yahoogroups.com<http://mc/compose?to=smf_addin@yahoogroups.com>
> *Sent:* Tuesday, March 20, 2012 7:53 PM
> *Subject:* [smf_addin] Automatic Refresh of Stock Prices
>
>
> Have downloaded current stock prices but would now like to have the
> workbook automatically update the stock prices every 2 minutes throughout
> the day. Don't want to have to keep hitting ForceRecalc every 2 minutes in
> order to see how the prices are performing. Is there a VBA routine or some
> other method that can activate a periodic refresh function for prices?
>
>
>
>
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)

2a.: SMF Addin and RCH

Posted by: "thomas91112" thomas91112@yahoo.com thomas91112

Wed Mar 21, 2012 12:50 pm (PDT)

If I subscribe to streaming real time stock price data from Yahoo Finance, will RCHGetYahooHistory and RCHGetYahooQuotes, still work and automatically update and reflect the real time values?

Thanks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.: Re: SMF Addin and RCH

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Mar 21, 2012 1:39 pm (PDT)

Nothing "automatically" updates.

But I believe RCHGetYahooQuotes() will get real-time quotes, as long as
you've created the proper IE security cookie by logging in with either the
EXCEL Web Query process, or with IE itself. But you shouldn't see any
difference on RCHGetYahooHistory().

On Wed, Mar 21, 2012 at 12:50 PM, thomas91112 <thomas91112@yahoo.com> wrote:

> If I subscribe to streaming real time stock price data from Yahoo Finance,
> will RCHGetYahooHistory and RCHGetYahooQuotes, still work and automatically
> update and reflect the real time values?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

3a.: smf_addin issue

Posted by: "nrothfuss@dalpos.com" nrothfuss@dalpos.com nrothfuss

Wed Mar 21, 2012 1:45 pm (PDT)

I have ibstalled the latest add-in in the correct directory and have the add-in checked in the Excel options add-in box, however the add-in does not show on the ribbon add-in tab, My other add-in's do show up. Shouldn't the smf_Addn be there??
Tks Neal

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3b.: Re: smf_addin issue

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Mar 21, 2012 1:48 pm (PDT)

Nope. Nothing concerning the SMF add-in should show up on the ribbon --
it's mostly user-defined functions.

As long as it shows up on the add-in manager, you should be OK. The
quickest way to check if you have it installed is to check the version:

=RCHGetElementNumber("Version")

On Wed, Mar 21, 2012 at 1:42 PM, <nrothfuss@dalpos.com> wrote:

> I have ibstalled the latest add-in in the correct directory and have the
> add-in checked in the Excel options add-in box, however the add-in does not
> show on the ribbon add-in tab, My other add-in's do show up. Shouldn't the
> smf_Addn be there??
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3c.: Re: smf_addin issue

Posted by: "Rothfuss, Neal" nrothfuss@dalpos.com nrothfuss

Wed Mar 21, 2012 2:16 pm (PDT)

Thank you, it is returning

Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program Files\SMF Add-In; 1)

Neal Rothfuss

DALPOS Architects and Integrators

Syracuse, NY

315.460.5760

nrothfuss@dalpos.com<mailto:nrothfuss@dalpos.com>

________________________________
From: smf_addin@yahoogroups.com [smf_addin@yahoogroups.com] on behalf of Randy Harmelink [rharmelink@gmail.com]
Sent: Wednesday, March 21, 2012 4:48 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] smf_addin issue

Nope. Nothing concerning the SMF add-in should show up on the ribbon -- it's mostly user-defined functions.

As long as it shows up on the add-in manager, you should be OK. The quickest way to check if you have it installed is to check the version:

=RCHGetElementNumber("Version")

On Wed, Mar 21, 2012 at 1:42 PM, <nrothfuss@dalpos.com<mailto:nrothfuss@dalpos.com>> wrote:
I have ibstalled the latest add-in in the correct directory and have the add-in checked in the Excel options add-in box, however the add-in does not show on the ribbon add-in tab, My other add-in's do show up. Shouldn't the smf_Addn be there??

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

4a.: Re: Retrieving Yahoo Option Data

Posted by: "Bob Farkaly" rfarkaly@san.rr.com rfarkaly

Wed Mar 21, 2012 4:13 pm (PDT)

Randy,

Thank you for your response and assistance. Appears I made a syntax error.

Bob

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: 20 March, 2012 7:09 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Retrieving Yahoo Option Data

Why not just use the smfGetOptionQuotes() function?

In any case, this would get your desired bid price:

=RCHGetTableCell("http://finance.yahoo.com/q?s=AGQ120421C00054000",1,">Bid")

This would retrieve the same price:

=smfGetOptionQuotes("AGQ Apr 2012 54.000 Call","b")

On Tue, Mar 20, 2012 at 4:50 PM, Bob Farkaly <rfarkaly@san.rr.com> wrote:

I have developed a little routine that generates/synthesizes option ticker
symbols based on criteria I set. For example, AGQ120421C00054000 is the
generated ticker symbol for the AGQ Apr 2012 54.000 Call option. What I'd
like to do, but can't figure out how to, is automate the retrieval of the
"Bid: $xxx" field from that Yahoo Finance option page. I've done a lot of
trial and error (all error, so far). ;-)

Can someone lend me a hand?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
4b.: Re: Retrieving Yahoo Option Data

Posted by: "Bob Farkaly" rfarkaly@san.rr.com rfarkaly

Wed Mar 21, 2012 5:34 pm (PDT)

Randy,

Sorry for the bandwidth. I thought I had this nailed because your examples worked and I was able to take advantage of several of the documented parameters. But now I am having the problem that plagued me earlier and was part of the reason for my post. When I use the "=RCH" functions, they work as expected. Using the "=smf" functions, the only response I get is "#NAME". I didn't do anything between my two sessions on Excel today, so I am at a loss to understand what is happening. Have you seen this behavior before?

Thanks,

Bob

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: 20 March, 2012 7:09 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Retrieving Yahoo Option Data

Why not just use the smfGetOptionQuotes() function?

In any case, this would get your desired bid price:

=RCHGetTableCell("http://finance.yahoo.com/q?s=AGQ120421C00054000",1,">Bid")

This would retrieve the same price:

=smfGetOptionQuotes("AGQ Apr 2012 54.000 Call","b")

On Tue, Mar 20, 2012 at 4:50 PM, Bob Farkaly <rfarkaly@san.rr.com> wrote:

I have developed a little routine that generates/synthesizes option ticker
symbols based on criteria I set. For example, AGQ120421C00054000 is the
generated ticker symbol for the AGQ Apr 2012 54.000 Call option. What I'd
like to do, but can't figure out how to, is automate the retrieval of the
"Bid: $xxx" field from that Yahoo Finance option page. I've done a lot of
trial and error (all error, so far). ;-)

Can someone lend me a hand?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
4c.: Re: Retrieving Yahoo Option Data

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Mar 21, 2012 6:22 pm (PDT)

Other than the mention of the two sessions, I would have thought it was
that you're using an older version of the add-in. What do you get with:

=RCHGetElementNumber("Version")

On Wed, Mar 21, 2012 at 5:34 PM, Bob Farkaly <rfarkaly@san.rr.com> wrote:

> Sorry for the bandwidth. I thought I had this nailed because your
> examples worked and I was able to take advantage of several of the
> documented parameters. But now I am having the problem that plagued me
> earlier and was part of the reason for my post. When I use the "=RCH"
> functions, they work as expected. Using the "=smf" functions, the only
> response I get is "#NAME". I didn't do anything between my two sessions on
> Excel today, so I am at a loss to understand what is happening. Have you
> seen this behavior before?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

5a.: =RCHGetElementNumber(Ticker, 13932) Showing Error

Posted by: "ps_clemens" r.sethi@rogers.com ps_clemens

Wed Mar 21, 2012 6:23 pm (PDT)

The following is giving Error value:
=RCHGetElementNumber(Ticker, 13931)
=RCHGetElementNumber(Ticker, 13932)
=RCHGetElementNumber($A3, 13941)
=RCHGetElementNumber($A3, 13942)

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5b.: Re: =RCHGetElementNumber(Ticker, 13932) Showing Error

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Mar 21, 2012 6:30 pm (PDT)

Those elements were obsoleted earlier this year, because of web page
changes by MorningStar.

On Wed, Mar 21, 2012 at 6:22 PM, ps_clemens <r.sethi@rogers.com> wrote:

> The following is giving Error value:
> =RCHGetElementNumber(Ticker, 13931)
> =RCHGetElementNumber(Ticker, 13932)
> =RCHGetElementNumber($A3, 13941)
> =RCHGetElementNumber($A3, 13942)
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

Kamis, 22 Maret 2012

Messages In This Digest (15 Messages)

Messages

Posted by: "Martin Topper" mtopper@yahoo.com mtopper

Wed Mar 21, 2012 11:18 am (PDT)

Posted by: "Michael Thomas" thomas91112@yahoo.com thomas91112

Wed Mar 21, 2012 11:44 am (PDT)

Posted by: "sudhir agarwal" Agarwal.sudhir@gmail.com sudhir_agarwal1

Wed Mar 21, 2012 12:16 pm (PDT)

Posted by: "Michael Thomas" thomas91112@yahoo.com thomas91112

Wed Mar 21, 2012 12:25 pm (PDT)

Posted by: "sudhir agarwal" Agarwal.sudhir@gmail.com sudhir_agarwal1

Wed Mar 21, 2012 4:33 pm (PDT)

Posted by: "thomas91112" thomas91112@yahoo.com thomas91112

Wed Mar 21, 2012 12:50 pm (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Mar 21, 2012 1:39 pm (PDT)

Posted by: "nrothfuss@dalpos.com" nrothfuss@dalpos.com nrothfuss

Wed Mar 21, 2012 1:45 pm (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Mar 21, 2012 1:48 pm (PDT)

Posted by: "Rothfuss, Neal" nrothfuss@dalpos.com nrothfuss

Wed Mar 21, 2012 2:16 pm (PDT)

Posted by: "Bob Farkaly" rfarkaly@san.rr.com rfarkaly

Wed Mar 21, 2012 4:13 pm (PDT)

Posted by: "Bob Farkaly" rfarkaly@san.rr.com rfarkaly

Wed Mar 21, 2012 5:34 pm (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Mar 21, 2012 6:22 pm (PDT)

Posted by: "ps_clemens" r.sethi@rogers.com ps_clemens

Wed Mar 21, 2012 6:23 pm (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Mar 21, 2012 6:30 pm (PDT)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me