I loved the historical data since it would allow me to play with my filter parameters without finding out -the-expensive-way that the filter was no-good, but I don't seem to be able to find it.
The usual suspect would be the 'Completed Notes Only' in the filter definition screen. Then I re-load the data and there is no visible change. I downloaded the data provided by lending club into a database and it is VERY DIRTY! periods and commas are generously embedded into numbers so that the data can only be loaded as strings. It feels like someone typed the data manually in which does naturally make no sense with that amount of data. There will have been some manual work done on each loan, but the interest, the loan amount, the interest paid, should be represented as numeric value.
IF there is a way to explore different filter scenarios with clean(er) data and your system has those already, that would be grand. Either through your program's filters or exportable I would love to try 'playing' (since this is intended for REAL money investment, the term 'playing' is very loosely used) with different settings. This without having bound my -limited- financial resources in trial-and- ERROR attempts would be absolutely grand!
Is there a way to get my virtual hands on this data through your system, and if there is, how would I do that. I see the problem of having millions of rows with a too wide filter on the historical data since 2007, but with a limit of returned rows or date limits or summarizing or in its simplest way refusal to deliver rows once the limit has been reached would probably work.
In any case, since it does not seem to return completed loans, what does the term 'Completed Notes Only' mean and most importantly can I see the success or failure in reaching a decent ROI through hind-sight = what-if scenarios = on historical data ?
with kind regards and very impressed
g strubinsky
The usual suspect would be the 'Completed Notes Only' in the filter definition screen. Then I re-load the data and there is no visible change. I downloaded the data provided by lending club into a database and it is VERY DIRTY! periods and commas are generously embedded into numbers so that the data can only be loaded as strings. It feels like someone typed the data manually in which does naturally make no sense with that amount of data. There will have been some manual work done on each loan, but the interest, the loan amount, the interest paid, should be represented as numeric value.
IF there is a way to explore different filter scenarios with clean(er) data and your system has those already, that would be grand. Either through your program's filters or exportable I would love to try 'playing' (since this is intended for REAL money investment, the term 'playing' is very loosely used) with different settings. This without having bound my -limited- financial resources in trial-and- ERROR attempts would be absolutely grand!
Is there a way to get my virtual hands on this data through your system, and if there is, how would I do that. I see the problem of having millions of rows with a too wide filter on the historical data since 2007, but with a limit of returned rows or date limits or summarizing or in its simplest way refusal to deliver rows once the limit has been reached would probably work.
In any case, since it does not seem to return completed loans, what does the term 'Completed Notes Only' mean and most importantly can I see the success or failure in reaching a decent ROI through hind-sight = what-if scenarios = on historical data ?
with kind regards and very impressed
g strubinsky