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 a need in market, me excel, how to start coding, excel spreadsheet web service, excel macro how to, define send, d&b supply, an approach to, ajax applications, vba and macros, text macros, say in english, log me in, it symbols, excel vba with, excel vba or, end vba, Data e try, VBA Macros, vba excel, vba excel macro, vba e, VBA and excel, type a scan

About the Employer:
( 0 reviews ) Singapore, Singapore

Project ID: #1128445

15 freelancers are bidding on average $655 for this job


Let us discuss further

$600 SGD in 8 days
(111 Reviews)

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)

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)

Please see PMB

$666 SGD in 5 days
(136 Reviews)

Please see PM

$750 SGD in 5 days
(12 Reviews)

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

$630 SGD in 7 days
(23 Reviews)

Hi,Kindly check your PMB

$630 SGD in 10 days
(5 Reviews)

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

$750 SGD in 5 days
(7 Reviews)

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

$900 SGD in 30 days
(3 Reviews)

excel/php experienced

$650 SGD in 6 days
(1 Review)

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)

Hi, please read our message.

$750 SGD in 40 days
(0 Reviews)

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)

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

$750 SGD in 15 days
(0 Reviews)

Hi have a freeware developed for getting live stock data. Have a look at 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)