Hi everyone,
Forgive me if I'm not using the right terms somewhere, I'll try to describe the project as good as possible.
I need somebody that can produce an Excel spreadsheet, which contains market history data from [login to view URL] If I understand correctly this should be possible using a GET request. The data I want can be retrieved from a request like this one: [login to view URL]
It contains the timestamp, quantity, price, buy/sell information. Per timestamp I want the rest of the information next to it in columns (example in appendix). The API link keeps updating live data and I'd like get all this data into Excel to collect the data for several weeks or months. Accompanied with the spreadsheet I'd like these things answered/solved:
1. The API link example I used is for Dogecoin (DOGE), but I want to get the data of more different coins. What do I do when I want the data of Verge (XVG)? Is it just changing the API link in the code to [login to view URL] ?
2. I see that the request contains the data of about the last 200 transactions, though I do not want to miss ANY transaction. Can I still collect data while my laptop is offline or switched off? Is there a way to get the data I missed when offline or is there a way to keep the spreadsheet updated while offline?
Thanks.
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story)
Relevant Skills and Experience
I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you.
Proposed Milestones
€200 EUR - Please pay me once the job is 100% complete
Hi, I have checked your project. For your question, yes it is possible when you are offline. Please ping me I'll explain everything.
Relevant Skills and Experience
Web scraping, Python
Proposed Milestones
€100 EUR - deliver script
€100 EUR - full check and approval
Hi: I can create a script in Python or VBA Macro to get the data. The final output will in Excel. To get the data while your laptop is offline, you would need to buy a server space (monthly fee).
Relevant Skills and Experience
I am an expert in Excel and Python for web scrapping and automation. I always take my projects to completion and have ~100% completion rate, ~5-star feedback on projects and >30% rehire rate.
Proposed Milestones
€80 EUR - Scraper
Please connect with me to discuss your requirements in more detail.
Hello,
I already did something similar before, I have a macro that gets data from bittrex, gemini and other websites.
Relevant Skills and Experience
I am proficient with Excel and VBA and would love to help you with this project.
Proposed Milestones
€100 EUR - macro for bittrex
I am also interested in cryptocurrency and this might be a chance to learn more about it.
Hello. I can help you.
1. Yes, if you change link then script will be work.
Соответствующие навыки и опыт
Excel, VBA, GET requests
Предлагаемые промежуточные платежи
€150 EUR - Excel file for data saving for any market
Предлагаемые дополнительные услуги
€250 EUR - Site for offline data saving
2. If you need save data while offline then we need create site with service which will get data using sheduler and will save data in the database. Then you can import data from your site as csv for any period.
this can be kept in web server that you have to run this script always to fetch the data, I would like to do this project and provide my best on this scrapping. Could you please accept my proposal
Relevant Skills and Experience
VBA
Proposed Milestones
€112.22 EUR - final payment
Hello,
If you want to use this while you are offline, the best option is to use google sheets instead of excel macro. I can create a script that will be triggered constantly and pull the data.
Relevant Skills and Experience
Excel
VBA/macros
Google Sheets
Google script (java script)
Attention to details
Patience
Focus on quality
Proposed Milestones
€80 EUR - Full payment only after you are happy with the result
After the google sheet is populated with data, you can extract all info from it into Excel if it's easier for you to visualize. I can set it up to change the currency as needed.
If you are interested please open a chat with me.
Kind regards,
Sorin
i have done similar works for Indian stock market and yes you can even collect data offline, i mean program will refill once you turn on software. please let me know if you are interested.
I'm able to create a scraping script for you.
Relevant Skills and Experience
Python, Scraping, Excel
Proposed Milestones
€100 EUR - Full
I mainly use python with requests module. For your case I will use unicodecsv module to handle the information.
Your questions:
1 - Using recursive list of coins urls, you can grab whatever you want for each coin with the output you want.
2 - If you want to use online/offline, I recommend to you to host the script on a server and run the script from there. The script will output a valid csv to download.
Contact me so we could talk better about the project. Thanks
Hello, I understand what you want. If you want to constantly monitor the update of data, you can write a program for the Android phone, and your phone should always be switched on.
Relevant Skills and Experience
Android Studio, Excel
Proposed Milestones
€155 EUR - Android
I am a college student in Sri Lanka studying business management currently work to find some money for my education. So im looking for a part time job and i'm having fluent skills all ict related work
Relevant Skills and Experience
I am a college student in Sri Lanka studying business management currently work to find some money for my education. So im looking for a part time job and i'm having fluent skills all ict related work
1)I can solve it using java, i can create small gui for collection or .jar to call from command line interface.
2) we can keep it in your google drive and you will be able to collect data at anytime.
Relevant Skills and Experience
I have a good experience in creating client applications for web services/data extraction/ data parsing using java / shell scripting / pl& sql.
Please contact me by email, you can check my solution.
Proposed Milestones
€28 EUR - Get data from specific url , parse and export it to excel file(for each coin separate excel file).
€30 EUR - Get data continuously(let's say every hour) and keep it in your google drive, even your are offline.
€30 EUR - When you become online Get data from google drive, parse and export it to predefined excel
