Find Jobs
Hire Freelancers

Transpose Data for Several Hundred Stock Trades

$30-250 USD

已完成
已发布将近 3 年前

$30-250 USD

货到付款
An understanding of stock trading, including short positions, is necessary to complete this project. To bid on this project, please make a copy of the spreadsheet and complete 3-4 new rows in the Output tab to confirm that you understand what needs to be done for the project, then include the link to your copy with your bid. Do not hesitate to ask any clarification questions before accepting the project. --- I will share with you a Google spreadsheet with two tabs: Input and Output. The project is to transpose data from the Input sheet into the Output sheet. Here is an example spreadsheet: [login to view URL] There are 150 rows in the Input of the complete spreadsheet. Each row contains one or several actions for buying, selling, shorting, or covering stock positions. Each Input row must be transposed into one or several Output rows that correspond to when the position for a stock was entered (either a buy or a short) and when the position was exited (either sell or a cover). If the Input Action is a Buy, enter "long" in the Output Direction and enter the Start Date. If the Input Action is a Short, enter "short" in the Output Direction and enter the Start Date. If the Input Action is a Sell, find the corresponding Buy for that stock and enter the End Date. If the Input Action is a Cover, find the corresponding Short for that stock and enter the End Date. Note that it is possible for the same stock to enter a long or a short position multiple times before exiting. In that case record each separate entry as a new row, and enter the same End Date for all rows when the position is eventually closed.
项目 ID: 30518989

关于此项目

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

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hye Sir/mam, I have just added 8 new rows in output sheet to give you an evidence of my understanding of this task. I am involved in Stock trading for very long time so i can understand all terminologies, this task may required. [login to view URL] In addition to this, I just have one point to ask. I am not seeing any prices in the input sheet so how would i get that. Would they be available in the complete input sheet you will provide or do i have to use Google finance for the prices? Looking forward for your response. I am completely open for negotiation on the price and i can work with very reasonable price because i am really looking for a work Regards
$100 USD 在5天之内
0.0 (0条评论)
0.0
0.0
6威客以平均价$165 USD来参与此工作竞价
用户头像
Hi, Excel Expert here with in depth knowledge of Business accounting and Finance. I have read your job description and I am interested. Kindly message me for discussion Regards Shoaib
$100 USD 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
I saw your problem and im confident it can be solved using programming. I worked on R code for portfolio allocation and trading performance before. ill charge more but,.in the future, youll be able to use the code whenever you need. Please get in touch and ill explain further.
$250 USD 在5天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hello, I can easily do this but you don't have the prices in example sheet to calculate the HPR (holding period return). If you have the complete sheet (150 input rows including the entry price) then I can use formulas to create the output sheet you seek. I am confident I have the Excel skills to do this efficiently and I have a Finance MBA and I'm also a CIM and DMS designation holder (Chartered Investment Manager, Derivative Market Strategist) and I trade FX for a proprietary trading firm
$250 USD 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
I have worked with the stock trading company many times so i found my self compatible with this job.
$40 USD 在7天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Stamford, United States
5.0
67
付款方式已验证
会员自1月 29, 2010起

客户认证

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