Interesting strategy and I'll be following you to keep updated on these spreadsheets you generate. I was wondering how you made the sheet, but read your reply that you have a script to do that. I've been keeping my own spreadsheet (with data laboriously entered by hand :-) and have used that to sort & rank those I'm watching. Your idea of ranking by "millionth of supply" makes sense. Good strategy and great article!
You are viewing a single comment's thread from:
Hello longshot, I use a script called =ImportJSON() that you can import into Google Spreadsheets. Here's the github page:
It requires a bit of programming knowledge but if you find it overwhelming don't worry, I'll publish updates to the spreadsheet regularly here. Actually, if you re-balance too often you are doing it wrong. You shouldn't be looking at the indexes too often, this is something very important I learned from reading Ben Graham and Warren Buffet's books.
BTW, great name :)
Jeez! Sometimes I HATE this "Reply" function! I just spent close to an hour writing you back but hit "Reply" again (instead of "POST") sending my work into the void off the blockchain! At LEAST it wasn't crypto!
As to my avatar, "Longshot": I figured it'd be a "longshot" if I ever made enough money doing this blogging stuff to pay for my eventual retirement! 😉
I've never used Google Spreadsheet before, preferring to use LibreCalc installed on my Linux machine. I don't expect it'd be too different, and possibly importable, but I don't know.
Anyway, I have a couple of questions for you if you feel like answering: I see where you derive your values in columns R & S from columns H, I & J, but I wonder how you arrived at the calculations for T & U, "Percentages to Buy" (both Top 10 & Top 20)? And what determines your percentages for those allocations?
I KNOW I may be asking the magician to reveal where the rabbit is hid here (heh-heh) ~ And if you'd prefer to reveal all these secrets in successive posts I can't fault you for that. I will be following in hopes you post your tracking results of this system as I suspect they'll be quite profitable.
Again, thanks for answering and keep up the good work!
PS: NEVER reply after typing a reply by hitting "Reply"! (Argh!)