alpacahq / Alpaca-API

The Alpaca API is a developer interface for trading operations and market data reception through the Alpaca platform.
https://alpaca.markets/
143 stars 13 forks source link

Rest API get_portfolio_history returns incorrect data beyond 1 day #223

Open tepchan opened 2 years ago

tepchan commented 2 years ago

When requesting get_portfolio_history intraday equity appears to be calculated by profit_loss added to base_value. When requesting more than one day, intraday profit_loss returns are relative to their respective day base_value, however equity appears to be calculated by adding profit_loss to the initial day base_value. The result is incorrect equity values when requesting timeframes <1 day on periods >1 day.

To Reproduce image

Crude client side fix example below. Not sure if this comes from the raw api output or is isolated to the python rest api, but in either case there are probably more efficient ways to do it.

data = api.get_portfolio_history(period='4D', timeframe='1Min') history = np.array(data.equity)

base_values = np.array(api.get_portfolio_history(period='5D', timeframe='1D').equity) base_values = (base_values - base_values[0])[:-1]

for bvd in range(len(base_values)): history[(bvd 391):(bvd 391)+391] = history[(bvd 391):(bvd 391)+391] + base_values[bvd]

mjKosmic commented 9 months ago

I'm still seeing issues around this as well. Has this been triaged as a low priority?