Closed

Solution to monitor thousands of stocks in Excel

I have an Excel 2010 spreadsheet which is streaming in live market data. I need to send an output to a web service whenever certain cell values hit certain criteria I have set.

I have done this using Excel, but I believe Excel will not be able to scan so many symbols continuously without crashing/hanging.

I believe the solution lies in a Shared Add-in for Excel. I am also open to suggestions of any other kind.

Scope summary

a) Trigger an alert when figures in certain cells hit certain rules or values at certain intervals. I will supply the rules.

b) Relay that output to a web service.

b) Able to define the start and end times of the "scanning"

c) The generated output must be able to have user-defined text, and cell-referenced values

d) Timed alert - at times which I can specify, trigger an output with header of user-defined text and cell-referenced values

e) Timed population of data - at times which I can specify, a macro to execute copying a column of data and pasting it to another column in the Excel spreadsheet

f) A log to show the outputs generated in the day.

I will not respond to bids that say "Let me try this, or I am good at this, etc etc."

To be shortlisted, you should preferably be:

1) A native English speaker, or at least a good command of working English

2) Extensive experience in Excel, VBA, macros. C# .NET etc or other languages that can create Shared Add-ins.

3) Some basic knowledge of financial markets

4) Experience in coding for financial applications (pls state type of work done)

5) Experience in scanning for data changes in large and constantly changing datasets

6) In order to be shortlisted, please state how you understand my requirements, and how you would approach the solution.

Thank you.

Skills: AJAX, C# Programming, Excel, Software Architecture, Visual Basic

See more: with monitor, show need market, me excel, excel spreadsheet web service, define send, approach, ajax applications, text macros, say english, it symbols, end vba, vba macros, vba excel macro, vba e, vba excel, type scan, timed, stocks web, solution, relay, macro excel, macro e, financial times, financial markets, excel vba macro

About the Employer:
( 0 reviews ) Singapore, Singapore

Project ID: #1128445

15 freelancers are bidding on average $655 for this job

srinichal

Let us discuss further

$600 SGD in 8 days
(111 Reviews)
7.2
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$600 SGD in 10 days
(58 Reviews)
7.0
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our More

$650 SGD in 30 days
(13 Reviews)
6.4
koolsidz

Please see PMB

$666 SGD in 5 days
(136 Reviews)
6.2
gshiels

Please see PM

$750 SGD in 5 days
(12 Reviews)
5.3
mike25

Let me try this. Please check your PM for some remarks, Mike

$630 SGD in 7 days
(23 Reviews)
4.8
yehia111111

Hi,Kindly check your PMB

$630 SGD in 10 days
(5 Reviews)
3.8
terwelu

Thank you for the invitation. It would be written in C#.NET Framework 3.5

$750 SGD in 5 days
(7 Reviews)
3.9
dimvas

25 years experience in building custom web and desktop solutions. I Have done many realtime stock market [url removed, login to view] check PM

$900 SGD in 30 days
(3 Reviews)
3.8
tech2yash

excel/php experienced

$650 SGD in 6 days
(1 Review)
2.8
skizziks

We can do this using a combination of VBA, javascript and Google apps. Please see your private message.

$500 SGD in 7 days
(0 Reviews)
0.0
logicamatics

Hi, please read our message.

$750 SGD in 40 days
(0 Reviews)
0.0
iOne11

Hello Sir / Madam, I do have create a smae kind of excel-sheet using advanced excel functions and vba macro for a stock broking firm.

$500 SGD in 25 days
(0 Reviews)
0.0
hellovik

Hi, I understand the complexity level of ur projects. Please check PM.

$750 SGD in 15 days
(0 Reviews)
0.0
guruofdotnet

Hi have a freeware developed for getting live stock data. Have a look at http://getstockquote.blogspot.com. I can work on this project very effectually as I have some experience working on live stock data. My e More

$500 SGD in 15 days
(0 Reviews)
0.0