Find Jobs
Hire Freelancers

Edit Macro to change structure of outputs - Histoci stock price macro

$15-25 USD / hour

已关闭
已发布将近 7 年前

$15-25 USD / hour

Hi Attached is a spreadsheet I am looking for a Freelancer to edit or update the macro I have accessed from the internet. I would like the macro to be changed so: - It only deletes the black tabs upon running a refresh, and all the yellow sheets remain - The Macro populates the "Consolidation" tab with the information for all stocks in that and splits the data into Open, High, Low, Close, Volume, Adjusted Close by Day and by stock - The days in the consolidated sheet are from most recent downwards - The macro is in a form that I can use the Consolidation sheet to drive formulas in the remainder of the spreadsheet. I expect this to be a reasonably simple job, but would like to use a Freelancer who has good experience in VBA / macros who produces a solution that: a. Runs smoothly and doesn't take a long time b. Has no bugs I am also open to an alternative solution if the Freelancer can get the desired result. Very happy to take questions and work with the Freelancer as we go. Thanks
项目 ID: 14024503

关于此项目

17提案
远程项目
活跃7 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
17威客以平均价$23 USD/小时来参与此工作竞价
用户头像
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$20 USD 在15天之内
4.8 (176条评论)
7.0
7.0
用户头像
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$22 USD 在40天之内
4.9 (158条评论)
6.7
6.7
用户头像
Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and doing the project. Best regards, Eyad
$52 USD 在40天之内
4.9 (20条评论)
6.5
6.5
用户头像
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz
$22 USD 在40天之内
5.0 (47条评论)
5.4
5.4
用户头像
H, I have experience in stock prices. Lately, I prepared a project for a Stock Exchange trader, the module reads selected historical tickers information from Yahoo Finance, shows statistic results based on algorithms, creating candle charts and show the best results by order. Also, the app reads a Real-Time Ticker List from specific websites like eSignal, adds the list to the database with the Change, Bid, Ask, and sizes. about me I am financial specialist and guru in Excel and VBA. I create creative and sophisticated financial models in a simplified and logical manner including clear assumptions, drivers, financial statements, valuations, proper sensitivity analysis, scenarios and dashboards that are easy to understand by the client and their investors. Over 35 years, I have created dozens of financial modules, business plans, and modules for accounting, budgeting, financial reports, financial plans, and inventories reports for a variety of firms including, startups, retailers, power plants, farms, universities, equipment manufacturers, among others.
$27 USD 在40天之内
5.0 (20条评论)
5.3
5.3
用户头像
I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$22 USD 在40天之内
4.8 (45条评论)
5.2
5.2
用户头像
I have the expertise in Excel VBA and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.
$16 USD 在12天之内
4.5 (69条评论)
5.2
5.2
用户头像
Hello, I am Rahma. I have seen your project and understood it. I believe in quality not quantity.I will give my best to fulfill your work.I have the excel skills required for this job. I am currently a 3rd year student of English Literature. Hope to hear from you.
$22 USD 在40天之内
4.3 (2条评论)
1.0
1.0
用户头像
Hi We are extremely well versed in macros, whether they are automatically triggered or activated by a button. We have designed macros which update data, prepare entire sheets, and perform complex calculations on the given dataset. We are also capable of managing formatting using macros. We are starting our Freelancer account after having built a strong reputation, and are looking to this project to build our profile here. NOTE: The spreadsheet is not attached. The images of the Calibration certificate and Kitchen cleaning schedule are not sufficient to understand the requirement clearly. Please message so that we may recommend the approach to be taken. Regards
$15 USD 在40天之内
5.0 (1条评论)
0.8
0.8
用户头像
Dear, Thank for the detail requirement. I understand your expectation clearly and could make it done in a short time. High quality guarantee with low cost since I'm a new freelancer .
$16 USD 在10天之内
5.0 (2条评论)
0.4
0.4
用户头像
Hi, I can handle it
$16 USD 在7天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi - I and an Excel expert and have been developing VBA code in Excel for almost 20 years. I have developed many tools that deal with stock market data and I would like to work on your project. Assuming the data is relatively structured, this should be fairly straight-forward and I don't think it would take much more than a day to complete. I would opt for rewriting the code as it is usually more difficult to follow someone else's logic and be responsible for its accuracy and robustness. I look forward to hearing from you. Jim.
$22 USD 在20天之内
0.0 (0条评论)
0.0
0.0

关于客户

PAKISTAN的国旗
sialkot, Pakistan
0.0
0
会员自1月 14, 2015起

客户认证

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