russs123 / ma_crossover Goto Github PK

Running the script as is returns a ValueError on the 8th cell.

`---------------------------------------------------------------------------
ValueError Traceback (most recent call last)
File ~\miniconda3\envs\quant\lib\site-packages\pandas\core\indexes\range.py:385, in RangeIndex.get_loc(self, key, method, tolerance)
384 try:
--> 385 return self._range.index(new_key)
386 except ValueError as err:

ValueError: -1 is not in range

The above exception was the direct cause of the following exception:

KeyError Traceback (most recent call last)
c:\Users\Azkar\OneDrive\Programming\Jupyter_Lab_Projects\moving_avg_crossover.ipynb Cell 8' in <cell line: 2>()
1 #calculate metrics
----> 2 bench_return = round(((price.Bench_Bal[-1] / price.Bench_Bal[0]) - 1) * 100, 2)
3 bench_cagr = round((((price.Bench_Bal[-1] / price.Bench_Bal[0]) ** (1/YEARS))-1) * 100, 2)
5 print(bench_return)

File ~\miniconda3\envs\quant\lib\site-packages\pandas\core\series.py:958, in Series.getitem(self, key)
955 return self._values[key]
957 elif key_is_scalar:
--> 958 return self._get_value(key)
960 if is_hashable(key):
961 # Otherwise index.get_value will raise InvalidIndexError
962 try:
963 # For labels that don't resolve as scalars like tuples and frozensets

File ~\miniconda3\envs\quant\lib\site-packages\pandas\core\series.py:1069, in Series._get_value(self, label, takeable)
1066 return self._values[label]
1068 # Similar to Index.get_value, but we do not fall back to positional
-> 1069 loc = self.index.get_loc(label)
1070 return self.index._get_values_for_loc(self, loc, label)

File ~\miniconda3\envs\quant\lib\site-packages\pandas\core\indexes\range.py:387, in RangeIndex.get_loc(self, key, method, tolerance)
385 return self._range.index(new_key)
386 except ValueError as err:
--> 387 raise KeyError(key) from err
388 self._check_indexing_error(key)
389 raise KeyError(key)

KeyError: -1`