Skip to content

Instantly share code, notes, and snippets.

@uncletammy

uncletammy/gist:469e198c1e2c4595e380

Last active August 29, 2015 14:07
Show Gist options
  • Save uncletammy/469e198c1e2c4595e380 to your computer and use it in GitHub Desktop.
Save uncletammy/469e198c1e2c4595e380 to your computer and use it in GitHub Desktop.
Download ZIP
rollingReturn
Raw
gistfile1.txt
{ identifier: '^gspc',
dataSource: 'yahoo',
lastFetchedMonthlyData: '2014-10-22T17:42:38.450Z',
createdAt: '2014-10-22T17:42:14.828Z',
updatedAt: '2014-10-22T17:42:38.473Z',
id: 34,
rollingReturns:
{ threeYear:
{ returns: { 'year-1': 10.37066, 'year-2': 22.37496, 'year-3': 12.51932 },
growth: { 'year-1': 8962.93, 'year-2': 6957.48, 'year-3': 6086.45 },
aar: 15.08831,
cumulative: 64.299,
standardDeviation: 9.093,
startingDollars: 6086.45 },
oneYear:
{ returns:
{ '2014 - Q3': 0.64187,
'2014 - Q2': 2.50087,
'2014 - Q1': 5.62498,
'2013 - Q4': 1.60294 },
growth:
{ '2014 - Q3': 9935.81,
'2014 - Q2': 9687.33,
'2014 - Q1': 9142.42,
'2013 - Q4': 8995.87 },
aar: 2.59267,
cumulative: 11.162,
standardDeviation: 8.122,
startingDollars: 8995.87 },
fiveYear:
{ returns:
{ 'year-1': 10.37066,
'year-2': 22.37496,
'year-3': 12.51932,
'year-4': 7.0997,
'year-5': 15.01069 },
growth:
{ 'year-1': 8962.93,
'year-2': 6957.48,
'year-3': 6086.45,
'year-4': 5654.33,
'year-5': 4805.58 },
aar: 13.47507,
cumulative: 108.091,
standardDeviation: 13.084,
startingDollars: 4805.58 },
tenYear:
{ returns:
{ 'year-1': 10.37066,
'year-2': 22.37496,
'year-3': 12.51932,
'year-4': 7.0997,
'year-5': 15.01069,
'year-6': 9.36539,
'year-7': -44.01821,
'year-8': 12.07965,
'year-9': 13.50089,
'year-10': 6.92036 },
growth:
{ 'year-1': 8962.93,
'year-2': 6957.48,
'year-3': 6086.45,
'year-4': 5654.33,
'year-5': 4805.58,
'year-6': 4355.52,
'year-7': 6272.74,
'year-8': 5515.01,
'year-9': 4770.44,
'year-10': 4440.31 },
aar: 6.52234,
cumulative: 125.21,
standardDeviation: 14.67,
startingDollars: 4440.31 },
ytd:
{ returns:
{ '1': -3.55828,
'2': 4.3117,
'3': 0.69321,
'4': 0.62007,
'5': 2.10302,
'6': 1.90583,
'7': -1.50798,
'8': 3.76553,
'9': -1.55138,
'10': -1.57228 },
growth:
{ '1': 10355.83,
'2': 9909.32,
'3': 9840.62,
'4': 9779.6,
'5': 9573.94,
'6': 9391.47,
'7': 9533.1,
'8': 9174.12,
'9': 9316.45,
'10': 9462.93 },
aar: 0.52094,
cumulative: 5.676,
standardDeviation: 8.399,
startingDollars: 9462.93 },
monthly:
{ returns:
[ { year: 2014, month: 9, value: -1.57228 },
{ year: 2014, month: 8, value: -1.55138 },
{ year: 2014, month: 7, value: 3.76553 },
{ year: 2014, month: 6, value: -1.50798 },
{ year: 2014, month: 5, value: 1.90583 },
{ year: 2014, month: 4, value: 2.10302 },
{ year: 2014, month: 3, value: 0.62007 },
{ year: 2014, month: 2, value: 0.69321 },
{ year: 2014, month: 1, value: 4.3117 },
{ year: 2014, month: 0, value: -3.55828 },
{ year: 2013, month: 11, value: 2.35628 },
{ year: 2013, month: 10, value: 2.80494 },
{ year: 2013, month: 9, value: 4.45957 },
{ year: 2013, month: 8, value: 2.97494 },
{ year: 2013, month: 7, value: -3.1298 },
{ year: 2013, month: 6, value: 4.94621 },
{ year: 2013, month: 5, value: -1.49993 },
{ year: 2013, month: 4, value: 2.07627 },
{ year: 2013, month: 3, value: 1.80857 },
{ year: 2013, month: 2, value: 3.59877 },
{ year: 2013, month: 1, value: 1.10606 },
{ year: 2013, month: 0, value: 5.0428 },
{ year: 2012, month: 11, value: 0.70683 },
{ year: 2012, month: 10, value: 0.28467 },
{ year: 2012, month: 9, value: -1.97894 },
{ year: 2012, month: 8, value: 2.4236 },
{ year: 2012, month: 7, value: 1.97633 },
{ year: 2012, month: 6, value: 1.25976 },
{ year: 2012, month: 5, value: 3.95549 },
{ year: 2012, month: 4, value: -6.26506 },
{ year: 2012, month: 3, value: -0.74974 },
{ year: 2012, month: 2, value: 3.13323 },
{ year: 2012, month: 1, value: 4.05894 },
{ year: 2012, month: 0, value: 4.3583 },
{ year: 2011, month: 11, value: 0.85327 },
{ year: 2011, month: 10, value: -0.50586 },
{ year: 2011, month: 9, value: 10.7723 },
{ year: 2011, month: 8, value: -7.1762 },
{ year: 2011, month: 7, value: -5.6791 },
{ year: 2011, month: 6, value: -2.14744 },
{ year: 2011, month: 5, value: -1.82575 },
{ year: 2011, month: 4, value: -1.35009 },
{ year: 2011, month: 3, value: 2.84953 },
{ year: 2011, month: 2, value: -0.10473 },
{ year: 2011, month: 1, value: 3.19565 },
{ year: 2011, month: 0, value: 2.26455 },
{ year: 2010, month: 11, value: 6.53 },
{ year: 2010, month: 10, value: -0.22902 },
{ year: 2010, month: 9, value: 3.68559 },
{ year: 2010, month: 8, value: 8.75511 },
{ year: 2010, month: 7, value: -4.74491 },
{ year: 2010, month: 6, value: 6.87778 },
{ year: 2010, month: 5, value: -5.38823 },
{ year: 2010, month: 4, value: -8.19759 },
{ year: 2010, month: 3, value: 1.47593 },
{ year: 2010, month: 2, value: 5.87963 },
{ year: 2010, month: 1, value: 2.85136 },
{ year: 2010, month: 0, value: -3.69742 },
{ year: 2009, month: 11, value: 1.77705 },
{ year: 2009, month: 10, value: 5.73639 },
{ year: 2009, month: 9, value: -1.97619 },
{ year: 2009, month: 8, value: 3.57233 },
{ year: 2009, month: 7, value: 3.35601 },
{ year: 2009, month: 6, value: 7.41417 },
{ year: 2009, month: 5, value: 0.01958 },
{ year: 2009, month: 4, value: 5.30814 },
{ year: 2009, month: 3, value: 9.3925 },
{ year: 2009, month: 2, value: 8.54045 },
{ year: 2009, month: 1, value: -10.99312 },
{ year: 2009, month: 0, value: -8.56573 },
{ year: 2008, month: 11, value: 0.78215 },
{ year: 2008, month: 10, value: -7.4849 },
{ year: 2008, month: 9, value: -16.94245 },
{ year: 2008, month: 8, value: -9.07914 },
{ year: 2008, month: 7, value: 1.21905 },
{ year: 2008, month: 6, value: -0.98593 },
{ year: 2008, month: 5, value: -8.59623 },
{ year: 2008, month: 4, value: 1.06741 },
{ year: 2008, month: 3, value: 4.75466 },
{ year: 2008, month: 2, value: -0.59595 },
{ year: 2008, month: 1, value: -3.47611 },
{ year: 2008, month: 0, value: -6.11634 },
{ year: 2007, month: 11, value: -0.86284 },
{ year: 2007, month: 10, value: -4.40434 },
{ year: 2007, month: 9, value: 1.48223 },
{ year: 2007, month: 8, value: 3.5794 },
{ year: 2007, month: 7, value: 1.28635 },
{ year: 2007, month: 6, value: -3.19819 },
{ year: 2007, month: 5, value: -1.78163 },
{ year: 2007, month: 4, value: 3.25492 },
{ year: 2007, month: 3, value: 4.32906 },
{ year: 2007, month: 2, value: 0.99799 },
{ year: 2007, month: 1, value: -2.18461 },
{ year: 2007, month: 0, value: 1.4059 },
{ year: 2006, month: 11, value: 1.26157 },
{ year: 2006, month: 10, value: 1.64666 },
{ year: 2006, month: 9, value: 3.1508 },
{ year: 2006, month: 8, value: 2.45662 },
{ year: 2006, month: 7, value: 2.12742 },
{ year: 2006, month: 6, value: 0.50858 },
{ year: 2006, month: 5, value: 0.00866 },
{ year: 2006, month: 4, value: -3.09169 },
{ year: 2006, month: 3, value: 1.21556 },
{ year: 2006, month: 2, value: 1.10958 },
{ year: 2006, month: 1, value: 0.0453 },
{ year: 2006, month: 0, value: 2.54668 },
{ year: 2005, month: 11, value: -0.09523 },
{ year: 2005, month: 10, value: 3.51861 },
{ year: 2005, month: 9, value: -1.77407 },
{ year: 2005, month: 8, value: 0.69489 },
{ year: 2005, month: 7, value: -1.1222 },
{ year: 2005, month: 6, value: 3.59682 },
{ year: 2005, month: 5, value: -0.01426 },
{ year: 2005, month: 4, value: 2.9952 },
{ year: 2005, month: 3, value: -2.01085 },
{ year: 2005, month: 2, value: -1.91176 },
{ year: 2005, month: 1, value: 1.89033 },
{ year: 2005, month: 0, value: -2.52904 },
{ year: 2004, month: 11, value: 3.24581 },
{ year: 2004, month: 10, value: 3.85949 } ] } } }
@uncletammy
Copy link
Author

First: Index.create({ identifier: '^gspc', dataSource: 'yahoo' }).exec(console.log);

Then: IndexDataService.updateIndexReturns(console.log);

Then: Index.findOne().exec(function(e,t){console.log(require('util').inspect(t.toJSON(),false,null))});

@uncletammy
Copy link
Author

{ identifier: '^gspc',
dataSource: 'yahoo',
lastFetchedMonthlyData: '2014-10-21T20:40:31.228Z',
createdAt: '2014-10-21T20:39:52.958Z',
updatedAt: '2014-10-21T20:40:31.244Z',
id: 26,
rollingReturns:
{ threeYear:
{ returns: { 'year-1': 8.48099, 'year-2': 22.375, 'year-3': 12.51934 },
growth: { 'year-1': 9151.9, 'year-2': 7104.16, 'year-3': 6214.77 },
aar: 14.45844,
cumulative: 60.907,
standardDeviation: 9.349,
startingDollars: 6214.77 },
oneYear:
{ returns:
{ '2014 - Q3': -1.24782,
'2014 - Q2': 2.50087,
'2014 - Q1': 5.625,
'2013 - Q4': 1.60294 },
growth:
{ '2014 - Q3': 10124.78,
'2014 - Q2': 9871.57,
'2014 - Q1': 9316.3,
'2013 - Q4': 9166.96 },
aar: 2.12025,
cumulative: 9.087,
standardDeviation: 8.857,
startingDollars: 9166.96 },
fiveYear:
{ returns:
{ 'year-1': 8.48099,
'year-2': 22.375,
'year-3': 12.51934,
'year-4': 7.09971,
'year-5': 15.01071 },
growth:
{ 'year-1': 9151.9,
'year-2': 7104.16,
'year-3': 6214.77,
'year-4': 5773.54,
'year-5': 4906.89 },
aar: 13.09715,
cumulative: 103.795,
standardDeviation: 13.188,
startingDollars: 4906.89 },
tenYear:
{ returns:
{ 'year-1': 8.48099,
'year-2': 22.375,
'year-3': 12.51934,
'year-4': 7.09971,
'year-5': 15.01071,
'year-6': 9.36541,
'year-7': -44.01825,
'year-8': 12.07969,
'year-9': 13.50092,
'year-10': 6.92035 },
growth:
{ 'year-1': 9151.9,
'year-2': 7104.16,
'year-3': 6214.77,
'year-4': 5773.54,
'year-5': 4906.89,
'year-6': 4447.34,
'year-7': 6404.98,
'year-8': 5631.28,
'year-9': 4871,
'year-10': 4533.91 },
aar: 6.33339,
cumulative: 120.56,
standardDeviation: 14.709,
startingDollars: 4533.91 },
ytd:
{ returns:
{ '1': -3.55829,
'2': 4.3117,
'3': 0.69322,
'4': 0.62008,
'5': 2.10303,
'6': 1.90583,
'7': -1.50799,
'8': 3.76553,
'9': -1.55139,
'10': -3.46197 },
growth:
{ '1': 10355.83,
'2': 9909.32,
'3': 9840.62,
'4': 9779.6,
'5': 9573.94,
'6': 9391.47,
'7': 9533.1,
'8': 9174.12,
'9': 9316.45,
'10': 9638.98 },
aar: 0.33198,
cumulative: 3.745,
standardDeviation: 9.16,
startingDollars: 9638.98 },
monthly:
{ returns:
[ { year: 2014, month: 10, value: -3.46197 },
{ year: 2014, month: 9, value: -1.55139 },
{ year: 2014, month: 8, value: 3.76553 },
{ year: 2014, month: 7, value: -1.50799 },
{ year: 2014, month: 6, value: 1.90583 },
{ year: 2014, month: 5, value: 2.10303 },
{ year: 2014, month: 4, value: 0.62008 },
{ year: 2014, month: 3, value: 0.69322 },
{ year: 2014, month: 2, value: 4.3117 },
{ year: 2014, month: 1, value: -3.55829 },
{ year: 2013, month: 12, value: 2.35628 },
{ year: 2013, month: 11, value: 2.80495 },
{ year: 2013, month: 10, value: 4.45958 },
{ year: 2013, month: 9, value: 2.97495 },
{ year: 2013, month: 8, value: -3.1298 },
{ year: 2013, month: 7, value: 4.94621 },
{ year: 2013, month: 6, value: -1.49993 },
{ year: 2013, month: 5, value: 2.07628 },
{ year: 2013, month: 4, value: 1.80858 },
{ year: 2013, month: 3, value: 3.59878 },
{ year: 2013, month: 2, value: 1.10606 },
{ year: 2013, month: 1, value: 5.04281 },
{ year: 2012, month: 12, value: 0.70683 },
{ year: 2012, month: 11, value: 0.28467 },
{ year: 2012, month: 10, value: -1.97894 },
{ year: 2012, month: 9, value: 2.42361 },
{ year: 2012, month: 8, value: 1.97634 },
{ year: 2012, month: 7, value: 1.25976 },
{ year: 2012, month: 6, value: 3.95549 },
{ year: 2012, month: 5, value: -6.26507 },
{ year: 2012, month: 4, value: -0.74975 },
{ year: 2012, month: 3, value: 3.13324 },
{ year: 2012, month: 2, value: 4.05894 },
{ year: 2012, month: 1, value: 4.3583 },
{ year: 2011, month: 12, value: 0.85328 },
{ year: 2011, month: 11, value: -0.50586 },
{ year: 2011, month: 10, value: 10.7723 },
{ year: 2011, month: 9, value: -7.1762 },
{ year: 2011, month: 8, value: -5.67911 },
{ year: 2011, month: 7, value: -2.14744 },
{ year: 2011, month: 6, value: -1.82575 },
{ year: 2011, month: 5, value: -1.35009 },
{ year: 2011, month: 4, value: 2.84954 },
{ year: 2011, month: 3, value: -0.10473 },
{ year: 2011, month: 2, value: 3.19566 },
{ year: 2011, month: 1, value: 2.26456 },
{ year: 2010, month: 12, value: 6.53001 },
{ year: 2010, month: 11, value: -0.22903 },
{ year: 2010, month: 10, value: 3.68559 },
{ year: 2010, month: 9, value: 8.75511 },
{ year: 2010, month: 8, value: -4.74492 },
{ year: 2010, month: 7, value: 6.87778 },
{ year: 2010, month: 6, value: -5.38824 },
{ year: 2010, month: 5, value: -8.19759 },
{ year: 2010, month: 4, value: 1.47593 },
{ year: 2010, month: 3, value: 5.87964 },
{ year: 2010, month: 2, value: 2.85137 },
{ year: 2010, month: 1, value: -3.69743 },
{ year: 2009, month: 12, value: 1.77706 },
{ year: 2009, month: 11, value: 5.7364 },
{ year: 2009, month: 10, value: -1.9762 },
{ year: 2009, month: 9, value: 3.57234 },
{ year: 2009, month: 8, value: 3.35602 },
{ year: 2009, month: 7, value: 7.41418 },
{ year: 2009, month: 6, value: 0.01958 },
{ year: 2009, month: 5, value: 5.30814 },
{ year: 2009, month: 4, value: 9.39251 },
{ year: 2009, month: 3, value: 8.54045 },
{ year: 2009, month: 2, value: -10.99312 },
{ year: 2009, month: 1, value: -8.56573 },
{ year: 2008, month: 12, value: 0.78216 },
{ year: 2008, month: 11, value: -7.4849 },
{ year: 2008, month: 10, value: -16.94245 },
{ year: 2008, month: 9, value: -9.07915 },
{ year: 2008, month: 8, value: 1.21905 },
{ year: 2008, month: 7, value: -0.98594 },
{ year: 2008, month: 6, value: -8.59624 },
{ year: 2008, month: 5, value: 1.06742 },
{ year: 2008, month: 4, value: 4.75467 },
{ year: 2008, month: 3, value: -0.59596 },
{ year: 2008, month: 2, value: -3.47612 },
{ year: 2008, month: 1, value: -6.11635 },
{ year: 2007, month: 12, value: -0.86285 },
{ year: 2007, month: 11, value: -4.40434 },
{ year: 2007, month: 10, value: 1.48223 },
{ year: 2007, month: 9, value: 3.5794 },
{ year: 2007, month: 8, value: 1.28636 },
{ year: 2007, month: 7, value: -3.19819 },
{ year: 2007, month: 6, value: -1.78163 },
{ year: 2007, month: 5, value: 3.25492 },
{ year: 2007, month: 4, value: 4.32907 },
{ year: 2007, month: 3, value: 0.998 },
{ year: 2007, month: 2, value: -2.18461 },
{ year: 2007, month: 1, value: 1.40591 },
{ year: 2006, month: 12, value: 1.26158 },
{ year: 2006, month: 11, value: 1.64666 },
{ year: 2006, month: 10, value: 3.1508 },
{ year: 2006, month: 9, value: 2.45663 },
{ year: 2006, month: 8, value: 2.12743 },
{ year: 2006, month: 7, value: 0.50858 },
{ year: 2006, month: 6, value: 0.00866 },
{ year: 2006, month: 5, value: -3.09169 },
{ year: 2006, month: 4, value: 1.21557 },
{ year: 2006, month: 3, value: 1.10958 },
{ year: 2006, month: 2, value: 0.04531 },
{ year: 2006, month: 1, value: 2.54668 },
{ year: 2005, month: 12, value: -0.09524 },
{ year: 2005, month: 11, value: 3.51861 },
{ year: 2005, month: 10, value: -1.77407 },
{ year: 2005, month: 9, value: 0.69489 },
{ year: 2005, month: 8, value: -1.1222 },
{ year: 2005, month: 7, value: 3.59682 },
{ year: 2005, month: 6, value: -0.01427 },
{ year: 2005, month: 5, value: 2.9952 },
{ year: 2005, month: 4, value: -2.01086 },
{ year: 2005, month: 3, value: -1.91176 },
{ year: 2005, month: 2, value: 1.89034 },
{ year: 2005, month: 1, value: -2.52904 },
{ year: 2004, month: 12, value: 3.24581 },
{ year: 2004, month: 11, value: 3.85949 } ] } } }

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment