Senin, 09 November 2015

[smf_addin] Digest Number 3554[4 Attachments]

14 Messages

Digest #3554
1c
Re: Creating a Calculate Now Button by "Thomas Carnevale" tc_nyc85
3a
Re: Yahoo Options broken by "Barry Rosman" bnr0sman
4a
Import Finviz screen by scottandrewjackson
4b
Re: Import Finviz screen by "Randy Harmelink" rharmelink
5a

Messages

Sun Nov 8, 2015 7:17 am (PST) . Posted by:

inkt2002

Hi Guys!
I know this is not stock market related, but would someone be kind enough to create a Calculate Button in the attached spreadsheet. The formula is in column F. I want to be able to input the 3 variables in the yellow highlighted cells and be able to press CALCULATE to produce the answer.


Very Grateful for any help!
Attachment(s) from
1 of 1 File(s)

Sun Nov 8, 2015 9:32 am (PST) . Posted by:

"Thomas Carnevale" tc_nyc85

Shift+F9 only calculates the current sheet. To calculate you should save
the file and excel will calculate all sheets.
On Nov 8, 2015 12:17 PM, "john@nerva.com [smf_addin]" <
smf_addin@yahoogroups.com> wrote:

>
>
> Have you tried using Shift-F9 ?
>
>

Sun Nov 8, 2015 9:10 am (PST) . Posted by:

sundeep_chadha

Hi -


Sorry in advance if the answer is obvious and shows my ignorance.


I am trying to download (into excel) the results of the Predefined Expert Stock Screens that Fidelity provides. Some of the Predefined Expert Screen that Fidelity has are "Thank you PEG", "Growth at a reasonable price", "Earning Growth, Rating upgrades and Positive Surprises" etc. I would like to be able to download results of each of these screen into a separate file (or same file with different worksheets).


My objective is to have a workbook, with different tabs, that has the results of all the screens that I want. Then I would want to give a score of "1" for each stock that is found in a screen. In other words if a stock is in 5 screens, then it will get a score of "5", if it is in just 2 screens then it get a "2" score etc. That score can be used, among other factors, to rank the stock. (this could be a part of momentum strategy...)


I will be willing to share the xls with the community if someone can guide me how to download the results of the screen into excel.


Have a wonderful Sunday


Regards,
Sundeep


Sun Nov 8, 2015 9:37 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

I think you are going to have to supply more details, like the URL, fields and whatever else that might give folks a clue to whatever it is you are trying to do.

You might attach the spreadsheet if that will provide the information.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, November 08, 2015 12:10 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Downloading Results (table) for Fidelity Predefined Expert Screen


Hi -

Sorry in advance if the answer is obvious and shows my ignorance.

I am trying to download (into excel) the results of the Predefined Expert Stock Screens that Fidelity provides. Some of the Predefined Expert Screen that Fidelity has are "Thank you PEG", "Growth at a reasonable price", "Earning Growth, Rating upgrades and Positive Surprises" etc. I would like to be able to download results of each of these screen into a separate file (or same file with different worksheets).

My objective is to have a workbook, with different tabs, that has the results of all the screens that I want. Then I would want to give a score of "1" for each stock that is found in a screen. In other words if a stock is in 5 screens, then it will get a score of "5", if it is in just 2 screens then it get a "2" score etc. That score can be used, among other factors, to rank the stock. (this could be a part of momentum strategy...)

I will be willing to share the xls with the community if someone can guide me how to download the results of the screen into excel.

Have a wonderful Sunday

Regards,
Sundeep


Sun Nov 8, 2015 9:39 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Whether or not that can be done would depend entirely on how they present
the data of the screening process. If it's a dynamically produced output,
the add-in won't be able to help. If the data is within the source code of
the web page and it has a bookmarkable URL, then there's a good chance the
add-in can get to the data.

On Sun, Nov 8, 2015 at 10:10 AM, sundeep_chadha@... wrote:

> Sorry in advance if the answer is obvious and shows my ignorance.
>
> I am trying to download (into excel) the results of the Predefined Expert
> Stock Screens that Fidelity provides. Some of the Predefined Expert Screen
> that Fidelity has are "Thank you PEG", "Growth at a reasonable price",
> "Earning Growth, Rating upgrades and Positive Surprises" etc. I would like
> to be able to download results of each of these screen into a separate file
> (or same file with different worksheets).
>
> My objective is to have a workbook, with different tabs, that has the
> results of all the screens that I want. Then I would want to give a score
> of "1" for each stock that is found in a screen. In other words if a stock
> is in 5 screens, then it will get a score of "5", if it is in just 2
> screens then it get a "2" score etc. That score can be used, among other
> factors, to rank the stock. (this could be a part of momentum strategy...)
>
> I will be willing to share the xls with the community if someone can guide
> me how to download the results of the screen into excel.
>
>

Sun Nov 8, 2015 12:04 pm (PST) . Posted by:

sundeep_chadha



Thanks for the response.

I am attaching the xls download from the site as well as the screen shot of the screen. I don't know how to find out the answer to the question Randy is asking. Can you guide me in helping find that answer?


Regards,
Sundeep


Attachment(s) from
1 of 1 Photo(s)
1 of 1 File(s)

Sun Nov 8, 2015 3:24 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but neither of those help me. I would need to see the source code of
the web page. And even that might not be sufficient, since the results can
be generated by script or JSON.

However, it looks like you have an export option. Can you just use that to
automate the process?

On Sun, Nov 8, 2015 at 1:04 PM, sundeep_chadha@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> [Attachment(s) <#150e8b312a5ca869_TopText> from sundeep_chadha@yahoo.com
> [smf_addin] included below]
>
>
> Thanks for the response.
>
> I am attaching the xls download from the site as well as the screen shot
> of the screen. I don't know how to find out the answer to the question
> Randy is asking. Can you guide me in helping find that answer?
>
> Regards,
> Sundeep
>
>
>
>
>
> Attachment(s) from sundeep_chadha@yahoo.com [smf_addin] | View
> attachments on the web
> <https://groups.yahoo.com/neo/groups/smf_addin/attachments/1203205291;_ylc=X3oDMTJybTk0MTVsBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDYXR0YWNobWVudARzbGsDdmlld09uV2ViBHN0aW1lAzE0NDcwMTMwNTk->
>
> 1 of 1 Photo(s)
> [image: Screen Shot.jpg]
> <https://groups.yahoo.com/neo/groups/smf_addin/attachments/1203205291;_ylc=X3oDMTJucmdlNW0wBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDYXR0YWNobWVudARzbGsDcGhvdG8Ec3RpbWUDMTQ0NzAxMzA1OQ--?itemid=248360539>
> Screen Shot.jpg
> <https://groups.yahoo.com/neo/groups/smf_addin/attachments/1203205291;_ylc=X3oDMTJucmdlNW0wBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDYXR0YWNobWVudARzbGsDcGhvdG8Ec3RpbWUDMTQ0NzAxMzA1OQ--?itemid=248360539>
>
> 1 of 1 File(s)
> Fidelity PEG - Screener Results.xls
> <https://xa.yimg.com/kq/groups/18094620/661769300/name/Fidelity%20PEG%20-%20Screener%20Results%2Exls>
>

Sun Nov 8, 2015 4:21 pm (PST) . Posted by:

sundeep_chadha

Thank you for your kindheartedness in responding to all queries and many thanks to the wonderful folks on the group.

I am attaching the text version of the "Source" of the Thank You PEG screen from Fidelity.
I am open in the Automation that you suggest. How can I, say download, in excel, the results of 10 screens, without manually running them on Fidelity site serially? (My apologies for being thick headed on this).


Regards,
Sundeep
Attachment(s) from
1 of 1 File(s)

Sun Nov 8, 2015 7:38 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I didn't see any screening output data in the source code you sent.

The only way you could download the results of the 10 screens is if those
results are actually sitting on their servers. If you need to "run" them by
choosing an option within the screener, it may not be possible to get at
the data with the add-in.

On Sun, Nov 8, 2015 at 5:21 PM, sundeep_chadha@... wrote:

>
> Thank you for your kindheartedness in responding to all queries and many
> thanks to the wonderful folks on the group.
>
> I am attaching the text version of the "Source" of the Thank You PEG
> screen from Fidelity.
> I am open in the Automation that you suggest. How can I, say download, in
> excel, the results of 10 screens, without manually running them on Fidelity
> site serially? (My apologies for being thick headed on this).
>
>
>

Sun Nov 8, 2015 7:00 pm (PST) . Posted by:

"Barry Rosman" bnr0sman

yahoo fixed it. their portfolios with options is no working.
From: "Barry Rosman bnr0sman@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com>
To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
Sent: Friday, November 6, 2015 9:40 PM
Subject: Re: [smf_addin] Yahoo Options broken

  I used :smfGetNasdaqOptionQuote and it worked fine. It found weekly and monthly options. The percent change is  negative.The Nasdaq option is undocumented, but is a valid function.
Google was not returning weekly options.
  Barry Rosman

From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, November 6, 2015 5:08 PM
Subject: Re: [smf_addin] Yahoo Options broken

  I looked at the source code of a few options web pages. The tables are there, but only have headers. No rows with option quotes...

Someone mentioned they weren't working for a short time on Tuesday as well...

On Fri, Nov 6, 2015 at 2:48 PM, wiscobez@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

It was mentioned in the Excel 2016 thread, but I wanted to give this issue it's own header...

Yahoo options stopped working as of today.   Mine won't return anything.

#yiv6492514333 #yiv6492514333 -- #yiv6492514333ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6492514333 #yiv6492514333ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6492514333 #yiv6492514333ygrp-mkp #yiv6492514333hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6492514333 #yiv6492514333ygrp-mkp #yiv6492514333ads {margin-bottom:10px;}#yiv6492514333 #yiv6492514333ygrp-mkp .yiv6492514333ad {padding:0 0;}#yiv6492514333 #yiv6492514333ygrp-mkp .yiv6492514333ad p {margin:0;}#yiv6492514333 #yiv6492514333ygrp-mkp .yiv6492514333ad a {color:#0000ff;text-decoration:none;}#yiv6492514333 #yiv6492514333ygrp-sponsor #yiv6492514333ygrp-lc {font-family:Arial;}#yiv6492514333 #yiv6492514333ygrp-sponsor #yiv6492514333ygrp-lc #yiv6492514333hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6492514333 #yiv6492514333ygrp-sponsor #yiv6492514333ygrp-lc .yiv6492514333ad {margin-bottom:10px;padding:0 0;}#yiv6492514333 #yiv6492514333actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6492514333 #yiv6492514333activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6492514333 #yiv6492514333activity span {font-weight:700;}#yiv6492514333 #yiv6492514333activity span:first-child {text-transform:uppercase;}#yiv6492514333 #yiv6492514333activity span a {color:#5085b6;text-decoration:none;}#yiv6492514333 #yiv6492514333activity span span {color:#ff7900;}#yiv6492514333 #yiv6492514333activity span .yiv6492514333underline {text-decoration:underline;}#yiv6492514333 .yiv6492514333attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6492514333 .yiv6492514333attach div a {text-decoration:none;}#yiv6492514333 .yiv6492514333attach img {border:none;padding-right:5px;}#yiv6492514333 .yiv6492514333attach label {display:block;margin-bottom:5px;}#yiv6492514333 .yiv6492514333attach label a {text-decoration:none;}#yiv6492514333 blockquote {margin:0 0 0 4px;}#yiv6492514333 .yiv6492514333bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6492514333 .yiv6492514333bold a {text-decoration:none;}#yiv6492514333 dd.yiv6492514333last p a {font-family:Verdana;font-weight:700;}#yiv6492514333 dd.yiv6492514333last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6492514333 dd.yiv6492514333last p span.yiv6492514333yshortcuts {margin-right:0;}#yiv6492514333 div.yiv6492514333attach-table div div a {text-decoration:none;}#yiv6492514333 div.yiv6492514333attach-table {width:400px;}#yiv6492514333 div.yiv6492514333file-title a, #yiv6492514333 div.yiv6492514333file-title a:active, #yiv6492514333 div.yiv6492514333file-title a:hover, #yiv6492514333 div.yiv6492514333file-title a:visited {text-decoration:none;}#yiv6492514333 div.yiv6492514333photo-title a, #yiv6492514333 div.yiv6492514333photo-title a:active, #yiv6492514333 div.yiv6492514333photo-title a:hover, #yiv6492514333 div.yiv6492514333photo-title a:visited {text-decoration:none;}#yiv6492514333 div#yiv6492514333ygrp-mlmsg #yiv6492514333ygrp-msg p a span.yiv6492514333yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6492514333 .yiv6492514333green {color:#628c2a;}#yiv6492514333 .yiv6492514333MsoNormal {margin:0 0 0 0;}#yiv6492514333 o {font-size:0;}#yiv6492514333 #yiv6492514333photos div {float:left;width:72px;}#yiv6492514333 #yiv6492514333photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6492514333 #yiv6492514333photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6492514333 #yiv6492514333reco-category {font-size:77%;}#yiv6492514333 #yiv6492514333reco-desc {font-size:77%;}#yiv6492514333 .yiv6492514333replbq {margin:4px;}#yiv6492514333 #yiv6492514333ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6492514333 #yiv6492514333ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6492514333 #yiv6492514333ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6492514333 #yiv6492514333ygrp-mlmsg select, #yiv6492514333 input, #yiv6492514333 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6492514333 #yiv6492514333ygrp-mlmsg pre, #yiv6492514333 code {font:115% monospace;}#yiv6492514333 #yiv6492514333ygrp-mlmsg * {line-height:1.22em;}#yiv6492514333 #yiv6492514333ygrp-mlmsg #yiv6492514333logo {padding-bottom:10px;}#yiv6492514333 #yiv6492514333ygrp-msg p a {font-family:Verdana;}#yiv6492514333 #yiv6492514333ygrp-msg p#yiv6492514333attach-count span {color:#1E66AE;font-weight:700;}#yiv6492514333 #yiv6492514333ygrp-reco #yiv6492514333reco-head {color:#ff7900;font-weight:700;}#yiv6492514333 #yiv6492514333ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6492514333 #yiv6492514333ygrp-sponsor #yiv6492514333ov li a {font-size:130%;text-decoration:none;}#yiv6492514333 #yiv6492514333ygrp-sponsor #yiv6492514333ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6492514333 #yiv6492514333ygrp-sponsor #yiv6492514333ov ul {margin:0;padding:0 0 0 8px;}#yiv6492514333 #yiv6492514333ygrp-text {font-family:Georgia;}#yiv6492514333 #yiv6492514333ygrp-text p {margin:0 0 1em 0;}#yiv6492514333 #yiv6492514333ygrp-text tt {font-size:120%;}#yiv6492514333 #yiv6492514333ygrp-vital ul li:last-child {border-right:none !important;}#yiv6492514333

Sun Nov 8, 2015 7:01 pm (PST) . Posted by:

scottandrewjackson

Hi Randy,




How would I go about importing the screen results and detail columns from FinViz? I searched the group and couldn't figure out the answer. I am trying to build an options monitoring dashboard based on the underlying securities this screen produces.


http://www.finviz.com/screener.ashx?v=151&f=cap_micro,fa_debteq_u0.2,fa_pb_u1,geo_usa,sh_insidertrans_pos,sh_opt_option&ft=4&o=-pb





Thank you Randy!


-Scott


Sun Nov 8, 2015 7:59 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Easiest way would be to become a subscriber so you can use the "Export"
option.

Barring that, you'd need to pull the data one table cell at a time, with
something like:

=smfGetTagContent("
http://www.finviz.com/screener.ashx?v=151&f=cap_micro,fa_debteq_u0.2,fa_pb_u1,geo_usa,sh_insidertrans_pos,sh_opt_option&ft=4&o=-pb
","td",$B28,">Total:")

...where $B28 varies from 6 and up to 236 for each page of output (i.e.
each page has a different URL). Plus, you'd need to extract the data from
the coding of the table cell, which may vary for each column of output.

It might be easier to just extract the ticker symbols with something like:

=smfStrExtr(smfGetTagContent("
http://www.finviz.com/screener.ashx?v=151&f=cap_micro,fa_debteq_u0.2,fa_pb_u1,geo_usa,sh_insidertrans_pos,sh_opt_option&ft=4&o=-pb
","tr",$B28,">Total:"),"?t=","&ty")

...where $B28 will vary from 3 and up to 22 on each page of output. Then
use the technique described on the "FAQs and Tips" web page to get whatever
data fields you're interested in.

On Sun, Nov 8, 2015 at 8:01 PM, scottandrewjackson@...wrote:

> How would I go about importing the screen results and detail columns from
> FinViz? I searched the group and couldn't figure out the answer. I am
> trying to build an options monitoring dashboard based on the underlying
> securities this screen produces.
>
>
> http://www.finviz.com/screener.ashx?v=151&f=cap_micro,fa_debteq_u0.2,fa_pb_u1,geo_usa,sh_insidertrans_pos,sh_opt_option&ft=4&o=-pb
>
>

Mon Nov 9, 2015 12:59 am (PST) . Posted by:

scottandrewjackson

Randy,


Does this insider formula still work? After creating an account, I'm still not having any luck. Just trying to find net insider purchases. I don't care what the time period is, as long as I know what it is.


Dashboard.xlsx https://www.dropbox.com/s/1l730kcq88z8orp/Dashboard.xlsx?dl=0

https://www.dropbox.com/s/1l730kcq88z8orp/Dashboard.xlsx?dl=0

Dashboard.xlsx https://www.dropbox.com/s/1l730kcq88z8orp/Dashboard.xlsx?dl=0 Shared with Dropbox



View on www.dropbox.com https://www.dropbox.com/s/1l730kcq88z8orp/Dashboard.xlsx?dl=0
Preview by Yahoo





-Scott



For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar