There are different strategies for selecting stocks for intraday trading. i use the historical data strategy method. It will give you a fair idea of the range the stocks ranges for most of the days.
1. Go to https://in.finance.yahoo.com/
2. Enter Stock Symbol in Look up Text box.
3. Do Look up.
4. The stock data is displayed.
5. Go to Historical Prices Link.
6. Enter Start Date, End Date and Click Get Prices.
7. Data will be displayed.
8. Download data. Click the "Download to Spreadsheet" link. Download .file to local PC.
8. Open the file in excel.
9. Add 2 more Columns. HighRange and LowRange.
10. Enter Formal for HighRange data values.
=ROUND((C2-B2),2)
11. Enter Formal for LowRange data values.
=ROUND((B2-D2),2)
12. Select the whole date. Draw Pivot Table. Go to Insert .
12. Select radio button "New Worksheet". Click "Ok".
13. In "Sheet 1", Select "HighRange" in "Rows" and "Sum of High Range" in "Values".
14. Pivot Table will be displayed.
15. Group the Row Labels : Right in a cell value in table cell data for "Row Labels".Select Group.
16. In the "Grouping" window, set 1 as value in "By" Click "Ok".
17. Grouped "Pivot Value" is displayed.
18. These Grouped values gives the number of times that values occurs within a given range. like within range of 1.05 -2.05 from day's open, the value has 404.35 chances of occurrence. An approximate 36.79%. Similarly. repeat for LowRange.
No comments:
Post a Comment