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
|
package edu.brown.cs.student;
import edu.brown.cs.student.term.DatabaseQuerier;
import edu.brown.cs.student.term.hub.Holder;
import edu.brown.cs.student.term.hub.HubSearch;
import edu.brown.cs.student.term.hub.LinkMapper;
import edu.brown.cs.student.term.profit.ProfitCalculation;
import edu.brown.cs.student.term.profit.StockHolding;
import edu.brown.cs.student.term.repl.commands.SetupCommand;
import edu.brown.cs.student.term.trade.Trade;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import java.time.LocalDate;
import java.util.List;
import java.sql.Date;
import java.time.Instant;
import java.util.Map;
import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertTrue;
public class ProfitCalculationTest {
/**
* these should span the entire mock dataset
*/
//12 am on 3/11 in UTC
private Instant start = Instant.parse("2021-03-11T05:00:00.00Z");
//12 am on 3/28 in UTC
private Instant end = Instant.parse("2021-03-28T05:00:00.00Z");
private DatabaseQuerier db;
@Before
public void setUp() {
try {
db = new DatabaseQuerier("data/lil_mock.sqlite3");
} catch (Exception e) {
System.out.println("DBQuerier Test, couldn't connect to db???");
}
}
@After
public void tearDown() {
db = null;
}
@Test
public void testBasicTrades() {
setUp();
ProfitCalculation profitCalculation =
new ProfitCalculation(DatabaseQuerier.getConn(), "Don", new Date(1518010558000l),
new Date(1618698807000l));
//price of GME at end time is 154.69
List<StockHolding> trade = profitCalculation.getHoldingsList();
//buy with no sell
assertEquals(trade.get(0).getUnrealizedGain(), 3842.25,.25);
assertEquals(trade.get(0).getRealizedGain(), 0, .01);
profitCalculation = new ProfitCalculation(DatabaseQuerier.getConn(), "Don", new Date(1618234200000l),
new Date(1618814264000l));
assertEquals(profitCalculation.compareToSP500(), .01464, .001);
}
}
|
