Automated Daily Financial Market Conditional Watch Alert - Google Sheets

Cancelled Posted 6 years ago Paid on delivery
Cancelled Paid on delivery

I would like to monitor approximately 100 different Indices/Commodities/Currencies on a daily basis. However rather than reviewing 100 different price tables each day, I would like to be alerted when a particular event occurs.

The event that will trigger an alert is an Exponential Moving Average Crossover. That is, when the 5 EMA crosses the 12 EMA on the price chart for the close price on a daily chart then I would like to be alerted.

There are a number of indices (S&P100), commodities (AUX) and currencies (AUDUSD) that I would like to track on a daily basis. I will compile a full list once the project is awarded.

A consolidated automated report that is emailed with a list of all the alerts each day would be great as soon as the market closes for the day.

The report should be automated, and I will need to be able to access and modify the original data set so that i can modify the EMA parameters and add additional Indices/Currencies/Commodities when i would like to.

Utilising Google Sheets would be a preferred method but I am open to other suggestions.

Please also read the attached file for an example.

Data Mining Finance Google App Engine Visual Basic Web Scraping

Project ID: #14252715

About the project

13 proposals Remote project Active 6 years ago

13 freelancers are bidding on average $153 for this job

jaylancer43

#1 Excel VBA programming expert 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 More

$200 USD in 3 days
(638 Reviews)
9.2
schoudhary1553

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 ex More

$250 USD in 3 days
(365 Reviews)
8.3
dgled

I did the same projects for daily traders. The simulation is done in Microsoft Excel to enable the trader to check the trend in life. How does the app work? Every day the trader enters some symbols to a symbols sheet. More

$250 USD in 3 days
(74 Reviews)
7.2
phpXpertbd

I worked on many similar projects, I have big experience in data mining projects. I have written hundreds of web scrapers which scrape millions of pages each day. I'm ready to fulfill your requirement.

$200 USD in 5 days
(84 Reviews)
7.4
sheak

Hello!I am a Chartered Accountant and hold Master’s Degree of Economics as well. I got 17 years of experience in Excel. I am 100% confident to do this project professionally. Relevant Skills and Experience You can che More

$277 USD in 7 days
(22 Reviews)
5.9
clearatul0

I am an expert in Excel Macros. Have a set of macros on Web Scrapping, Data Analysis and Extraction of categorical data. Used formulas, loops, links, functions in my coding. Relevant Skills and Experience 6 years Pro More

$155 USD in 3 days
(2 Reviews)
2.6
MetaoriginLab

Hey We are a team of Technical Developers and have got expertise in such stuff. Ping me if you are looking for a quick resolution

$153 USD in 3 days
(1 Review)
1.4
romero84

It will be easy. I have experience with such project Relevant Skills and Experience Visual Basic, Data mining Stay tuned, I'm is still working on this proposal.

$40 USD in 3 days
(0 Reviews)
0.0
RaqiyaTawfeeq

Hello I am Raqiya I am Data Entry/Data Processing Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy without adding additional charges. More

$30 USD in 3 days
(1 Review)
0.0
DougHeun

I have a working prototype to calculate the 5 and 12 day WMA i that is acceptable. Happy to show it too you if you are interested. Relevant Skills and Experience google script, google sheets, google app, JavaScript. J More

$200 USD in 3 days
(0 Reviews)
0.0