Messages In This Digest (25 Messages)
- 1a.
- Re: RCHGetTableCell works great except for a few symbols, weird From: Lal Echterhoff
- 1b.
- Re: RCHGetTableCell works great except for a few symbols, weird From: Randy H
- 1c.
- Re: RCHGetTableCell works great except for a few symbols, weird From: Lal Echterhoff
- 1d.
- Re: RCHGetTableCell works great except for a few symbols, weird From: Lal Echterhoff
- 1e.
- Re: RCHGetTableCell works great except for a few symbols, weird From: Randy H
- 1f.
- Re: RCHGetTableCell works great except for a few symbols, weird From: Randy H
- 1g.
- Re: RCHGetTableCell works great except for a few symbols, weird From: Lal Echterhoff
- 1h.
- Re: RCHGetTableCell works great except for a few symbols, weird From: Lal Echterhoff
- 1i.
- Re: RCHGetTableCell works great except for a few symbols, weird From: Randy Harmelink
- 2a.
- fundamentally promising From: leif_85
- 2b.
- Re: fundamentally promising From: Randy Harmelink
- 3a.
- RCHGetWebData-Template-BarChart-Quotes-Extract.xls From: draz2121
- 3b.
- Re: RCHGetWebData-Template-BarChart-Quotes-Extract.xls From: Randy H
- 3c.
- Re: RCHGetWebData-Template-BarChart-Quotes-Extract.xls From: draz2121
- 3d.
- Re: RCHGetWebData-Template-BarChart-Quotes-Extract.xls From: draz2121
- 3e.
- Re: RCHGetWebData-Template-BarChart-Quotes-Extract.xls From: Randy H
- 3f.
- Re: RCHGetWebData-Template-BarChart-Quotes-Extract.xls From: Shaun
- 3g.
- Re: RCHGetWebData-Template-BarChart-Quotes-Extract.xls From: Shaun
- 3h.
- Re: RCHGetWebData-Template-BarChart-Quotes-Extract.xls From: Randy H
- 4.
- Creating element definitions From: Randy H
- 5a.
- Re: Is yahoo VOLUME split-adjusted? From: pharnsbe
- 5b.
- Re: Is yahoo VOLUME split-adjusted? From: investor952
- 5c.
- Re: Is yahoo VOLUME split-adjusted? From: Randy Harmelink
- 6.1.
- New file uploaded to smf_addin From: smf_addin@yahoogroups.com
- 7a.
- Re: New official release of the add-in -- version 2.1.2012.01.30 From: Vivek Dabholkar
Messages
- 1a.
-
Re: RCHGetTableCell works great except for a few symbols, weird
Posted by: "Lal Echterhoff" bigzippy@bellsouth.net bigzippy@bellsouth.net
Mon Jan 30, 2012 1:29 pm (PST)
Yes I just noticed that those are 1 and 2 letter stock symbols and the ones that work are 3,4,and 5. So looks like the cut off is 3 to make it unique enough. Any ideas? might use the name of company? but the description will differ most probably, so seems like i would need a complicated like or fuzzy match process.
Thanks
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> Each isn't working as desired because your third search string, the
> ticker symbol, isn't unique enough to be used as a search string.
>
> -- "TD" could be the next table cell definition it finds
> -- "T" can be almost anywhere
> -- "CL" could be the next "CLASS=" HTML clause
>
> On Mon, Jan 30, 2012 at 2:08 PM, Lal Echterhoff <bigzippy@...
> <mailto:bigzippy@...> > wrote:
>
> I have attached the html and excel file im working with the code in L1
> is needed each day to login so i hope you can see, but in sheet1
> symbol/row TD/r27,T/r29,CL/r31 my formulas do not pull in the correct
> data for some reason all others work fine. I cant figure out what is
> wrong please help! Lal
>
- 1b.
-
Re: RCHGetTableCell works great except for a few symbols, weird
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Mon Jan 30, 2012 1:40 pm (PST)
Depending on the how source code on the web page is coded, something
like any of these:
">" & Ticker
">" & Ticker & "<"
Ticker & "<"
...might do the trick. It's highly unlikely an HTML-related string would
be following the ending specification (i.e. ">") or preceding the
starting specification (i.e. "<") of an HTML tag. But the web page may
not have the ">" or "<" abutted up next to the ticker symbol either. As
I said, it depends on how they code the web page.
On Mon, Jan 30, 2012 at 2:29 PM, Lal Echterhoff <bigzippy@bellsouth.net >
wrote:
Yes I just noticed that those are 1 and 2 letter stock symbols and the
ones that work are 3,4,and 5. So looks like the cut off is 3 to make it
unique enough. Any ideas? might use the name of company? but the
description will differ most probably, so seems like i would need a
complicated like or fuzzy match process.
- 1c.
-
Re: RCHGetTableCell works great except for a few symbols, weird
Posted by: "Lal Echterhoff" bigzippy@bellsouth.net bigzippy@bellsouth.net
Mon Jan 30, 2012 1:59 pm (PST)
<A
HREF="javascript:Jwin('http://64.206. 241.152/cgi- \\53226452.tic&bin/foxweb. exe/fwchart? \
sessionfile=EDDC1G2578518. A&symbol= fxd&overtick= TICKPATH c\
ountry=&selectedport=PM+TLS& navkey=logo' ,0,0,'',' fwport_win' )">FXD</A> </\
TD> <TD>First Trust Consumer Discretionary AlphaDEX® Fund</TD>
The lines look that that so the FXD wouls be the symbol-I am not getting
what to do i enter the actual Ticker? plus the concencate? or the symbol
is TD for one i cansee where the problem lies since TD is all over the
code LOL.Thanks
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> Depending on the how source code on the web page is coded, something
> like any of these:
>
> ">" & Ticker
> ">" & Ticker & "<"
> Ticker & "<"
>
> ...might do the trick. It's highly unlikely an HTML-related string
would
> be following the ending specification (i.e. ">") or preceding the
> starting specification (i.e. "<") of an HTML tag. But the web page may
> not have the ">" or "<" abutted up next to the ticker symbol either.
As
> I said, it depends on how they code the web page.
>
> On Mon, Jan 30, 2012 at 2:29 PM, Lal Echterhoff bigzippy@...
> wrote:
> Yes I just noticed that those are 1 and 2 letter stock symbols and
the
> ones that work are 3,4,and 5. So looks like the cut off is 3 to make
it
> unique enough. Any ideas? might use the name of company? but the
> description will differ most probably, so seems like i would need a
> complicated like or fuzzy match process.
>
- 1d.
-
Re: RCHGetTableCell works great except for a few symbols, weird
Posted by: "Lal Echterhoff" bigzippy@bellsouth.net bigzippy@bellsouth.net
Mon Jan 30, 2012 2:04 pm (PST)
,">T<",,2) i get error or if i use > on either side
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> Depending on the how source code on the web page is coded, something
> like any of these:
>
> ">" & Ticker
> ">" & Ticker & "<"
> Ticker & "<"
>
> ...might do the trick. It's highly unlikely an HTML-related string would
> be following the ending specification (i.e. ">") or preceding the
> starting specification (i.e. "<") of an HTML tag. But the web page may
> not have the ">" or "<" abutted up next to the ticker symbol either. As
> I said, it depends on how they code the web page.
>
> On Mon, Jan 30, 2012 at 2:29 PM, Lal Echterhoff <bigzippy@...>
> wrote:
> Yes I just noticed that those are 1 and 2 letter stock symbols and the
> ones that work are 3,4,and 5. So looks like the cut off is 3 to make it
> unique enough. Any ideas? might use the name of company? but the
> description will differ most probably, so seems like i would need a
> complicated like or fuzzy match process.
>
- 1e.
-
Re: RCHGetTableCell works great except for a few symbols, weird
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Mon Jan 30, 2012 2:05 pm (PST)
If the ticker FXD were in cell C4, you could this as the search string:
">" & C4
...which would end up giving you:
>FXD
You could also key off that link that precedes it, and do something
like:
"symbol=" & C4
See yellow highlighted items below.
On Mon, Jan 30, 2012 at 2:59 PM, Lal Echterhoff <bigzippy@bellsouth.net >
wrote:
<A
HREF="javascript:Jwin('http://64.206. 241.152/cgi- \\53226452.tic&bin/foxweb. exe/fwchart? \
sessionfile=EDDC1G2578518. A&symbol= fxd&overtick= TICKPATH c\
ountry=&selectedport=PM+TLS& navkey=logo
<http://64.206.241.152/cgi- > ',0,0,'','fwport_bin/foxweb. exe/fwchart? sessionfile= EDDC1G2578\
518.A&symbol=fxd&overtick= TICKPATH% 5C%5C53226452. tic&country= &selectedpo\
rt=PM+TLS&navkey=logo win')">FXD< /A></TD>
<TD>First Trust Consumer Discretionary AlphaDEX® Fund</TD>
The lines look that that so the FXD wouls be the symbol-I am not
getting what to do i enter the actual Ticker? plus the concencate? or
the symbol is TD for one i cansee where the problem lies since TD is
all over the code LOL.
- 1f.
-
Re: RCHGetTableCell works great except for a few symbols, weird
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Mon Jan 30, 2012 2:08 pm (PST)
I didn't see stock ticker symbols in the HTML code you sent. Just ETF
ticker symbols.
On Mon, Jan 30, 2012 at 3:04 PM, Lal Echterhoff <bigzippy@bellsouth.net >
wrote:
,">T<",,2) i get error or if i use > on either side
- 1g.
-
Re: RCHGetTableCell works great except for a few symbols, weird
Posted by: "Lal Echterhoff" bigzippy@bellsouth.net bigzippy@bellsouth.net
Mon Jan 30, 2012 2:11 pm (PST)
I use stocks and etfs the etfs work fine i just used that example because it was handy to show you the coding.
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> I didn't see stock ticker symbols in the HTML code you sent. Just ETF
> ticker symbols.
>
> On Mon, Jan 30, 2012 at 3:04 PM, Lal Echterhoff <bigzippy@...>
> wrote:
> ,">T<",,2) i get error or if i use > on either side
>
- 1h.
-
Re: RCHGetTableCell works great except for a few symbols, weird
Posted by: "Lal Echterhoff" bigzippy@bellsouth.net bigzippy@bellsouth.net
Mon Jan 30, 2012 2:21 pm (PST)
<A HREF="javascript:Jwin('http://64.206. 241.163/cgi- \\61442516.tic&bin/foxweb. exe/fwchart? sessionfile= EDDC1G2578518. A&symbol= t&overtick= TICKPATH country=& selectedport= PM+Dividend& navkey=logo' ,0,0,'',' fwport_win' )">T</A>< /TD>
there is code for a "problem" line symbol T
--- In smf_addin@yahoogroups.com , "Lal Echterhoff" <bigzippy@...> wrote:
>
>
> I use stocks and etfs the etfs work fine i just used that example because it was handy to show you the coding.
>
> --- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@> wrote:
> >
> > I didn't see stock ticker symbols in the HTML code you sent. Just ETF
> > ticker symbols.
> >
> > On Mon, Jan 30, 2012 at 3:04 PM, Lal Echterhoff <bigzippy@>
> > wrote:
> > ,">T<",,2) i get error or if i use > on either side
> >
>
- 1i.
-
Re: RCHGetTableCell works great except for a few symbols, weird
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jan 30, 2012 3:21 pm (PST)
Certainly looks like it should work. Have you tried it with pRows and
pCells both set to zero, to see if you can get THAT particular table cell?
On Mon, Jan 30, 2012 at 3:21 PM, Lal Echterhoff <bigzippy@bellsouth.net >wrote:
>
> <A HREF="javascript:Jwin('
> http://64.206.241.163/cgi- \\61442516.tic&bin/foxweb. exe/fwchart? sessionfile= EDDC1G2578518. A&symbol= t&overtick= TICKPATH country=& selectedport= PM+Dividend& navkey=logo<http://64.206. 241.163/cgi- >bin/foxweb. exe/fwchart? sessionfile= EDDC1G2578518. A&symbol= t&overtick= TICKPATH% 5C%5C61442516. tic&country= &selectedport= PM+Dividend& navkey=logo
> ',0,0,'','fwport_win')">T< /A></TD>
>
> there is code for a "problem" line symbol T
>
- 2a.
-
fundamentally promising
Posted by: "leif_85" gondoliere2@web.de leif_85
Mon Jan 30, 2012 2:02 pm (PST)
Thanks Randy and dguillet,
you answered more and better than I asked.
I shall look for a legal copy of Excel 2003, as I have read by coincidence, that my '97 version does not support the more advanced push pull data collection of the newer versions.
Then I would like to try out smf_addin. Does it offer a Metastock data conversion? Otherwise I had to stick to MLdownloader and do fundamental data collection only with smf_addin.
Of course, if it is possible to screen Yahoo data technically and fundamentally one would download only the stocks of interest and their price history. Quotes Plus worked about this way: compact local database with very fast update and after screening conversion of only a few stocks in Metastock format and customizeable spreadsheets. The screens were in a very simple language, which I managed (without too much time and effort).
There might be even another addin, "Financial Link for Excel 1.18" by XLConsulting. It offers a user interface, which avoids necessity of writing code at all. But I can not tell if it is worth while.
I used to program a bit some 20 years ago but am not shure, if I should/could learn another language now.
I shall read further in your postings. I found this group not until today.
thanks again, leif_85
- 2b.
-
Re: fundamentally promising
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jan 30, 2012 2:12 pm (PST)
I think the smfGetCSVFile() could read the MetaStock data files -- back in
the 1980's, they were just CSV files? Now, I just pull the data from Yahoo,
as needed, instead of storing it all myself.
Another option, if you are doing a lot of fundamental screening -- check
out StockScreen123.com. Or even AAII's Stock Investor Pro. I like SS123
because it has access to a lot of financial statement items, and also has a
"point in time" backtesting capability that doesn't have a survivorship
bias.
On Mon, Jan 30, 2012 at 3:02 PM, leif_85 <gondoliere2@web.de > wrote:
>
> Then I would like to try out smf_addin. Does it offer a Metastock data
> conversion? Otherwise I had to stick to MLdownloader and do fundamental
> data collection only with smf_addin.
>
- 3a.
-
RCHGetWebData-Template-BarChart-Quotes-Extract.xls
Posted by: "draz2121" bolony21@gmail.com draz2121
Mon Jan 30, 2012 3:11 pm (PST)
In your templates section you have the following example.
However, I notice that it is not correctly pulling the volume figure into Column U.
If you expand the hidden cells you can see the correct volume figure as vol = (number) but in the volume cell it is displaying a totally different number.
Example:
Ticker: BMR.LS
Volume shown in rows 7 and 8 for 30th January = 16800398
Volume shown in column U: 800398
The volume is incorrect for every day.
Can you point me towards a fix please.
Thanks.
- 3b.
-
Re: RCHGetWebData-Template-BarChart-Quotes-Extract.xls
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Mon Jan 30, 2012 3:44 pm (PST)
I just uploaded a new copy of the file. It's easier to do the extraction
now that I have some additional functions like smfStrExtr() and
smfWord() to do the extraction. In this case, I just replaced the
formula in cell L9 with:
=IFERROR(0+smfStrExtr($D9,"vol = ","'"),"--")
...which I find more self-documenting because it tells me exactly what
it's trying to extract (i.e. data between "vol =" and "'").
Thanks for the heads up that there was a problem!
On Mon, Jan 30, 2012 at 4:11 PM, draz2121 <bolony21@gmail.com > wrote:
In your templates section you have the following example.
However, I notice that it is not correctly pulling the volume figure
into Column U.
If you expand the hidden cells you can see the correct volume figure as
vol = (number) but in the volume cell it is displaying a totally
different number.
Example:
Ticker: BMR.LS <http://bmr.ls/>
Volume shown in rows 7 and 8 for 30th January = 16800398
Volume shown in column U: 800398
The volume is incorrect for every day.
Can you point me towards a fix please.
- 3c.
-
Re: RCHGetWebData-Template-BarChart-Quotes-Extract.xls
Posted by: "draz2121" bolony21@gmail.com draz2121
Mon Jan 30, 2012 3:56 pm (PST)
Thanks Randy - your support is unparralelled!
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> I just uploaded a new copy of the file. It's easier to do the extraction
> now that I have some additional functions like smfStrExtr() and
> smfWord() to do the extraction. In this case, I just replaced the
> formula in cell L9 with:
>
> =IFERROR(0+smfStrExtr($D9,"vol = ","'"),"--")
>
> ...which I find more self-documenting because it tells me exactly what
> it's trying to extract (i.e. data between "vol =" and "'").
>
> Thanks for the heads up that there was a problem!
>
> On Mon, Jan 30, 2012 at 4:11 PM, draz2121 <bolony21@...> wrote:
> In your templates section you have the following example.
>
> However, I notice that it is not correctly pulling the volume figure
> into Column U.
>
> If you expand the hidden cells you can see the correct volume figure as
> vol = (number) but in the volume cell it is displaying a totally
> different number.
>
> Example:
>
> Ticker: BMR.LS <http://bmr.ls/>
> Volume shown in rows 7 and 8 for 30th January = 16800398
> Volume shown in column U: 800398
>
> The volume is incorrect for every day.
>
> Can you point me towards a fix please.
>
- 3d.
-
Re: RCHGetWebData-Template-BarChart-Quotes-Extract.xls
Posted by: "draz2121" bolony21@gmail.com draz2121
Mon Jan 30, 2012 4:08 pm (PST)
Unfortunately, now this is not bringing through any of the prices into the cells....
Although the volume is fixed :)
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> I just uploaded a new copy of the file. It's easier to do the extraction
> now that I have some additional functions like smfStrExtr() and
> smfWord() to do the extraction. In this case, I just replaced the
> formula in cell L9 with:
>
> =IFERROR(0+smfStrExtr($D9,"vol = ","'"),"--")
>
> ...which I find more self-documenting because it tells me exactly what
> it's trying to extract (i.e. data between "vol =" and "'").
>
> Thanks for the heads up that there was a problem!
>
> On Mon, Jan 30, 2012 at 4:11 PM, draz2121 <bolony21@...> wrote:
> In your templates section you have the following example.
>
> However, I notice that it is not correctly pulling the volume figure
> into Column U.
>
> If you expand the hidden cells you can see the correct volume figure as
> vol = (number) but in the volume cell it is displaying a totally
> different number.
>
> Example:
>
> Ticker: BMR.LS <http://bmr.ls/>
> Volume shown in rows 7 and 8 for 30th January = 16800398
> Volume shown in column U: 800398
>
> The volume is incorrect for every day.
>
> Can you point me towards a fix please.
>
- 3e.
-
Re: RCHGetWebData-Template-BarChart-Quotes-Extract.xls
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Mon Jan 30, 2012 4:30 pm (PST)
Hmmm. Working for me here:
BMR.LS <=== Ticker Symbol
A - Daily Chart <=== Time Period
Date Open High Low Close Change Volume 01/30/12 $4.42 $4.88
$4.35 $4.80 $0.33 16800398 01/27/12 $4.50 $4.62 $4.41 $4.47
$0.08 4222404 01/26/12 $4.14 $4.66 $4.14 $4.40 $0.23 9439688
01/25/12 $4.13 $4.45 $3.92 $4.18 -- 12296727
What are you seeing?
On Mon, Jan 30, 2012 at 5:08 PM, draz2121 <bolony21@gmail.com > wrote:
Unfortunately, now this is not bringing through any of the prices into
the cells....
Although the volume is fixed :)
- 3f.
-
Re: RCHGetWebData-Template-BarChart-Quotes-Extract.xls
Posted by: "Shaun" bolony21@gmail.com draz2121
Mon Jan 30, 2012 4:37 pm (PST)
Hmmmm so I see...
Just "--" in each price box.
Could you try with the same ticker please then we know for sure it's me :)
BMR.LS
I won't be back at my screen till the morning now.
Thanks.
Regards,
Shaun
On 31 Jan 2012, at 00:29, "Randy H" <rharmelink@gmail.com > wrote:
> Hmmm. Working for me here:
>
>
> BMR.LS <=== Ticker Symbol
> A - Daily Chart <=== Time Period
>
> Date Open High Low Close Change Volume
> 01/30/12 $4.42 $4.88 $4.35 $4.80 $0.33 16800398
> 01/27/12 $4.50 $4.62 $4.41 $4.47 $0.08 4222404
> 01/26/12 $4.14 $4.66 $4.14 $4.40 $0.23 9439688
> 01/25/12 $4.13 $4.45 $3.92 $4.18 -- 12296727
> What are you seeing?
>
> On Mon, Jan 30, 2012 at 5:08 PM, draz2121 <bolony21@gmail.com > wrote:
> Unfortunately, now this is not bringing through any of the prices into the cells....
>
> Although the volume is fixed :)
>
>
- 3g.
-
Re: RCHGetWebData-Template-BarChart-Quotes-Extract.xls
Posted by: "Shaun" bolony21@gmail.com draz2121
Mon Jan 30, 2012 4:38 pm (PST)
Oops I see you did use that ticker :)
I will double check in the morning but find it strange that the volume is coming through.
Do I need to use the latest version of your add in perhaps?
Regards,
Shaun
On 31 Jan 2012, at 00:29, "Randy H" <rharmelink@gmail.com > wrote:
> Hmmm. Working for me here:
>
>
> BMR.LS <=== Ticker Symbol
> A - Daily Chart <=== Time Period
>
> Date Open High Low Close Change Volume
> 01/30/12 $4.42 $4.88 $4.35 $4.80 $0.33 16800398
> 01/27/12 $4.50 $4.62 $4.41 $4.47 $0.08 4222404
> 01/26/12 $4.14 $4.66 $4.14 $4.40 $0.23 9439688
> 01/25/12 $4.13 $4.45 $3.92 $4.18 -- 12296727
> What are you seeing?
>
> On Mon, Jan 30, 2012 at 5:08 PM, draz2121 <bolony21@gmail.com > wrote:
> Unfortunately, now this is not bringing through any of the prices into the cells....
>
> Although the volume is fixed :)
>
>
- 3h.
-
Re: RCHGetWebData-Template-BarChart-Quotes-Extract.xls
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Mon Jan 30, 2012 4:46 pm (PST)
Yes, you do need the latest version of the add-in -- I'm using the
smfWord() function. If you don't have that function available, it would
cause the formula to error out and display "--".
On Mon, Jan 30, 2012 at 5:38 PM, Shaun <bolony21@gmail.com > wrote:
Oops I see you did use that ticker :)
I will double check in the morning but find it strange that the volume
is coming through.
Do I need to use the latest version of your add in perhaps?
- 4.
-
Creating element definitions
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Mon Jan 30, 2012 4:24 pm (PST)
With the latest release of the add-in, defining your own elements is much simpler. Basically, you just need to add a line to one of the definition files that consist of four semi-colon delimited items:
element_number;source_name; element_name; add-in formula
The "source_name" and "element_name" fields are completely up to you. I'm planning to just use the primary data provider name for the "source_name" (e.g. Yahoo, MSN, Google, etc).
For example, suppose I have this function in a worksheet:
=RCHGetTableCell("http://finance. yahoo.com/ ",1,">Market Cap")q/ks?s=MMM
To convert that into a defined element, the only change I need to make to the formula is to put "~~~~~" where I want the ticker symbol substituted. So if I were to create a new element numbered 17006 for that formula, it might look like:
17006;Yahoo;Market Capitalization; =RCHGetTableCell ("http://finance. yahoo.com/ ",1,">Market Cap")q/ks?s=~~ ~~~
Once defined, save the definitions file and run the smfForceRecalculation macro to reload the element definitions, and you should be able to get the same data item with:
=RCHGetElementNumber("MMM", 17006)
That also means you can use more complicated formulas. For example, I recently had to redefine element #542:
542;MSN;StockScouter Rating -- Summary;=SUBSTITUTE (SUBSTITUTE( smfGetTagContent ("http://investing. money.msn. ","p",1,"Stock Rating Summary"),"<com/investments/ stock-ratings? symbol=~~ ~~~ b>","")," </b>","")
Once I got the formula working in EXCEL, it was easy to convert into an element.
- 5a.
-
Re: Is yahoo VOLUME split-adjusted?
Posted by: "pharnsbe" harnsberger@gmail.com pharnsbe
Mon Jan 30, 2012 5:16 pm (PST)
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 quotes-plus adjusted, and quotes-plus "raw" (unadjusted)/splits/ .
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.
- 5b.
-
Re: Is yahoo VOLUME split-adjusted?
Posted by: "investor952" investor952@yahoo.com investor952
Mon Jan 30, 2012 11:36 pm (PST)
I thought Yahoo's 'adjusted closed' was adjusted for dividends. Is it also adjusted for splits?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I would lean towards saying no, volume is not adjusted. Simply because they
> currently do O/H/L/C "as is", adding the adjusted close so those can be
> adjusted if desired. So I would suspect volume is "as is" as well. Because
> there would be no way to "undo" the adjustment of volume if they had
> adjusted it -- adjusted closing price couldn't be used, because that's a
> combination of split and dividend adjustments, and dividend adjustments
> wouldn't apply to volume.
>
> One way to check would be to go to a printed source of a daily quote on a
> stock prior to when it had splits, and see if it matches the Yahoo volume.
>
> On Wed, Jan 25, 2012 at 6:37 PM, pharnsbe <harnsberger@...> wrote:
>
> > I think my previous post wasn't worded clearly...
> >
> > What I'm trying to figure out is whether or not yahoo split-adjusts their
> > VOLUME data.
> >
>
- 5c.
-
Re: Is yahoo VOLUME split-adjusted?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jan 30, 2012 11:40 pm (PST)
The adjusted closing price is adjusted by both splits and dividends.
On Tue, Jan 31, 2012 at 12:36 AM, investor952 <investor952@yahoo.com > wrote:
> I thought Yahoo's 'adjusted closed' was adjusted for dividends. Is it also
> adjusted for splits?
>
- 6.1.
-
New file uploaded to smf_addin
Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com
Mon Jan 30, 2012 5:17 pm (PST)
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Yahoo Volume Is Split Adjusted.xls
Uploaded by : pharnsbe <harnsberger@gmail.com >
Description : A look at ROST volume before/after 12/2011 split.
You can access this file at the URL:
http://groups.yahoo.com/ group/smf_ addin/files/ Yahoo%20Volume% 20Is%20Split% 20Adjusted. xls
To learn more about file sharing for your group, please visit:
http://help.yahoo.com/ l/us/yahoo/ groups/original/ members/web/ index.html
Regards,
pharnsbe <harnsberger@gmail.com >
- 7a.
-
Re: New official release of the add-in -- version 2.1.2012.01.30
Posted by: "Vivek Dabholkar" dabholkar_vivek@yahoo.com dabh001
Mon Jan 30, 2012 7:21 pm (PST)
Randy,
Happy New Year to you and your family.
Regards,
Vivek
--- On Mon, 1/30/12, Randy H <rharmelink@gmail.com > wrote:
From: Randy H <rharmelink@gmail.com >
Subject: [smf_addin] New official release of the add-in -- version 2.1.2012.01.30
To: smf_addin@yahoogroups.com
Date: Monday, January 30, 2012, 11:23 AM
I just made the beta version of the add-in the new official release. There were just getting to be too many questions that referred someone to new files in the "Works in Progress" folder.
Changes made to the add-in since the 2010-08-02 release:
Date
Routine
Description
2010-08-12
RCHGetHTMLTable
Modified pDim1/pDim2 processing so the array size can be overridden from either VBA or from the worksheet. This allows other functions like TRANSPOSE() to manipulate the returned results correctly.
2010-08-23
RCHGetElementNumber
Corrected element descriptions of element numbers 4926 and 4927 on smf-elements-2.txt
2010-09-10
smfGetOptionQuotes
smfGetYahooOptionQuote
Added a "u" data item to allow retrieval of the last traded price of the underlying equity.
2010-10-06
RCHGetElementNumber
Corrected definitions of Yahoo element numbers 989 (old dividend amount), 990 (old dividend rate), and 13863 (company name) on smf-elements-2.txt
2010-10-10
Multiple
Added code to change HTML code #151 to a normal hyphen when source code is retrieved from the Internet.
2010-10-13
smfFixLinks
Changed link to be changed to a null string to be:
"'*\RCH_Stock_Market_Functions .xla'!"
...so that it can handle any file and path strings.
2010-10-25
Multiple
Added code to change HTML code #mdash to a normal hyphen when source code is retrieved from the Internet.
2010-10-25
RCHGetElementNumber
Updated the element definitions in file smf-elements-4.txt because Morningstar revised the mutual fund "Portfolio" page.
-- Elements #4681-#4726 and #4728-#4790 were updated.
-- Elements #4727 and #4791-#4810 were obsoleted.
2010-11-12
RCHGetElementNumber
Updated the element definitions (#1032-#1090) in file smf-elements-9.txt because ETF Screen changed their URL usage.
2010-12-02
smfUpdateDownloadTable
Added the ability to refer back to prior columns of data in the same row, so that retrieved data can be used in calculations.
2010-12-05
RCHGetElementNumber
Added the ability to return the regional setting by using a ticker value of "Country".
2011-01-17
RCHGetElementNumber
Added the add-in location and EXCEL regional setting to the "Version" parameter, for debugging purposes.
2011-01-26
RCHGetElementNumber
Updated the element definitions in file smf-elements-1.txt because MSN made changes to their web pages.
-- Too many were changed to mention them all.
-- Elements #2, #541-542, #544-546, and #551-552 were obsoleted.
2011-01-28
RCHGetElementNumber
Updated all Reuters element definitions for a URL change and a web page change.
2011-01-31
RCHGetElementNumber
Updated definitions of element #5079 and #5086 for Yahoo mutual funds to reflect their change on the web page of "Total Expense Ratio" to be the new "Annual Report Expense Ratio".
2011-02-14
RCHGetElementNumber
Updated definition of element #982 (Float from Yahoo Key Statistics Page) because Yahoo added a "floating" advertisement, which screwed up the string search.
2011-02-16
smfGetTagContent
Enhanced this function so that it can extract the content of table cells that are missing the "</td>" tag to close the table cell in HTML. The conversion parameter was also activated, so that the found content could be converted to its numeric value.
2011-02-16
smfGetWebPage
Added this internal function to consolidate common coding that was in a number of modules related to the saved array of web pages.
2011-02-16
smfConvertData
Added this internal function to consolidate common text-to-numeric conversion processing that in a number of modules.
2011-02-16
smfJoin
Added this utility function to allow joining or concatenation of a range of cells containing text.
2011-02-16
smfWord
Added this utility function to allow extraction of a word from a string of data divided by common delimiters.
2011-02-16
RCHGetElementNumber
Updated all Google element definitions to reflect a URL change.
2011-03-15
RCHGetElementNumber
Updated definition of element numbers 4931, 4935, 4936, and 13863 because of Yahoo web page changes.
2011-03-30
smfGetOptionExpiry
Changed function to return "next monthly expiration" only if no year or month was passed to the function.
2011-04-01
smfGetOptionQuotes
smfGetGoogleOptionQuote
Added Google as a possible data source for option quotes.
2011-04-03
RCHGetElementNumber
Updated Morningstar sector weightings elements (#4734 thru #4769) because of a realignment in their definitions on the web page. Also adjusted "Stocks" in the asset allocation table (#4715 thru #4717).
2011-04-03
smfGetOptionExpirations
New function to get list of available expiration dates.
2011-04-03
smfGetOptionStrikes
New function to get list of available strikes for a given expiration date.
2011-04-03
smfGetOptionQuotes
Change to allow a blank option ticker symbol so output is synchronized with input.
2011-04-27
smfGetWebPage
Added conversion of HTML codes 0 ("0") thru 9 ("9").
2011-04-27
RCHGetTableCell
RCHGetElementNumber
Change to use smfGetWebPage() to retrieve and preprocess web pages.
2011-04-28
Various
Change cDec() usage to smfConvertData() subroutine.
2011-05-09
RCHGetElementNumber
Obsoleted element 13891 (Business Summary description from Yahoo profile page) because it's no longer presented in a table. Instead, use:
=smfGetTagContent("http://finance. yahoo.com/ ","p",1,q/pr?s=MMM
">Business Summary")
2011-06-13
RCHGetElementNumber
Elements #547-550 were obsoleted because MSN made changes to their web pages.
2011-07-03
RCHGetYahooQuotes
Automatically change all Yahoo code items to lower case.
2011-09-05
RCHGetElementNumber
Update search string for element 701 to be "TrendSpotter" instead of "Trend Spotter" because of barchart.com website changes.
2011-11-23
smfGetOptionExpiry
Correct quarter-end option expiration date if it falls on a Saturday or a Sunday.
2011-11-27
smfGetOptionExpirations
Added OptionsXpress as a possible data source.
2011-11-27
smfGetOptionStrikes
Added OptionsXpress as a possible data source.
2011-11-30
smfGetOptionStrikes
Change OptionsXpress web page address so that all strikes are retrieved instead of just those near-the-money.
2011-11-30
smfGetOptionQuotes
Allow each cell of a range of ticker symbols to contain multiple ticker symbols.
2011-11-30
smfGetOX2OptionQuote
Change URL to one that gets all expiration dates in one Internet access.
2011-11-30
smfGetOX3OptionQuote
smfGetOptionQuotes
Add "OX3" data source so that volume and open interest can be retrieved from OptionsXPress.
2011-11-30
smfGetMSNOptionQuote
smfGetOptionQuotes
Change "u" item for MSN to pick up the last traded price of the underlying, even if after hours.
2012-01-03
smfFixLinks
Expanded scope from active worksheet to all worksheets in active workbook.
2012-01-06
smfRSITargetPrices
Undocumented function, intended for personal use only, to generate buy and sell target prices for RSI(2).
2012-01-11
RCHGetElementNumber
Add ability to define element as SMF formula by using leading "=" on formula.
2012-01-14
smfGetOptionExpirations
Fixed array overflow issue when creating ticker symbols.
2012-01-15
smfGetYahooOptionQuote
Update elements c/t/u for Yahoo web page changes (dropped last trade and time).
2012-01-27
RCHGetElementNumber
Some changes to MSN data elements:
-- Element #540 was obsoleted, as web page no longer exists
-- Element #542 had been obsoleted, but is now restored
-- Elements #547-550 had been obsoleted, but are now restored
2012-01-27
smfGetTagContent
EXCEL was returning #VALUE! errors when the length of data being returned was too large, so I added a modifiable length parameter.
2012-01-29
smfGetOptionQuotes
Return null string for a empty pItem and pTicker parameters.
2012-01-30
smfGetElementNumber
smfGetAdvFNElement
Changed top level domain URL from "http://www.advfn.com " to "http://us.advfn.com ".
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