SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
SI - Site Forums : Silicon Investor - Legacy Interface Discussion (2004-2011)
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
From: SI Dave9/25/2004 7:35:49 PM
  Read Replies (13) of 6035
 
PORTFOLIO STATUS UPDATE

I've finished building the queries and made a first pass at fomatting. It appears the "trade" table consists of user-defined positions, with multiple positions of the same ticker possible within a given portfolio. I assume the BuyPrice reflects the closing cost basis after past in/out trades have been applied. I don't see any tables with an additional level of detail.

In the following example, the user had two portfolios. I'll do a line break in between them on final output.

I'd like to get some feedback on format.. ordering of fields, and format. It's going to be delivered to the browser as a straight text file.

Not shown are two fields; the portfolio name (up 40 chars), and a "notes" field for each postion up to 250 chars. I'm thinking about making those optional appends at the end of each line, or have them follow as separate output, with a reference to PortfolioID and Seq.

It won't be all things to all people, but it's something. Presumably, the user will either rekey the data or modify it in an editor for import.

I'd like to wrap this up tomorrow, time permitting, so let's hear some feedback! And, let's keep it simple!


PortfoID BuyDate    Ticker   Shares         BuyPrice       Commisn   LastSplit  Seq  
-------- ---------- -------- -------------- -------------- --------- ---------- ---- 
9343320  2000-04-18 ENCY     500.000        11.530000      NULL      NULL       1  
9343320  2000-06-20 ENCY     500.000        15.490000      NULL      NULL       2  
9343320  2000-10-12 ENCY     500.000        11.520000      NULL      NULL       3  
9343320  2003-11-03 SNUS     1000.000       6.000000       NULL      NULL       8  
9343320  2003-11-07 PGH      1100.000       14.130000      NULL      NULL       7  
9343320  2004-01-27 MU       800.000        16.240000      NULL      NULL       6  
9343320  2004-01-27 SUNW     1000.000       5.790000       NULL      NULL       9  
9343320  2004-01-27 TWX      500.000        19.180000      NULL      NULL       10 
9343320  2004-01-27 ENCY     500.000        10.640000      NULL      NULL       4  
9343320  2004-01-27 MU       200.000        16.260000      NULL      NULL       5  
9343320  2004-05-11 AMD      1000.000       15.760000      NULL      NULL       0  
9343320  2004-05-11 VTSS     500.000        5.520000       NULL      NULL       11 
9343321  2003-12-04 ORCL     1000.000       13.370000      NULL      NULL       3  
9343321  2003-12-04 PGH      100.000        14.760000      NULL      NULL       4  
9343321  2003-12-04 SNUS     1000.000       5.670000       NULL      NULL       7  
9343321  2003-12-17 F        500.000        14.700000      NULL      NULL       1  
9343321  2003-12-19 GTW      1000.000       5.780000       NULL      NULL       2  
9343321  2003-12-29 PGH      650.000        16.780000      NULL      NULL       5  
9343321  2003-12-29 CZR      500.000        11.340000      NULL      NULL       0  
9343321  2004-02-09 SNUS     1000.000       7.710000       NULL      NULL       8  
9343321  2004-05-11 VTSS     500.000        5.510000       NULL      NULL       9  
9343321  2004-07-12 SEBL     500.000        8.450000       NULL      NULL       6  

(22 row(s) affected)
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  

HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2026 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News