Author

Topic: Advanced spreadsheets - e.g. Signature campaign or Trading - Closed (Read 4577 times)

hero member
Activity: 617
Merit: 500
I am the signed message, without I am not
Don't quote this message.
hero member
Activity: 1498
Merit: 614
Liable for what i say, not for what you understand
Yo mate! Smiley
Do you think you can create a google sheet for my bot to pull data from polo trading history and subdivide it to multiple sheets (by pairs)?
Basically what this page does
I have already a system that i will push on next release but i want to make those calculations public so i guess a google sheet would do its job
Yes, I believe I will be able to do it. If this is what you want;

A spreadsheet, that can order the .csv data exported from Poloniex and sort them into different sheets. It will do it according to the cryptopair (FCT/BTC, ETH/BTC, etc).

That should be do-able. The biggest issue is how Poloniex handles .csv files, but I know an easy fix to that.

Edit: I will first be able to make it on monday, as I got quite a lot to do.

np mate and no rush this is for my private project. Tell me in PM how to proceed and i follow you
and yes :
Code:
sep='

Wink
~Gun
hero member
Activity: 617
Merit: 500
I am the signed message, without I am not
Yo mate! Smiley
Do you think you can create a google sheet for my bot to pull data from polo trading history and subdivide it to multiple sheets (by pairs)?
Basically what this page does
I have already a system that i will push on next release but i want to make those calculations public so i guess a google sheet would do its job
Yes, I believe I will be able to do it. If this is what you want;

A spreadsheet, that can order the .csv data exported from Poloniex and sort them into different sheets. It will do it according to the cryptopair (FCT/BTC, ETH/BTC, etc).

That should be do-able. The biggest issue is how Poloniex handles .csv files, but I know an easy fix to that.

Edit: I will first be able to make it on monday, as I got quite a lot to do.
hero member
Activity: 1498
Merit: 614
Liable for what i say, not for what you understand
Yo mate! Smiley
Do you think you can create a google sheet for my bot to pull data from polo trading history and subdivide it to multiple sheets (by pairs)?
Basically what this page does
I have already a system that i will push on next release but i want to make those calculations public so i guess a google sheet would do its job
hero member
Activity: 1106
Merit: 638
WOW! This is an incredible deal for these services.

I know people that charge BTC0.2 and up PER HOUR to do exactly what the OP is offering. This is a hell of a deal - I'd jump on it quick before the sale goes away.
hero member
Activity: 617
Merit: 500
I am the signed message, without I am not
Got a simple spreadsheet similar to his sample spreadsheet with scraping the current post. He was prompt in answering my queries and delivered my order just as fast! I sent first and didn't have a problem! Thanks for the 50% discount Frilled!
Thank you for your order.
The 50% discount will not be active anymore. Instead a 25% one will be applied on the next order on the same terms.
sr. member
Activity: 588
Merit: 250
Got a simple spreadsheet similar to his sample spreadsheet with scraping the current post. He was prompt in answering my queries and delivered my order just as fast! I sent first and didn't have a problem! Thanks for the 50% discount Frilled!
hero member
Activity: 854
Merit: 500
Im interested in a simple spreadsheet
 I will pm you the details. I prefer Google spreadsheets
hero member
Activity: 617
Merit: 500
I am the signed message, without I am not
I don't know which rate this would fall in. Give me an idea.

Personal E-Book Library with hundreds of authors and about 1.2k book titles.

For plot summary- placing a link for each title directly to goodreads

And there would be links for each title to a specific shared document in google drive.
(The drive link is optional, I can do this myself if the rate difference is high.)

It'll look like this:

        Author                  Book Series         Book Title                    Plot Summary                Drive Link

1. Sanderson, Brandon    Mistborn 01      The Final Empire            goodreads link[plot]       google drive link
                                   Mistborn 02     The Well of Ascension      goodreads link[plot]       google drive link


I don't have time to do data entering atm, but I can create a list and draw data from it into another sheet.
The other sheet would be able to sort, search by keywords or some other stuff. It will cost 0.015 BTC, as it is based around 2 sheets. (2 in 1)
legendary
Activity: 2436
Merit: 1104
I don't know which rate this would fall in. Give me an idea.

Personal E-Book Library with hundreds of authors and about 1.2k book titles.

For plot summary- placing a link for each title directly to goodreads

And there would be links for each title to a specific shared document in google drive.
(The drive link is optional, I can do this myself if the rate difference is high.)

It'll look like this:

        Author                  Book Series         Book Title                    Plot Summary                Drive Link

1. Sanderson, Brandon    Mistborn 01      The Final Empire            goodreads link[plot]       google drive link
                                   Mistborn 02     The Well of Ascension      goodreads link[plot]       google drive link

hero member
Activity: 617
Merit: 500
I am the signed message, without I am not
Hello,

Will you be willing to share resources to learn Excel from ?
I understand you are providing a service here but I am looking to equip myself for a job about 6-8 months from now.
Would be happy to pay.

Regards
Hi cryptor0th,
I have no help resources to learn Excel from. Most of what I know, has been learned from helping friends and some personal thing, like trading. I have also checked https://support.google.com/docs/table/25273?hl=en&ref_topic=3105472 and learned the functions I thought was cool.

If you want, I can create a few puzzles from which you will learn to use different functions. Starting easy, but slowly the puzzles will get harder and more complex.
full member
Activity: 218
Merit: 100
Hello,

Will you be willing to share resources to learn Excel from ?
I understand you are providing a service here but I am looking to equip myself for a job about 6-8 months from now.
Would be happy to pay.

Regards
hero member
Activity: 617
Merit: 500
I am the signed message, without I am not
any examples?
I have made this sheet: https://docs.google.com/spreadsheets/d/1KHu9BWwy_QXIYAx2m_Tzs9BqPoTYUDhEDbHihZEXGsE/edit#gid=81124645. It shows the current active Burstcoin pools and calculates their recommended capacity and pulls the number of users. It doesn't show everything that is possible, as most of it is basic. The only functions in the sheet is in the column "Registered Users", "Recommended plot size" and on the sheet "Calculations". Most of it is just showing I know how to pull data, not that impressive.

If you want one, but not certain if I can live up to your quality, you can always try. I will refund you 100% if I can't give you a spreadsheet you like. The first spreadsheet is also 50%.
copper member
Activity: 1876
Merit: 533
hero member
Activity: 617
Merit: 500
I am the signed message, without I am not
It's a nice idea. A script to output addresses into electrum? Really nice.

May I ask, can you do web scraping? So since the normal thing is to list out a user's current posts and minus their uncounted posts to get their total posts that will be paid for, you can get excel to scrape the bitcointalk profile page and get their current posts.
Yes, I can use Electrum pay-to-many and show the data the way Electrum likes. If you are using a wallet which want the data to be written /sendTSX(ADDY;AMOUNT, ADDY;AMOUNT) that is also possible.

I can do web scraping, but there is a couple of difficulties if you want me to pull from Bitcointalk. I have successfully pulled your posts, but I'm not sure if it will work after a bit of time. Check the sheet below to see if it shows your post count without errors.
https://docs.google.com/spreadsheets/d/1bjQBamAOoVrjdbh1AEkNlzoyOiE_OVa3AzJycZM81Xg/edit?usp=sharing

As of writing, it does. (Edit: It updates once in a while, just make sure it doesn't display an error)
Ohhh, it works! May I ask, what's ark1? Never heard of that function. When I try importxml it breaks.

If I find a campaign to manage again I'll be sure to get back to you. Smiley

ark1 is the name of the sheet where the function is hidden. I'm calling the number from there, to make sure everything is working correct. I'm also running a function outside of the scraping, to make sure it is a number. I could put all features into 1 function, but it would require more time. It will be included if you buy a sheet.
The sheet call function can also be used on public sheets, to hide key functions from other managers.  Wink

The import functions can be tricky. It is about knowing how to use them. They display the data differently and to make it succesful, you have to make sure the text is without line breaks if you want to make the data small.
 You have to learn which one to use in what way. In my case, I will be using the import function that display the data without linebreaks. I will be able to use 1 functionsand 1 cell to do more then what would be possible with a function displaying the data with a line break.

Thank you.  Smiley
legendary
Activity: 1232
Merit: 1030
give me your cryptos
It's a nice idea. A script to output addresses into electrum? Really nice.

May I ask, can you do web scraping? So since the normal thing is to list out a user's current posts and minus their uncounted posts to get their total posts that will be paid for, you can get excel to scrape the bitcointalk profile page and get their current posts.
Yes, I can use Electrum pay-to-many and show the data the way Electrum likes. If you are using a wallet which want the data to be written /sendTSX(ADDY;AMOUNT, ADDY;AMOUNT) that is also possible.

I can do web scraping, but there is a couple of difficulties if you want me to pull from Bitcointalk. I have successfully pulled your posts, but I'm not sure if it will work after a bit of time. Check the sheet below to see if it shows your post count without errors.
https://docs.google.com/spreadsheets/d/1bjQBamAOoVrjdbh1AEkNlzoyOiE_OVa3AzJycZM81Xg/edit?usp=sharing

As of writing, it does. (Edit: It updates once in a while, just make sure it doesn't display an error)
Ohhh, it works! May I ask, what's ark1? Never heard of that function. When I try importxml it breaks.

If I find a campaign to manage again I'll be sure to get back to you. Smiley
hero member
Activity: 617
Merit: 500
I am the signed message, without I am not
It's a nice idea. A script to output addresses into electrum? Really nice.

May I ask, can you do web scraping? So since the normal thing is to list out a user's current posts and minus their uncounted posts to get their total posts that will be paid for, you can get excel to scrape the bitcointalk profile page and get their current posts.
Yes, I can use Electrum pay-to-many and show the data the way Electrum likes. If you are using a wallet which want the data to be written /sendTSX(ADDY;AMOUNT, ADDY;AMOUNT) that is also possible.

I can do web scraping, but there is a couple of difficulties if you want me to pull from Bitcointalk. I have successfully pulled your posts, but I'm not sure if it will work after a bit of time. Check the sheet below to see if it shows your post count without errors.
https://docs.google.com/spreadsheets/d/1bjQBamAOoVrjdbh1AEkNlzoyOiE_OVa3AzJycZM81Xg/edit?usp=sharing

As of writing, it does. (Edit: It updates once in a while, just make sure it doesn't display an error)
legendary
Activity: 1232
Merit: 1030
give me your cryptos
It's a nice idea. A script to output addresses into electrum? Really nice.

May I ask, can you do web scraping? So since the normal thing is to list out a user's current posts and minus their uncounted posts to get their total posts that will be paid for, you can get excel to scrape the bitcointalk profile page and get their current posts.
hero member
Activity: 617
Merit: 500
I am the signed message, without I am not
Advanced spreadsheets


 I can make your dream into a spreadsheet, you just have to supply me with a few details and I will create it.
I feel home in Google spreadsheet or Apple's Numbers. I can however create Excel sheets, but it might take a bit longer.
 You will be able to follow along while I'm creating it, if it is made in google sheets.



Portofolie:
Lone Shark Function density of 29 per line.
Gunthar Spreadsheet to analyse trading data.
25% rebate on next order to put in my portfolio.

Selling or usage of materials in my portfolio is prohibited. All rights belongs to the client.



Overview:                           Simple               Medium            Advanced               Superior            
Estimated price0.01 BTC0.015 BTC0.02 BTCAbove 0.035 BTC
Number of functions1 to 2020 to 5050 to 100Unlimited
Sheets within the sheet135Unlimited
Pull data from websites?LimitedYesYesYes
Additional edits247To be Discussed
ColoursLimitedYesYesMany



Why you should choose me?
I will make the spreadsheet compatible with your requirements.
  This means, as a signature manger, you can get an output from the spreadsheet you can import into directly Electrum or another wallet with 1 copy paste instead of 100.
You got the ability to see what I'm making, if you choose google sheets.
I can use your colours to design it. No boring black and gray default colorset.
If you aren't happy with your product, I will refund you 100%.
  If you can give me a valid reason I can't fix.



Read this before posting:
Escrows are accepted, but the fee you pay. It will not be returned if you are unhappy with my service.
No vouch copy, unless you have somekind of relation to me.
This is a self-moderated thread and all unserious replied will be deleted. If you are unhappy with my service, create a post in reputation and link it from my trust page. Alternatively, remove your signature and I won't remove your post. (Unless it is on page 1)
Jump to: