Alpaca w/ Google Sheets - Public Example
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
How to Use Thisalpaca.marketsAPI DocCommunityGet API Key
2
Result
{
"code": 40310000,
"message": "market is closed"
}
3
4
5
6
7
8
AccountOrderSidebuy
9
ID
e05e75cf-d99c-47dc-b1b2-89f0b340cbdb
SymbolAMD
10
Buying Power$164.16Qty1
11
Cash$164.16Typemarket
12
Portfolio Value$453.57Time In Forcegtc
13
StatusACTIVELimit Priice
14
Stop Price
15
Positions
16
SymbolSharesMarket ValueCost BasisUnrealized P/LUnrealized %Last Price
17
ABUS1$4.72$4.40$0.327.27%$4.72
18
AGFS1$4.25$4.05$0.204.94%$4.25
19
APEN3$14.10$12.15$1.9516.05%$4.70
20
ASPN1$3.15$3.14$0.010.32%$3.15
21
ASV8$24.80$26.10-$1.30-4.98%$3.10
22
ATTO1$4.81$5.10-$0.29-5.69%$4.81
23
AVDL2$6.00$6.50-$0.50-7.69%$3.00
24
BBGI1$4.89$5.35-$0.46-8.60%$4.89
25
CUE3$14.46$14.85-$0.39-2.63%$4.82
26
CVV2$9.18$8.85$0.333.74%$4.59
27
FTNW4$17.08$19.90-$2.82-14.17%$4.27
28
HHS1$3.16$3.50-$0.34-9.71%$3.16
29
IMH4$15.40$16.30-$0.90-5.52%$3.85
30
KEG2$11.84$13.85-$2.01-14.51%$5.92
31
LMB2$8.40$8.90-$0.50-5.62%$4.20
32
MFIN1$5.97$5.90$0.071.19%$5.97
33
MHH1$6.48$6.15$0.335.37%$6.48
34
MRSN3$15.75$16.75-$1.00-5.97%$5.25
35
MXC6$22.08$23.20-$1.12-4.83%$3.68
36
NES1$9.16$9.15$0.010.11%$9.16
37
NL1$4.31$4.35-$0.04-0.92%$4.31
38
ORN1$4.28$4.25$0.030.71%$4.28
39
QBAK3$15.15$15.49-$0.34-2.19%$5.05
40
RMBL2$12.82$11.85$0.978.19%$6.41
41
ROSE1$3.77$3.80-$0.03-0.79%$3.77
42
SAEX1$3.88$3.93-$0.05-1.27%$3.88
43
SCX3$14.85$14.50$0.352.41%$4.95
44
SORL1$2.88$2.90-$0.02-0.69%$2.88
45
TRIB6$17.28$17.90-$0.62-3.46%$2.88
46
XELA1$4.51$4.70-$0.19-4.04%$4.51
47
totaltotaltotalaveragemedian
48
$289.41$297.76-$8.35-1.77%$4.41
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
Loading...
Main menu