En cours

Routing working with lists on a MacBook Pro using Mac OS X

Lists on MacBook Pro using Mac OS X 10.7.3 (or also 10.6.8!) and Excel

A) The principal goal of the routine is to create a new Barchart Portfolio with a list of stocks that appear at least two times on a list created by the merge of. The goal is to make a stcoks' list worth warching their graph :

1) the list of Today's Stocks on the move of IBD URL: [url removed, login to view]

2) the list of Barchart list of US Exchange Gap Up, but limited to stocks with a 50-Day Avg Vol of 390,000 or higher URL: [url removed, login to view] (be carefull to take the "Full List"

3) the list of Barchart list of TrendSpotter Buy, but limited to stocks with a 50-Day Avg Vol of 390,000 or higher URL: [url removed, login to view], then click on xx Stocks URL [url removed, login to view]

(sometimes there are more than 100 stocks so a test on "Full List" might be created!)

4) the list of Barchart list of Top Signals Stocks (TopS), but limited to stocks with a 50-Day Avg Vol of 390,000 or higher URL: [url removed, login to view]

5) the list of Barchart list of Top 100 Stocks Sector (B100), but limited to stocks with a 50-Day Avg Vol of 390,000 or higher URL: [url removed, login to view]

6) I would like to have the possibility to ask to add the IBD 50 list URL: [url removed, login to view] or some other lists choosen from time to time

B) Another goal of the routine is to take and keep lists created by IBD, and sometimes to add one of this list to the merge of Today's Stocks on the move, B Top Signal and B100:

1) Screen of the Day URL [url removed, login to view]

1a) on a regular basis IBD creates the following Screen of the Day:

Young Guns

Top Fundamentals

Accelerating Mutual Fund Ownership

Financial Efficiency

Bolting RS Lines

Big Cap Leaders

ETF Consolidation

Small-Cap Leaders

Healthy Profit Margin

Estimate Beaters

2) Top Sector Performers

3) CAN SLIM

4) Tech Leaders: on a regular basis IBD creates the following Tech Leaders list:

Computer

Electronics

Medical

Internet

Telecom

C) To be able to compare lists of today with lists of yesterday for IBD 50 list, Barchart Top Signal List, Barchart Top 100 Stocks Sector list

For example: I want to automatically:

To open the Excel document "Comparison" and

A) (GapUp)

1) to click on "Gap Up" in column A to go to the URL (this is a proposal, its what I do, but the routine can, of course, do it in another, quickest way!):

[url removed, login to view]

2) On the page US Exchanges Gap Up to click in the box:

Custom Views: -Select and choose "Avg Vol"

URL: [url removed, login to view]

3) On the page displayed, to click on the column "50-Day Avg Vol"

4) Then to select all the stocks with a "50-Day Avg Vol" of "390,000" or more

5) to copy all these informations

6) to open a new document Excel

7) to paste the information on the new Excel document

8) to put a color in the cells (text and/or numbers) (in fact its just important to have the stikers colored

9) to copy the tickers from column A to paste them on the top of column O

10) to sort the stickers contained in column O

11) to copy the information

12) to save the document as "Gap Up 042412" (or updated of course) in a folder named "Démarche 042212" (or updated, or up to you to choose a folder)

13) to go to the document "Comparison" coloumn foe example AZ

14) From row 3, to delete all the information down

15) Go to row 2 to change the date and put the yesterday day 0424

16) to go down to row 3

17) to paste the stickers

B) and do the same as above for 1) Barchart list of TrendSpotter Buy, Top Signals Stocks (TopS, Top 100 Stocks Sector (B100)

Compétences : Saisie de Données, Excel, Javascript, Mac OS, Script Install

Voir plus : working limited, up working, top graph, signal financial, select medical, select leaders, principal financial, medical mutual, medical graph, list graph, leaders today, javascript barchart, graph using, graph top, graph computer, top javascript, excel pro, custom list excel, custom stickers, create graph, computer pro, computer graph, click test, big time, proposal example

Concernant l'employeur :
( 3 commentaires ) Lausanne, Switzerland

N° du projet : #1611830