[ 3 / biz / cgl / ck / diy / fa / ic / jp / lit / sci / vr / vt ] [ index / top / reports ] [ become a patron ] [ status ]

/vt/ - Virtual Youtubers

Search:


View post   

>> No.27961676 [View]
File: 131 KB, 1044x562, file.png [View same] [iqdb] [saucenao] [google]
27961676

To all four users of the "Mutual Fund Order Tracker" - is any of this additional information useful? Picrel. Incorporating it WILL break it and require you to manually copy a new version again.
I didn't leave enough room between my jank columns and the data itself. Should've paginated them on my end too but it would've broken all the old ones immediately as well.

I had to make sure I was outputting all of it, at least on my end, because I want to incorporate it into the Wallet Analyzer and help out the Anon that makes the Haato mutual fund posts

Wallet Analyzer is technically broken at the moment...I just haven't had the time to do any of this since it was brought to my attention. It's still a functional "Wallet Analyzer" but it completely ignores your mutual fund shares, both for net worth I think this was one of the changes that made it "Revised" - calculated based on your coin stacks X price + balance - to completely eliminate the getLeaderboard call and dividends manually calculated by the sheet - stack size X dividend amount

To all seven users of the "Wallet Analyzer":
The new version might have to be paginated, with two sheets, one for coins that looks identical to the current one, and a new one for your mutual fund shares that is importing pre-formatted data the same way the other Mutual Fund sheet currently is. I don't want to break sorting, and unless I can figure out how to completely script the data import (almost there, plus I think I have to in order to make it work with the getUserInfo call as currently written) instead of using IMPORTRANGE, you will have to sort with a filter view. Plus I'm not sure anyone would WANT to sort Mutual Funds in between coins.
"getMutualFundData" is bloated - 1.2 MB (uncompressed - I am not sure if Google Sheets reports it can accept gzip or not) - ~900ms latency from the server. It returns (for all funds) every member, every shareholder, their full portfolios, every bulletin (a few hundred lines of BUY TOWA), every pending order, the entire history (TWICE! once under fundHistory, and then again under fundStats:fundID:history) and any funds that are to be dissolved.

There's unfortunately no "light" "getMutualFundINFO" call that ONLY returns picrel.
I don't want to incorporate any user-facing functionality directly into the wallet analyzer that relies on that API call because I know some people have it running automatically or run it very frequently, and I don't want server bogging blood on my hands, especially as that JSON payload gets larger over time/with more funds.


Your input - whether shitty mockups, bantz, or suggestions - is greatly appreciated. There's also a lot of room for someone far more intelligent than I to make something really powerful out of all this data.

Navigation
View posts[+24][+48][+96]