Đã hoàn thành

Change transaction time on stock market trade data

I trade US & Australian stocks and get the transaction data from my broker which I download into third party software (Tradervue) which I use to review my trades.

However due to a recent change by the broker, the data I download for US trades now has the Australian time as the execution time, rather than the US time that the trade was executed.

I am wanting the time for US trades converted back to US time so that it makes sense on my third party software.

Below is an example of the format that I receive from my broker

STK_TRD|5117478|BOOT|BOOT BARN HOLDINGS INC|NYSE|BUYTOOPEN|O|20191112|06:18:57|USD|2.00|1.00|40.96|81.92|-1.00|1.4624

This is the date & time portion of the trade

20191112|06:18:57

and needs to be adjusted back 16 hours for the time difference between Sydney & New York.

so the above will become

20191111|14:18:57

Note that there will be some Australian trades which will not need any adjustment, but the majority of trades will be US trades that will require adjusting.

Australian trades are denoted with ASX code as seen in the trade below.

STK_TRD|5157509|NXT|NEXTDC LTD|ASX,CHIXAU|BUYTOOPEN|O|20191115|13:56:10|AUD|900.00|1.00|6.88|6192.00|-6.60|1.00

I want to be able to convert this on a regular basis (at least weekly) as I am an active trader

and there could be a couple of hundred lines of trades each week.

Ideally I would like an excel template (or something similar) that will easily and quickly convert the data so I can download into my third party software.

Please let me know if you require further clarification of what I need.

Thanks

Michael

Kĩ năng: Excel Macros, Thuật toán, Excel VBA, Python, Kiến trúc phần mềm

Xem nhiều hơn: real time stock quotes google, stock market live stream, post trade processing solutions, post trade processing workflow, yahoo finance, real time stock ticker desktop, real time stock ticker, real time streaming stock quotes, data stock market data using, india stock market excel real time, programmer access stock market data, stock market live data api asx, stock market data feed mac, chart dynamic excel cell time stock data, stock market data using aspnet, real time stock market simulation mysql, programmer stock market raw data, real time stock market feeds excel, stock market odin data fetcher, real time stock market yahoo

Về Bên Thuê:
( 3 nhận xét ) Sydney, Australia

ID dự án: #22408910

Được trao cho:

Alexsfodik

Hello. How are you. I'm software engineer and algorithm expert. I have many experiences in Access, Excel, VBA. I can complete your project successfully. Thanks.

$120 AUD trong 3 ngày
(5 Đánh Giá)
4.4

15 freelancer đang chào giá trung bình $27 cho công việc này

limingdev0507

Hello Sir Since I'm a new to Excel, money is not my top priority. I regard the reputation more. I carefully read your spec. I noticed that you want macro to change the US timeline to Australian. Am I right? Well I thi Thêm

$10 AUD trong 3 ngày
(1 Nhận xét)
3.0
omsolutions4

hi michael; I can write a quick script that would do the conversions for you with out any problems.

$30 AUD trong 1 ngày
(3 Nhận xét)
1.3
Ayushthakkar6you

Hello Sir/Mam When I saw your project and thought about it, Sir, I was convinced that I could do your project and try to figure it out sooner than the time given. Sir I have been doing this work for the last four yea Thêm

$10 AUD trong 7 ngày
(0 Nhận xét)
0.0
vaibhav7291

I am fit for the job and capable of delivering excellent results. I am good in data entry ad excel too . I fulfill all the eligibility criteria

$20 AUD trong 7 ngày
(0 Nhận xét)
0.0
atifanazir4

i have gone through the attachments you have provided and i can do this work very quick. kindly give me this opportunity to work with you.. my main motive will be the efficiency and time . thanks looking forward to wo Thêm

$20 AUD trong 7 ngày
(0 Nhận xét)
0.0
miah235

Hi, I will complete the task within 10 days , and i will do my maximum level to complete the work before the due date thanks and regards Rasheed

$20 AUD trong 7 ngày
(0 Nhận xét)
0.0
hajarrajab1234

Hello, My name is Hajar I have good typing/data processing /web searching skills and I can complete the project quickly, efficiently and accurately for a good price.I am very much interested in your project and would l Thêm

$20 AUD trong 3 ngày
(0 Nhận xét)
0.0
aliubaidrajput12

Hi there! I hope you are well. I have gone through your job posting and become very much interested to work with you. Please review my profile: https://www.freelancer.com/u/aliubaidrajput12?w=f I have excellent experi Thêm

$12 AUD trong 3 ngày
(0 Nhận xét)
0.0
spandu2310

Expert in using excel. Need clarification. Do you need template or need someone to change dates every week for you. Relevant Skills and Experience Have excellent knowledge in excel

$25 AUD trong 1 ngày
(0 Nhận xét)
0.0
$25 AUD trong 1 ngày
(0 Nhận xét)
0.0
AzizNantu

I am expert in excell worksheet as well as stock market trading. So I understand about your work. I will continue in your work with utmost care & quality. And I will deliver the work within my mentined time positively Thêm

$30 AUD trong 2 ngày
(0 Nhận xét)
0.0
RANGAJNA

I will do it

$25 AUD trong 1 ngày
(0 Nhận xét)
0.0
hemalnakrani

Hello,Dear sir/medam i was totally understand what you want and i will give my best if you choose me for this work also i will give a short sample of your work if i was selected. you can Trust me for a Best output wit Thêm

$10 AUD trong 1 ngày
(0 Nhận xét)
0.0
vikaswebresearch

Hi,i read Your project details and want to work fo you I can easly do your job if you want to hire me then please accept my proposal. thank you vikas nitharwal

$25 AUD trong 3 ngày
(0 Nhận xét)
0.0