Rabu, 25 Januari 2012

[smf_addin] Digest Number 2088

Messages In This Digest (13 Messages)

Messages

1a.

Is Yahoo Volume split-adjusted?

Posted by: "pharnsbe" harnsberger@gmail.com   pharnsbe

Tue Jan 24, 2012 11:46 am (PST)



Does anyone happen to know if Yahoo stock volume is split-adjusted?

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

Re: Is Yahoo Volume split-adjusted?

Posted by: "Ian" mighty_superg@yahoo.com   mighty_superg

Tue Jan 24, 2012 5:19 pm (PST)



Yes. The adjusted close price takes dividends and stock splits in to account.

--- In smf_addin@yahoogroups.com, "pharnsbe" <harnsberger@...> wrote:
>
> Does anyone happen to know if Yahoo stock volume is split-adjusted?
>

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

Re: Auto Refresh

Posted by: "george" panax@fuse.net   simon_of_iernot

Tue Jan 24, 2012 12:18 pm (PST)



If one subscribes to Yahoo real-time quotes he could just load a string of stock symbols into the yahoo screen and get the quotes with each quote on a separate line -- it is easy to customize the yahoo screen and get the information you want...last trade, bid, ask, bid size, ask size, volume, high, low for the day and it continually updates. The SMF add-in is great and one can make great use of it, but for some things, a customized yahoo screen works well too.

simon.
----- Original Message -----
From: Randy H
To: smf_addin@yahoogroups.com
Sent: Monday, January 23, 2012 18:09
Subject: [smf_addin] Re: Auto Refresh

You would need to write your own VBA routine to do that.

--- In smf_addin@yahoogroups.com, Bob Authur <bobauthur@...> wrote:
>
> New here. Read through many messages about "refresh" and didn't
> find one that addresses an auto refresh. Can I somehow have my
> spreadsheet automatically refresh on some cycle -- like every
> minute? I'm using the RCHGetYahooQuotes function with NOW().
>
> I'd like to use this to monitor trade candidates during the day
> -- as they approach buy and sell prices.

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

Re: Auto Refresh

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

Tue Jan 24, 2012 12:59 pm (PST)



Good point. It's easy to get into the habit of treating everything like a
nail when you have a hammer...

But he could also be doing some type of analysis or other data retrieval on
the symbols that isn't available in the portfolio view.

I do tend to use the portfolio views rather than a workbook when I want
just a quick glance at something.

I also find the candleglance option over at StockCharts handy for looking
at a number of charts at one time.

On Tue, Jan 24, 2012 at 1:18 PM, george <panax@fuse.net> wrote:

> **
>
> If one subscribes to Yahoo real-time quotes he could just load a string of
> stock symbols into the yahoo screen and get the quotes with each quote on a
> separate line -- it is easy to customize the yahoo screen and get the
> information you want...last trade, bid, ask, bid size, ask size, volume,
> high, low for the day and it continually updates. The SMF add-in is great
> and one can make great use of it, but for some things, a customized yahoo
> screen works well too.
>
> simon.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3a.

SMF-Template-SMFTech-Beta.xls

Posted by: "draz2121" bolony21@gmail.com   draz2121

Tue Jan 24, 2012 5:20 pm (PST)



Hi,

First of all - thank you for the great deal of effort you have put into creating a very useful Excel add-in.

I have heavily modified the above to suit my needs but have run into a couple of issues when trying to create a summary page.

1. I created 10 excel files (1 for each of 10 share tickers) yesterday (24/01/12). This loaded all historic data for the past 2-3 months up until 23/01/12 which was great. However, even now (00:36 on 25/01/12), the data has not refreshed to include yesterday's data?

How can I make this happen as it's imperitive that I get yesterday's data into my sheet before trading opens today.

2. Can you help me with modifying the sheet in such a way:

Colum A contains the ticker
The rest of the columns contain the data as is but just the most recent day's data.

This way you could easily create a summary page displaying TA from the previous day for as many tickers as you wish - easily modifiable then to highlight prominent buy signals.

Thank you for any help.

Shaun

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

Re: SMF-Template-SMFTech-Beta.xls

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

Tue Jan 24, 2012 5:53 pm (PST)



For (1), how are you attempting to refresh the data? I would be using
smfForceRecalculation (see "Links" area of group for info). But it won't
get you updated data unless Yahoo historical quotes have been updated.

For (2), I don't understand what you're asking. Why wouldn't you just
pull the data you need from the 10 EXCEL files?

On Tue, Jan 24, 2012 at 5:39 PM, draz2121 <bolony21@...> wrote:

I have heavily modified the above to suit my needs but have run into a
couple of issues when trying to create a summary page.

1. I created 10 excel files (1 for each of 10 share tickers) yesterday
(24/01/12). This loaded all historic data for the past 2-3 months up
until 23/01/12 which was great. However, even now (00:36 on 25/01/12),
the data has not refreshed to include yesterday's data?

How can I make this happen as it's imperitive that I get yesterday's
data into my sheet before trading opens today.

2. Can you help me with modifying the sheet in such a way:

Colum A contains the ticker
The rest of the columns contain the data as is but just the most recent
day's data.

This way you could easily create a summary page displaying TA from the
previous day for as many tickers as you wish - easily modifiable then to
highlight prominent buy signals.

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

Re: SMF-Template-SMFTech-Beta.xls

Posted by: "draz2121" bolony21@gmail.com   draz2121

Wed Jan 25, 2012 1:31 am (PST)



1. I was simply re-opening the file thinking this would bring through the most up to date EOD info from Yahoo?

It seems that this has updated this morning so the EOD data from Yahoo must not be available until the early morning which is a bit of a shame.

2. This 10 will grow to approx 60 and this would mean an update every day of 60 excel files.

If you open up this file you will see that all data relates to B4 ticker code.

Is it possible to simply move that reference to A7 and have row 7 be the data for that ticker for the most recent day only.

Then A8 can be another ticker etc etc to build a list as large as you like which displays the info from just the previous day.

It would be useful to me if this can be done.

I have built something like it using =RCHGetYahooQuotes(A3:A101,B2:M2) in another sheet but in this sheet I cannot figure out how to grab the RSI, CCI, MACD and other tech info which this sheet uses?

Either solution will be fine :)

Thanks.

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> For (1), how are you attempting to refresh the data? I would be using
> smfForceRecalculation (see "Links" area of group for info). But it won't
> get you updated data unless Yahoo historical quotes have been updated.
>
> For (2), I don't understand what you're asking. Why wouldn't you just
> pull the data you need from the 10 EXCEL files?
>

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

Re: SMF-Template-SMFTech-Beta.xls

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

Wed Jan 25, 2012 1:42 am (PST)



On Wed, Jan 25, 2012 at 2:31 AM, draz2121 <bolony21@...> wrote:
1. I was simply re-opening the file thinking this would bring through
the most up to date EOD info from Yahoo?

It seems that this has updated this morning so the EOD data from Yahoo
must not be available until the early morning which is a bit of a shame.

Closing and re-opening the file wouldn't do it. Exiting and restarting
EXCEL would. As far as I know, the EOD data is usually updated by 6 pm
EST...but I haven't checked in a while.

2. This 10 will grow to approx 60 and this would mean an update every
day of 60 excel files.

If you open up this file you will see that all data relates to B4 ticker
code.

Is it possible to simply move that reference to A7 and have row 7 be the
data for that ticker for the most recent day only.

Then A8 can be another ticker etc etc to build a list as large as you
like which displays the info from just the previous day.

It would be useful to me if this can be done.

I have no idea what you're referring to here...

I have built something like it using =RCHGetYahooQuotes(A3:A101,B2:M2)
in another sheet but in this sheet I cannot figure out how to grab the
RSI, CCI, MACD and other tech info which this sheet uses?

Simply append the data to the end of the historical quotes and extend
the technical functions. But then you do have to worry about whether the
data has been updated for the day or not...

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

is it possible to get etf data for the =RCHGetElementNumber formula?

Posted by: "Mike" fs26mdm@yahoo.com   fs26mdm

Tue Jan 24, 2012 5:56 pm (PST)



I am able to pull info for stocks but not etfs. Anyone know what to do for this?

Thanks.

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

Re: is it possible to get etf data for the =RCHGetElementNumber form

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

Tue Jan 24, 2012 6:09 pm (PST)



It all depends on the element.

The function can pull data for ETFs, but only those element numbers that
are actually pulling elements from ETF-relevant web pages. Some element
numbers work only for stocks, some only for mutual funds, and some only
for ETFs. It's a matter of how the data source has designed their web
pages, whether they have specific web pages for each, or whether a
single web page address (less the ticker symbol) displays data for any
type of equity.

Depending on what you're looking for, you may need to use one of the
other add-in functions. For example, RCHGetTableCell(). In most cases,
the RCHGetElementNumber() function is just a saved version of an
RCHGetTableCell() function.

On Tue, Jan 24, 2012 at 6:56 PM, Mike <fs26mdm@yahoo.com> wrote:
I am able to pull info for stocks but not etfs. Anyone know what to do
for this?

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

Investegate-Data-Collector.xls

Posted by: "draz2121" bolony21@gmail.com   draz2121

Wed Jan 25, 2012 1:44 am (PST)



Hi,

I am using 3 simple words in the yellow column (SOUND, EDENVILLE, ARIAN) but when I press ctrl+shift+J I just get this error and it takes me to the vba debugger:

Compile Error:

Can't assign to array

Any ideas? Does this work for everyone else?

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

Re: Investegate-Data-Collector.xls

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

Wed Jan 25, 2012 2:06 am (PST)



Looks like that example no longer works. Not only does it not compile
under EXCEL 2007, but the web page structure is no longer like it used
to be.

Getting it to compile was easy. I just had to add an:

Dim aData is Variant

...to define the variable.

On Wed, Jan 25, 2012 at 2:44 AM, draz2121 <bolony21@...> wrote:

I am using 3 simple words in the yellow column (SOUND, EDENVILLE, ARIAN)
but when I press ctrl+shift+J I just get this error and it takes me to
the vba debugger:

Compile Error:

Can't assign to array

Any ideas? Does this work for everyone else?

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

Re: Investegate-Data-Collector.xls

Posted by: "draz2121" bolony21@gmail.com   draz2121

Wed Jan 25, 2012 2:13 am (PST)



Ah I see, thank you.

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> Looks like that example no longer works. Not only does it not compile
> under EXCEL 2007, but the web page structure is no longer like it used
> to be.
>
> Getting it to compile was easy. I just had to add an:
>
> Dim aData is Variant
>
> ...to define the variable.
>
> On Wed, Jan 25, 2012 at 2:44 AM, draz2121 <bolony21@> wrote:
>
> I am using 3 simple words in the yellow column (SOUND, EDENVILLE, ARIAN)
> but when I press ctrl+shift+J I just get this error and it takes me to
> the vba debugger:
>
> Compile Error:
>
> Can't assign to array
>
> Any ideas? Does this work for everyone else?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need traffic?

Drive customers

With search ads

on Yahoo!

Yahoo! News

Fashion News

What's the word on

fashion and style?

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 02.48

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)