Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 7/21/2005(UTC)
Posts: 74
Location: Oklahoma USA
|
Is there a way of copying the underlying data from a line study, such as the Raff Regression Channel, to an Excel worksheet like the OLE function for indicators? I know the data is there because I can see it with a mouse over but have not been able to see the entire set of data or copy it to an Excel spreadsheet from Metastock.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Hey crw-
Heyseed recently answered this one (pretty closely) in this thread: http://forum.equis.com/viewtopic.php?t=1434curity | Datasheet screen. Save your work. Then you can use TOOLS | CONVERT to export your data or you can copy and paste it to Excel directly.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 7/21/2005(UTC)
Posts: 74
Location: Oklahoma USA
|
Thanks Stockman, yes the OLE for indicators works great and I use frequently but this question is for the line studies - I do not think that is what Hayseed was talking about. The only thing I can get on the line study is an object - I need the underlying data. I am still looking but so far have not found the answer. The only solution is to mouse over and copy the data manually - which seems silly when the data is there electronically. There just has to be a another way to get it.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Hey crw-
Sorry, perhaps I'm not understanding your question then. Say you want to copy the values for a moving average, lower channel line, price ROC, etc. The procedure is the same. When you paste the values into the datasheet these line study values will all be listed in the "open" column right beside their date. If your purpose is to export the values anyway, the "open" label is no biggie. All of the other fields will contain a zero.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Ok-
Just takes me a little bit... it is a problem with the regression lines. Apparently, some line studies will copy and some won't. I'm going to keep trying... :)
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Well... not a solution, but a possible workaround. You can create a custom indicator to plot the regression channels and export the data in the manner described earlier. I can't figure out how to do it with the built-in indicator though. I achieved success using Jose Silva's formula:
Originally Posted by: Linear Regression Trendline periods",2,2520,63) 
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 7/21/2005(UTC)
Posts: 74
Location: Oklahoma USA
|
Thanks Stockman, I have been working on this same concept using an old custom formula I had created back in 6.52 days. This one is much better than the one I have. It does have a limation in that I do not see an option to extend the plot to the right. Actually, I am not sure if it can be done with a custon formula. I have been trying to work forward of the right edge and have not had any success with Metastock and have had to move to Excel. Thus the need to be able to transfer data to Excel. If you or any forum member has any information on how to forward plot the Parabolic SAR, Timeseries or any of the Linear Regression line studies with custom formulas I would certainly be interested in the information. I know Metastock has its limitations, but it seems it should be unnessary to have to work around some of this stuff since the data is already there in Metastock. Logic would indicate that if you can extend line studies to the right you should be able to extend custom formulas to the right also.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 7/21/2005(UTC)
Posts: 74
Location: Oklahoma USA
|
Hey Stockman, Patrick, et al, here is a solution I found which allows me to do analysis beyond the right edge. I create EOD OHLC data using Excel for say 20 days forward and copy paste into the Downloader for the securities I work with. I supose the data can be linked from Excel back into MS but for now copying works for me. The basic formula I use is:
where today = t
n = 1 to 20
H t+n = ((H t - L t-n)+L t)
L t+n = (H t+n- (H t-n - L t-n))
O t+n = L t+n {the open is used so I can display a Candlestick}
C t+n = H t+n {the close is used so I can display a Candlestick}
A word of caution - since this is data projected into the future I am not sure how other indicators might react - I am only using projection line studies such as the Raff Regression Channel, Timeseries and the Parabolic SAR that do not rely on the true open or close. Maybe someone else other than myself is interested in this type of analysis. Thanks for your help on my other posts for information. Charley
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Cool. Thanks Charley for sharing!
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 7/21/2005(UTC)
Posts: 74
Location: Oklahoma USA
|
Here is some recent data for the NDX and future data created by the formula I posted above. Charley
07/25/2005 1600.62 1607.97 1591.4 17897
07/26/2005 1596.81 1603.89 1591.58 20701
07/27/2005 1601.39 1613.39 1592.76 25512
07/28/2005 1613.29 1619.78 1609.62 18797
07/29/2005 1616.42 1619.95 1605.14 21008
08/01/2005 1609.74 1616.4 1604.58 14927
08/02/2005 1611.86 1628.57 1611.86 17350
08/03/2005 1619.98 1628.53 1618.4 17063
08/04/2005 1619.18 1621 1606.6 21099
08/05/2005 1606.63 1614.22 1600.25 20297
08/08/2005 1604.23 1607.01 1588.74 20920
08/09/2005 1596.15 1606.51 1595.71 18226
08/10/2005 1604.8 1610.21 1582.31 29279
08/11/2005 1587.77 1603.66 1586.67 26802
08/12/2005 1587.69 1594.96 1581.41 1591.75
08/15/2005 1587.59 1606.98 1585.66 1601.71
08/16/2005 1595.86 1596.54 1572.44 1574.01
08/17/2005 1577.57 1588.8 1573.87 1582.29
08/18/2005 1578.2 1585.28 1573.4 1575.76
08/19/2005 1576.57 1581.27 1573.7 1579.32
1 1569.69 1581.57 1569.69 1581.57
2 1566.17 1581.1 1566.17 1581.1
3 1558.43 1582.53 1558.43 1582.53
4 1547.99 1569.31 1547.99 1569.31
5 1560.01 1573.56 1560.01 1573.56
6 1551.31 1568.3 1551.31 1568.3
7 1544.76 1572.66 1544.76 1572.66
8 1548.46 1559.26 1548.46 1559.26
9 1547.96 1566.23 1547.96 1566.23
10 1540.75 1554.72 1540.75 1554.72
11 1533.97 1548.37 1533.97 1548.37
12 1526.44 1536.57 1526.44 1536.57
13 1526.4 1543.11 1526.4 1543.11
14 1538.57 1550.39 1538.57 1550.39
15 1535.02 1549.83 1535.02 1549.83
16 1535.19 1545.35 1535.19 1545.35
17 1541.58 1562.21 1541.58 1562.21
18 1551.08 1563.39 1551.08 1563.39
19 1565.96 1582.53 1565.96 1582.53
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 7/21/2005(UTC)
Posts: 74
Location: Oklahoma USA
|
And here is the chart generated from the data. The chart has the Parabolic SAR, Raff Regression Channels, 3% ZigZag and Jose's Lunar Cycle with vertical lines.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
