{"id":911,"date":"2020-02-25T23:52:07","date_gmt":"2020-02-26T04:52:07","guid":{"rendered":"http:\/\/dfabclass.com\/aa2020\/?p=911"},"modified":"2020-02-25T23:52:09","modified_gmt":"2020-02-26T04:52:09","slug":"trading-to-excel-to-blobs","status":"publish","type":"post","link":"http:\/\/dfabclass.com\/aa2020\/trading-to-excel-to-blobs\/","title":{"rendered":"Trading to Excel to Blobs"},"content":{"rendered":"\n<p>For my project to showcase the ability to turn Excel spreadsheet data in to physical form on Grasshopper I decided to leverage part of my data-set of trades from my Crypto bots. Just an export of the trading pair, time, price bought and sold and amount. I got the percents of these then separated everything into different trees. From there I used some cool plugins I found, one called Dodo for math and another to implement Simplex noise onto spheres. <\/p>\n\n\n\n<p>I took the data and used to to calculate weighted averages and standard deviations, to represent how much that coin normally makes me and then how volatile it is, this was fed into the appropriate plugins for the noise and applied to the spheres. From here to give the sphere some Pizazz, so I made the normals correspond to a color. The bigger the blob the higher the average return, the spikier the blob the more volatile the average return is.<br><\/p>\n\n\n\n<div class=\"wp-block-coblocks-gallery-masonry alignwide\"><div class=\"coblocks-gallery has-border-radius-5 has-caption-style-dark has-gutter has-lightbox\"><ul class=\"has-grid-xlrg has-gutter-15 has-gutter-mobile-15\"><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img loading=\"lazy\" decoding=\"async\" width=\"515\" height=\"767\" src=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/1tr.png\" alt=\"\" data-id=\"912\" data-link=\"http:\/\/dfabclass.com\/aa2020\/?attachment_id=912\" class=\"wp-image-912\" srcset=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/1tr.png 515w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/1tr-201x300.png 201w\" sizes=\"auto, (max-width: 515px) 100vw, 515px\" \/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"419\" src=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/2tr-1024x419.png\" alt=\"\" data-id=\"913\" data-link=\"http:\/\/dfabclass.com\/aa2020\/?attachment_id=913\" class=\"wp-image-913\" srcset=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/2tr-1024x419.png 1024w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/2tr-300x123.png 300w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/2tr-768x314.png 768w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/2tr.png 1214w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"323\" src=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/3tr-1024x323.png\" alt=\"\" data-id=\"914\" data-link=\"http:\/\/dfabclass.com\/aa2020\/?attachment_id=914\" class=\"wp-image-914\" srcset=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/3tr-1024x323.png 1024w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/3tr-300x95.png 300w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/3tr-768x242.png 768w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/3tr.png 1491w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"660\" src=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/4tr-1024x660.png\" alt=\"\" data-id=\"915\" data-link=\"http:\/\/dfabclass.com\/aa2020\/?attachment_id=915\" class=\"wp-image-915\" srcset=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/4tr-1024x660.png 1024w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/4tr-300x193.png 300w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/4tr-768x495.png 768w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/4tr.png 1395w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img loading=\"lazy\" decoding=\"async\" width=\"978\" height=\"742\" src=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/5tr.png\" alt=\"\" data-id=\"916\" data-link=\"http:\/\/dfabclass.com\/aa2020\/?attachment_id=916\" class=\"wp-image-916\" srcset=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/5tr.png 978w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/5tr-300x228.png 300w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/5tr-768x583.png 768w\" sizes=\"auto, (max-width: 978px) 100vw, 978px\" \/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"586\" src=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/6tr.png\" alt=\"\" data-id=\"917\" data-link=\"http:\/\/dfabclass.com\/aa2020\/?attachment_id=917\" class=\"wp-image-917\" srcset=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/6tr.png 698w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/6tr-300x252.png 300w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img loading=\"lazy\" decoding=\"async\" width=\"904\" height=\"721\" src=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/7tr.png\" alt=\"\" data-id=\"918\" data-link=\"http:\/\/dfabclass.com\/aa2020\/?attachment_id=918\" class=\"wp-image-918\" srcset=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/7tr.png 904w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/7tr-300x239.png 300w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/7tr-768x613.png 768w\" sizes=\"auto, (max-width: 904px) 100vw, 904px\" \/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"433\" src=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/8tr-1024x433.png\" alt=\"\" data-id=\"919\" data-link=\"http:\/\/dfabclass.com\/aa2020\/?attachment_id=919\" class=\"wp-image-919\" srcset=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/8tr-1024x433.png 1024w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/8tr-300x127.png 300w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/8tr-768x325.png 768w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/8tr-1536x650.png 1536w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/8tr-1600x677.png 1600w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/8tr.png 1726w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"610\" src=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/9tr-1024x610.png\" alt=\"\" data-id=\"921\" data-link=\"http:\/\/dfabclass.com\/aa2020\/?attachment_id=921\" class=\"wp-image-921\" srcset=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/9tr-1024x610.png 1024w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/9tr-300x179.png 300w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/9tr-768x457.png 768w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/9tr.png 1512w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"245\" src=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/10tr-1024x245.png\" alt=\"\" data-id=\"922\" data-link=\"http:\/\/dfabclass.com\/aa2020\/?attachment_id=922\" class=\"wp-image-922\" srcset=\"http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/10tr-1024x245.png 1024w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/10tr-300x72.png 300w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/10tr-768x184.png 768w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/10tr-1536x368.png 1536w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/10tr-1600x384.png 1600w, http:\/\/dfabclass.com\/aa2020\/wp-content\/uploads\/2020\/02\/10tr.png 1852w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/li><\/ul><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>For my project to showcase the ability to turn Excel spreadsheet data in to physical form on Grasshopper I decided&hellip;<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-911","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/dfabclass.com\/aa2020\/wp-json\/wp\/v2\/posts\/911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dfabclass.com\/aa2020\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dfabclass.com\/aa2020\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dfabclass.com\/aa2020\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"http:\/\/dfabclass.com\/aa2020\/wp-json\/wp\/v2\/comments?post=911"}],"version-history":[{"count":2,"href":"http:\/\/dfabclass.com\/aa2020\/wp-json\/wp\/v2\/posts\/911\/revisions"}],"predecessor-version":[{"id":923,"href":"http:\/\/dfabclass.com\/aa2020\/wp-json\/wp\/v2\/posts\/911\/revisions\/923"}],"wp:attachment":[{"href":"http:\/\/dfabclass.com\/aa2020\/wp-json\/wp\/v2\/media?parent=911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dfabclass.com\/aa2020\/wp-json\/wp\/v2\/categories?post=911"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dfabclass.com\/aa2020\/wp-json\/wp\/v2\/tags?post=911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}