Messages In This Digest (5 Messages)
- 1a.
- Change AdvFN URL from "www" to "uk" From: paul84j
- 1b.
- Re: Change AdvFN URL from "www" to "uk" From: Randy Harmelink
- 2a.
- Re: Is yahoo VOLUME split-adjusted? From: Mike McQuaid
- 3a.
- Reuters Key Develoment.xls Template From: deng3
- 3b.
- Re: Reuters Key Develoment.xls Template From: Randy Harmelink
Messages
- 1a.
-
Change AdvFN URL from "www" to "uk"
Posted by: "paul84j" paul84j@yahoo.ie paul84j
Sat Feb 4, 2012 6:53 am (PST)
Hi Randy,
I had a problem accessing AdvFN which was overcome by changing the constant
Const kAdvFNPrefix = "www" to Const kAdvFNPrefix = "uk"
but I can't save this change in the add-in so end up having to make the change everytime I open Excel. Is the add-in password protected?
Paul.
- 1b.
-
Re: Change AdvFN URL from "www" to "uk"
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Feb 4, 2012 7:34 am (PST)
No, it's not password protected. The problem of not being able to save
changes is why I ended up moving my copy of the add-in to "C:\SMF Add-in"
instead under the "Program Files" folder. Microsoft changed security in
Vista so that edits like that can no longer be saved into the "Program
Files" folder without special permissions.
I've been trying to figure out if there is a more automatic way of setting
or maintaining that constant. What I'm thinking right now is to have the
add-in look for a file like "AdvFN-prefix.txt". If the file doesn't exist,
the add-in will use "www", otherwise you could create the text file and
just put "uk" in it, and it would use that. That way, if the add-in gets
updated, that file doesn't get replaced and your settings are maintained
from version to version.
On Sat, Feb 4, 2012 at 7:53 AM, paul84j <paul84j@yahoo.ie > wrote:
>
> I had a problem accessing AdvFN which was overcome by changing the constant
>
> Const kAdvFNPrefix = "www" to Const kAdvFNPrefix = "uk"
>
> but I can't save this change in the add-in so end up having to make the
> change everytime I open Excel. Is the add-in password protected?
>
- 2a.
-
Re: Is yahoo VOLUME split-adjusted?
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Sat Feb 4, 2012 9:59 am (PST)
Thanks pharnsbe. I agree with your findings and can add a small bit.
The volume is adjusted for splits, as you say (including the day-before
error) and is *not* adjusted for dividends. I think that's correct but it
does lead to an issue.
Yahoo's historical record for volume *units* is correct but you cannot
correctly calculate a historical *dollar* volume for any stocks that issue
dividends. The reason is simply that Yahoo's Adj Close price includes both
splits and dividend adjustments and its "raw close" doesn't adjust for any
activities. The longer the time period and the larger the dividend the more
distorted the dollar volume calculation would be.
I determined the volume was not dividend-adjusted by doing a screen capture
of Yahoo data for SO in late January and looked at its data after its
dividend on Feb 2. Sure enough, the Adj Close price was adjusted for this
distribution but the volume figures were not.
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of pharnsbe
Sent: Monday, January 30, 2012 8:16 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Is yahoo VOLUME split-adjusted?
Thanks everyone for the thoughtful responses.
I've done some more research and it appears that yahoo volume IS indeed
adjusted for splits. For example, I'm going to upload to the files area a
worksheet titled "Yahoo Volume Is Split Adjusted.xls".
I looked at a few symbols that split in December 2011
(http://quotes.ino.com/analysis ) and compared yahoo data to/splits/
quotes-plus adjusted, and quotes-plus "raw" (unadjusted).
That worksheet uses ROST as an example, but I checked the volume data on a
number of symbols and found the same result, which is yahoo volume matches
the quotes-plus adjusted volume, and does not match the quotes-plus raw
volume. Curiously, I also noticed that yahoo volume tended to be 2x the QP
value on the day prior to the split... as if yahoo accidentally multiplied
by 4 instead of 2 on that one day. I found this "error" on a number of
symbols, just on the day before the split. It could also be the case that
yahoo was correct on that day and QP was wrong, but given the abnormally
high volume reading it seemed more likely yahoo was in error.
Update: check a few more data sources... seems QP was correct, yahoo volume
reading for the day before the split is wrong.
- 3a.
-
Reuters Key Develoment.xls Template
Posted by: "deng3" diengelke@live.com dieterengelke
Sat Feb 4, 2012 11:03 am (PST)
Hi Randy,
This template does not work anymore. Excel tells me, that the Get-Data.xla cannot be found.
Is there a change with the new stockmarketfunctions.xla?
regards
Dieter
- 3b.
-
Re: Reuters Key Develoment.xls Template
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Feb 4, 2012 2:06 pm (PST)
I have no idea what Get-Data.xla is. I don't get such a message when I try
the file.
However, you are correct the file no longer works. I just uploaded a new
copy that worked for a few ticker symbols I tried. But I was keying off of
anchor links, and I recall they don't exist on some of the entries...?
On Sat, Feb 4, 2012 at 12:03 PM, deng3 <diengelke@live.com > wrote:
>
> This template does not work anymore. Excel tells me, that the Get-Data.xla
> cannot be found.
>
> Is there a change with the new stockmarketfunctions.xla?
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
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
Tidak ada komentar:
Posting Komentar