logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Croesus  
#1 Posted : Wednesday, August 1, 2012 5:34:05 PM(UTC)
Croesus

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 7/6/2011(UTC)
Posts: 2

As a newbie to Metastock EOD I'd like to know if there's any (painless) way of charting the historic total value of a portfolio of shares by linking transaction history to Metastock EOD data. The free software ShareVista can do this but doesn't tie in to Metastock data. I'm in the UK and only invest on the LSE.

Thanks
jjstein  
#2 Posted : Wednesday, August 1, 2012 6:21:12 PM(UTC)
jjstein

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 5/13/2005(UTC)
Posts: 715
Location: Midwest, USA

Was thanked: 1 time(s) in 1 post(s)
No painless way...

You might be able to set something up in Excel, then read it & plot it using MetaStockCSV. It wouldn't be very flexible, though -- it would need a fixed set of symbols in a folder, I think.

mstt  
#3 Posted : Wednesday, August 1, 2012 9:40:09 PM(UTC)
mstt

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042

Was thanked: 57 time(s) in 54 post(s)
Hi Croesus

If your portfolios meet certain conditions it's possible to generate a portfolio equity curve with my Trade Equity Portfolio Display indicator after running the appropriate Trade Equity explorations. The process is not totally painless, though, and there's a distinct earning curve involved. The portfolio result is created by the exploration summing all individual results. Expert commentary reports are created by one of several explorations as well.

I'll make an effort to upload a sample equity curve display to my website within the next 24 hours and post the link in this thread.

Roy
mstt  
#4 Posted : Wednesday, August 1, 2012 9:41:41 PM(UTC)
mstt

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042

Was thanked: 57 time(s) in 54 post(s)
"Earning curve" sounds good, but it should be "learning curve"
Croesus  
#5 Posted : Thursday, August 2, 2012 2:19:02 AM(UTC)
Croesus

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 7/6/2011(UTC)
Posts: 2

I found some free software that will do want I want in terms of plotting total portfolio value: http://www.sharevista.co.uk/ . However this doesn't appear to be able to use local Metastock EOD data.
mstt  
#6 Posted : Thursday, August 2, 2012 3:26:29 PM(UTC)
mstt

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042

Was thanked: 57 time(s) in 54 post(s)
Hi Croesus

The link below has an example of a portfolio curve generated by Trade Equity. The curve is based on 2500 bars of data and 93 of the current S&P 100. The system tested is PS Meisels Overbought/Oversold, long side only, as distributed with MetaStock.

The second window using the same indicator plots the number of open trades at any one time.

www.metastocktips.co.nz/sp_100_portfolio_curve.png

Roy
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.