Dividend and Asset info on the Assets I hold (24 as of today)

[Edu]

Hi, I am new to Burst and found that it was not so easy to find info on Assets, one has to go through many threads etc... I have created a Google Sheet and started to monitor assets (as of today I hold 24 different assets). Not all have paid dividends yet, but the ones that have, I've included the ROI as well.
Hope it helps people looking into invest in Assets.

https://docs.google.com/spreadsheets/d/1OB2HDDH-G9UfhByOTShAd9iU6KT3xne47FgD7YVC19k

All info has been done to the best of my knowledge, if there are any mistakes, let me know and I will correct it asap!

[haitch]

@Edu Nice work!

@nameless - give this man a cookie !

[Edu]

@haitch Thank you!

[sleepy]

Very useful, thank you

[vprf]

Good Job! You might be able to pull all the data either live or at intervals. For example once or twice a day. That way you would not have to manually input anything. Been a long time since I've done it, but in the past I have with stock prices.

[Edu]

Thank you @vprf & @sleepy

[darindarin]

great thread! thanks@!

[Edu]

@vprf I dont know how to do that... Would make it a lot easier!

[Edu]

I have included another asset! HSASSETS.
Now the total number is 25!
If you want me to include other assets that are not on the list, let me know. You can also donate me 1 asset of the one you want included and I will monitor it and include the updates on the google sheet.
Here is the updated list:
402
49ersIndex
ADSactly
BSILVER
btcdragon
BURSTaker
BURSTeam
BurstMC
BurstOcean
ByteEnt
casino
CCM100
CCMINER100
Energizer
hsassets
Lex4All
MegaBurst
MikeTheMug
MTMGaming
OGburst
SoCalsFarm
StupenA
UniBURST
WorldMine
YASA

[vprf]

How to get live data into Google Sheets

[Edu]

@vprf Thank you! I hope to have this feature by tmr!!

[vprf]

@Edu Great. Just a suggestion it might be nice to use the last sale price if you can (instead of the Bid or Ask).

[Edu]

@vprf True, makes more sense! If i manage to automatically import that info it would be great!!

[dvndr007]

you are awesome man nice work!!

[Edu]

@vprf said in Dividend and Asset info on the Assets I hold (24 as of today):

How to get live data into Google Sheets

Hey @vprf, I followed all instructions in the video, but it did not work. I'm trying to get the info off the http://asset.burstnation.com/, but it seems to not have 'tables' or 'lists'. I also tried the ImportXML function, played around a bit as i only have very basic programing skills... still no success.

If anyone knows how to do this, please let me know, or if you would be willing to do it for 1 asset, I can learn from your example go forward and do it for all the others...

[qibucks]

This is really cool, love it thank you for the hard work.

[LithStud]

@Edu hey :) could you tell me what information you need to get? i could put onto my server a script to fetch data from some online wallet and parse it to what ever you need :)

[socalguy]

@Edu you know, I think what you are doing is awesome. Yet, I think you might reveal some things, about certain assets. Please keep going :)

[Edu]

@LithStud said in Dividend and Asset info on the Assets I hold (24 as of today):

@Edu hey :) could you tell me what information you need to get? i could put onto my server a script to fetch data from some online wallet and parse it to what ever you need :)

The idea was get the last sale price from each asset automatically into the google sheet and use that to calculate the ROI. Today I calculate the ROI based on the lowest ask price. And update the lowest ask price manually once a day.

[sleepy]

@Edu i use nxt api for getting information, refer this https://wallet.burst-team.us:8126/test . may need to use a method to decode the json reply and put in to excel