LendingClub has an useful tool to see my return vs. other people's return in 'Understanding Your Returns'. The nice graph plots all other portfolio's return by age and highlights my portfolio return. You can filter by minimum number of loans in portfolio and portfolio concentration.
It is a very useful tool, but I would like to get raw numbers and calculate statistics like my ranking etc. Use firefox's element inspection tool I can see that the graph is plotted as many points. These points can be extracted with simple javascript:
circles = document.getElementsByClassName("point circleAll");
similar_circles = document.getElementsByClassName("point circleSimilar");
my_circle = document.getElementsByClassName("point circleMe");
points = "";
points = points + my_circle[0].getAttribute("cx") + "," + my_circle[0].getAttribute("cy") + "\r";
for(i=0; i < similar_circles.length; ++i) {
points = points + similar_circles[i].getAttribute("cx") + "," + similar_circles[i].getAttribute("cy")+"\r";
};
win = window.open("", "test");
win.document.body.innerHTML = points;
point coordinates will be displayed in a new window and subsequently save to csv file. Note those coordinates are not year & percentage return but raw coordinate; and y coordinate points downward--higher y means lower return.
After some simple calculation, it turns out my portfolio return is better than 95% of others of similar aged portfolio.
My model driven automated loan selector works well for 2+ years.
No comments:
Post a Comment