Find Jobs
Hire Freelancers

Extract live data from website to excel with API

€30-250 EUR

已关闭
已发布超过 6 年前

€30-250 EUR

货到付款
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.
项目 ID: 15366919

关于此项目

20提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
20威客以平均价€142 EUR来参与此工作竞价
用户头像
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
€200 EUR 在2天之内
5.0 (585条评论)
8.2
8.2
用户头像
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
€200 EUR 在3天之内
5.0 (133条评论)
7.0
7.0
用户头像
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.
€80 EUR 在3天之内
4.9 (155条评论)
6.9
6.9
用户头像
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.
€100 EUR 在1天之内
4.9 (123条评论)
5.7
5.7
用户头像
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.
€150 EUR 在3天之内
5.0 (42条评论)
5.5
5.5
用户头像
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
€112 EUR 在3天之内
4.9 (21条评论)
4.8
4.8
用户头像
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
€80 EUR 在3天之内
5.0 (40条评论)
4.9
4.9
用户头像
A proposal has not yet been provided
€250 EUR 在28天之内
5.0 (16条评论)
3.9
3.9
用户头像
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.
€120 EUR 在2天之内
5.0 (1条评论)
3.4
3.4
用户头像
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
€100 EUR 在3天之内
5.0 (3条评论)
3.2
3.2
用户头像
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
€155 EUR 在7天之内
0.0 (1条评论)
0.0
0.0
用户头像
ok Соответствующие навыки и опыт ok Предлагаемые промежуточные платежи €55 EUR - ok
€55 EUR 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
€222 EUR 在15天之内
0.0 (0条评论)
0.0
0.0
用户头像
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
€155 EUR 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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
€88 EUR 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

NETHERLANDS的国旗
Netherlands
0.0
0
会员自10月 10, 2017起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。