6 New Messages
Digest #2857
Messages
Wed Nov 13, 2013 3:36 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
In most cases, you just need to create the IE security cookie, by manually
logging in with the EXCEL Web Query Dialog (preferred) or with IE. But it
does depend on how the site does security. I've only run into two sites
that don't use a security cookie, and those are more difficult (e.g.
OptionsXPress).
Some security cookies only last for a few hours, others can last months.
On Wed, Nov 13, 2013 at 3:23 PM, Jim Ranum <amt2100@gmail.com> wrote:
> Have you ever used this on a website that you have to "Login" for? Is
> there something that can be entered in the VBA code?
>
> Unfortunately I am not knowledgeable about VBA.
>
>
>
logging in with the EXCEL Web Query Dialog (preferred) or with IE. But it
does depend on how the site does security. I've only run into two sites
that don't use a security cookie, and those are more difficult (e.g.
OptionsXPress)
Some security cookies only last for a few hours, others can last months.
On Wed, Nov 13, 2013 at 3:23 PM, Jim Ranum <amt2100@gmail.
> Have you ever used this on a website that you have to "Login" for? Is
> there something that can be entered in the VBA code?
>
> Unfortunately I am not knowledgeable about VBA.
>
>
>
Wed Nov 13, 2013 3:54 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Why would you even *care* about any volume numbers of QQQ? The volume
doesn't mean anything, because the prices of an ETF aren't driven by supply
and demand. Plus, the creation and redemption units wouldn't be included in
it.
I would think you'd use the volume from ^IXIC instead. Isn't it a composite
volume of the underlying equities? What would it mean if a volume analysis
of ^IXIC indicated something different than QQQ?
Also, IMO, on a normal equity, the average per day would be more useful
than total weekly volume. You wouldn't want any type of volume analysis to
be affected by a 20% drop in volume because there were only 4 trading days
in the week. I wonder if they adjust the average for half-day trading days?
Probably not.
In any case, I don't have any easy solution to your problem. Just issues.
Sorry. :(
The best method would probably be to retrieve the daily data and convert it
into weekly data yourself.
On Wed, Nov 13, 2013 at 4:32 PM, tn mc <tnmc77@yahoo.com> wrote:
>
> How do I get total weekly volume of QQQ. One that I get from yahoo appears
> to be an average volume per day during any given week. That means that one
> has to multiply it with 5 (or 4 if there is a holiday during the week) to
> get total weekly volume.
>
doesn't mean anything, because the prices of an ETF aren't driven by supply
and demand. Plus, the creation and redemption units wouldn't be included in
it.
I would think you'd use the volume from ^IXIC instead. Isn't it a composite
volume of the underlying equities? What would it mean if a volume analysis
of ^IXIC indicated something different than QQQ?
Also, IMO, on a normal equity, the average per day would be more useful
than total weekly volume. You wouldn't want any type of volume analysis to
be affected by a 20% drop in volume because there were only 4 trading days
in the week. I wonder if they adjust the average for half-day trading days?
Probably not.
In any case, I don't have any easy solution to your problem. Just issues.
Sorry. :(
The best method would probably be to retrieve the daily data and convert it
into weekly data yourself.
On Wed, Nov 13, 2013 at 4:32 PM, tn mc <tnmc77@yahoo.
>
> How do I get total weekly volume of QQQ. One that I get from yahoo appears
> to be an average volume per day during any given week. That means that one
> has to multiply it with 5 (or 4 if there is a holiday during the week) to
> get total weekly volume.
>
Wed Nov 13, 2013 7:44 pm (PST) . Posted by:
dcbb18
I'm trying to use RCHGetElementNumber to pull MorningStar Yearly Total Returns; for example element #4857 and ticker TWEAX.
MorningStar reflects 11.23 (2012 TR) but the excel formula result is 11.20. The values are rounding and the excel formatting does not seem to be the issue.
Any simple ideas on a fix? thanks.
MorningStar reflects 11.23 (2012 TR) but the excel formula result is 11.20. The values are rounding and the excel formatting does not seem to be the issue.
Any simple ideas on a fix? thanks.
Wed Nov 13, 2013 7:49 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The data is extracted from the print report web page:
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=TWEAX
...where it is shown as 11.2.
On Wed, Nov 13, 2013 at 8:35 PM, <dcbb18@yahoo.com> wrote:
>
> I'm trying to use RCHGetElementNumber to pull MorningStar Yearly Total
> Returns; for example element #4857 and ticker TWEAX.
>
> MorningStar reflects 11.23 (2012 TR) but the excel formula result is
> 11.20. The values are rounding and the excel formatting does not seem to
> be the issue.
>
> Any simple ideas on a fix? thanks.
>
http://quicktake.
...where it is shown as 11.2.
On Wed, Nov 13, 2013 at 8:35 PM, <dcbb18@yahoo.
>
> I'm trying to use RCHGetElementNumber to pull MorningStar Yearly Total
> Returns; for example element #4857 and ticker TWEAX.
>
> MorningStar reflects 11.23 (2012 TR) but the excel formula result is
> 11.20. The values are rounding and the excel formatting does not seem to
> be the issue.
>
> Any simple ideas on a fix? thanks.
>
Wed Nov 13, 2013 8:15 pm (PST) . Posted by:
peteontheroad
RCHGetelement 848 is definitely not working, it only returns errors. How can we fix this?
---In smf_addin@yahoogroups.com, <altaclip@...> wrote:
Sorry I think I deleted that screen while editing.
I saved another one 1781996 if you want to test a screen from another user.
Zacks Rank 1/2/3
Ave Vol >100K, Price >$1, exclude OTC
5 yr ESP growth >8%
5 Yr Div growth >10%
Cur yield >2%
PEG <1.5
P/E (F2) <18
EG this yr >14%
Approx. 13 results but none are ZR1 atm.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
I tried a few other numbers at random, and they seemed to work.
I wonder if it takes a while for a new screen to be available to others.
On Tue, Nov 12, 2013 at 8:19 PM, <altaclip@... mailto:altaclip@...> wrote:
If anyone else subscribes to zacks and would like to try this I created a screen of ZR 1 & 2, price >$1,exclude OTC, & ave vol >100K. It looks like any screens saved by users get a unique id# so anyone can run them. I think this array currently returns about 420+ rows and 12-13 columns. =smfGetCSVFile("http://screener.zacks.com/export http://screener.zacks.com/export"&LEFT(RCHGetWebData("http://screener.zacks.com/screens/1781886/run http://screener.zacks.com/screens/1781886/run",1,1),0))
---In smf_addin@yahoogrou
Sorry I think I deleted that screen while editing.
I saved another one 1781996 if you want to test a screen from another user.
Zacks Rank 1/2/3
Ave Vol >100K, Price >$1, exclude OTC
5 yr ESP growth >8%
5 Yr Div growth >10%
Cur yield >2%
PEG <1.5
P/E (F2) <18
EG this yr >14%
Approx. 13 results but none are ZR1 atm.
---In smf_addin@yahoogrou
I tried a few other numbers at random, and they seemed to work.
I wonder if it takes a while for a new screen to be available to others.
On Tue, Nov 12, 2013 at 8:19 PM, <altaclip@
If anyone else subscribes to zacks and would like to try this I created a screen of ZR 1 & 2, price >$1,exclude OTC, & ave vol >100K. It looks like any screens saved by users get a unique id# so anyone can run them. I think this array currently returns about 420+ rows and 12-13 columns. =smfGetCSVFile(
Wed Nov 13, 2013 9:26 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I just tried it and it's working here.
What version of EXCEL are you using?
Do you have the updated element definitions from smf-elements-6.txt? See:
http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24294
What do you get with:
=RCHGetElementNumber("Version")
=RCHGetElementNumber("P-URL",848)
=RCHGetElementNumber("MMM";,848)
=smfConvertData(smfstrExtr(smfGetTagContent("
http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank
:"),": ","-"))
=smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks
Rank :")
=RCHGetTableCell("http://www.zacks.com/stock/quote/MMM/detailed-estimates",1,">Premium
Research",">Zacks Rank")
=smfConvertData(smfstrExtr(RCHGetWebData("
http://www.zacks.com/stock/quote/MMM/detailed-estimates","Zacks Rank
:",30),":","-"))
On Wed, Nov 13, 2013 at 9:15 PM, <peteontheroad@yahoo.com> wrote:
>
> RCHGetelement 848 is definitely not working, it only returns errors. How
> can we fix this?
>
What version of EXCEL are you using?
Do you have the updated element definitions from smf-elements-
http://groups.
What do you get with:
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfConvertData(
http://www.zacks.
:"),"
=smfGetTagContent(
Rank :")
=RCHGetTableCell(
Research"
=smfConvertData(
http://www.zacks.
:",30),
On Wed, Nov 13, 2013 at 9:15 PM, <peteontheroad@
>
> RCHGetelement 848 is definitely not working, it only returns errors. How
> can we fix this?
>
Tidak ada komentar:
Posting Komentar