-
Notifications
You must be signed in to change notification settings - Fork 0
/
Program.cs
120 lines (106 loc) · 4.55 KB
/
Program.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace InvestmentBuilder
{
class Program
{
/// <summary>
/// build asset sheet for current month
/// </summary>
/// <param name="bTest"></param>
/// <param name="path"></param>
static void AssetSheetBuilder(IInvestmentFactory factory, Trades trades, DateTime valuationDate)
{
try
{
var recordBuilder = factory.CreateInvestmentRecordBuilder();
var dataReader = factory.CreateCompanyDataReader();
var assetWriter = factory.CreateAssetStatementWriter();
var cashAccountReader = factory.CreateCashAccountReader();
var dtPreviousValuation = cashAccountReader.GetPreviousValuationDate();
//first extract the cash account data
var cashAccountData = cashAccountReader.GetCashAccountData(valuationDate, dtPreviousValuation);
//parse the trade file for any trades for this month and update the investment record
//var trades = TradeLoader.GetTrades(tradeFile);
recordBuilder.BuildInvestmentRecords(trades, cashAccountData, valuationDate);
//now extract the latest data from the investment record
var lstData = dataReader.GetCompanyData(valuationDate, dtPreviousValuation).ToList();
foreach (var val in lstData)
{
Console.WriteLine("{0} : {1} : {2} : {3} : {4}", val.sName, val.dSharePrice, val.dNetSellingValue, val.dMonthChange, val.dMonthChangeRatio);
}
//finally, build the asset statement
assetWriter.WriteAssetStatement(lstData, cashAccountData, dtPreviousValuation, valuationDate);
factory.CommitData();
}
finally
{
//app.Workbooks.Close();
factory.Close();
}
}
//static void InvestmentRecordBuilder()
//{
// //RecordBuilder builder = new RecordBuilder();
// //builder.DownloadData("SVT.L");
// double dClosing;
// string symbol = "SVT.L";
// if (MarketDataService.TryGetClosingPrice(symbol, "SEVERN TRENT", "LONDON", 100d,out dClosing))
// {
// Console.WriteLine("closing price for {0} : {1}", symbol, dClosing);
// }
//}
//static void LoadTrades()
//{
// var trades = TradeLoader.GetTrades("D:\\Projects\\InvestmentBuilder\\Trades.xml");
// foreach(var trade in trades.Buys)
// {
// Console.WriteLine("name: {0}, number {1}, total cost {2}", trade.Name, trade.Number, trade.TotalCost);
// }
//}
static void Main(string[] args)
{
if(args.Length == 0)
{
Console.WriteLine(@"syntax: InvestmentBuilder <-p:path> <-t> <-d:Valuation Date>. where -t = test -p = path and -d specifies valuation date");
return;
}
string path = @"C:\Users\Guy\Documents\Guy\Investments\Investment Club\accounts\";
bool bTest = false;
DateTime? dtValuationDate = null;
foreach(var arg in args)
{
if(arg[0] == '-')
{
switch(arg[1])
{
case 'p':
if (arg[2] == ':')
path = arg.Substring(3);
break;
case 't':
bTest = true;
break;
case 'd':
if (arg[2] == ':')
dtValuationDate = DateTime.Parse(arg.Substring(3));
break;
}
}
}
if (path.Last() != '\\')
{
path = path + "\\";
}
//create investment factory for either excel or database
var investmentFactory = new ExcelInvestmentFactory(path, bTest);
//load in any trades from the trades file
string tradeFile = string.Format("{0}Trades.xml", path);
var trades = TradeLoader.GetTrades(tradeFile);
AssetSheetBuilder(investmentFactory, trades, dtValuationDate.HasValue ? dtValuationDate.Value : DateTime.Today);
}
}
}