# Tag Info

1

Effective PA is dependent on the correct description of the investment process. I am not sure, from what you say, what exactly is your investment process. But let me presume that it is the following: You have chosen the S&P500 as your benchmark. You first distributed your money among sectors. (That you gave many sectors zero weight is not relevant to the ...

1

You actually need to consider a 0 return on the periods with no holdings (during that period volatility is 0 and you have a negative return due to the opportunity cost of not holding risk free debt). From that you can compute your daily sharpe ratio and then multiply by $252^{0.5}$ as you mention.

1

Apache Cassandra would be a good fit for storing real-time intraday data. It's a partitioned row store, where rows are organized into table using a partition key. It you use a schema where you store data for one ticker per row with partitioning by day or month (it has a limit of 2B records in a row), the operations in your questions would be very performant....

Only top voted, non community-wiki answers of a minimum length are eligible