Message Board

Mr. Excel has helped numerous clients analyze valuable stock market data by writing customized macros that instantly analyze and translate the data.

Every macro and application created for analyzing stock market data is a custom job. Mr. Excel and his Consulting Network carefully analyze your requirements and objectives and create an application that works to meet your specifications. We never reuse the same stock market data analysis application twice so you can rest assured that your complete privacy and security is guaranteed. In our eyes, your idea is a highly confidential trade secret that we never share with anyone. 

With market data analysis, Mr. Excel can help you:

• Analyze and translate stock data quickly
• Sort and group information
• Capture and archive live data on a regular basis
• Create custom data charts (line slopes, P&F charts, etc.)

If you have a large amount of valuable stock data, let MrExcel.com consulting services automate your analysis ideas. We’ll create a custom application that enables you to quickly and easily sort through piles of stock data and easily find that soon-to-be high-flying stock that might just make you rich!

Click here or send your project requirements and instructions to consult@MrExcel.com for a free estimate for developing a custom stock market data analysis application. Mr. Excel and his Consulting Network will examine your project requirements and objectives and provide you with a cost estimate for the job.

Back to top

Your audience will interrupt your presentation to study the map. Even after the presentation, people will still be talking about how unique and original your presentation was.

This can all be done with MrExcel.com's custom mapping service. Mr. Excel and his team of certified MVPs can graphically represent your company's data, giving you a new, unique way to present the usual information.

With custom mapping service from MrExcel.com, you can create a wide variety of custom maps including:

• Competitive analysis maps
• Merger analysis maps
• Sales coverage maps
• Customers-sales maps

We'll take your data and graphically represent it on a map of the continental U.S. The only limit for what can be done is your own imagination.

Click here or send your project requirements and instructions to consult@MrExcel.com for a free estimate for developing a custom mapping application. Mr. Excel and his MVPs will examine your project requirements and objectives and provide you with a cost estimate for the job.

Frequently Asked Questions on Custom Mapping:

What do I need to provide?: You should provide a Microsoft Excel worksheet with zip codes and anything else you want to analyze. For a simple competitive map, each row might contain a zip code and the name of the competitor. The format is not critical - we can massage columns to conform your data for the map. Tell us the title you would like on the map and the title for the legend. If you have specific instructions about colors for points, you can include those, or let us use our judgment.

What will I receive?: You will receive a high-resolution .jpg or .gif file with a static continental U.S. map showing your data. This file can be imported into Word, Power Point or printed alone.

What is the cost for this service?: Most maps cost $75. This will get you a basic competitive map with up to 1000 points and up to 7 competitors. Maps requiring further analysis, like the sales coverage map where we had to calculate the closest sales office can cost more. Send your data and I will let you know if your needs are more expensive than the standard $75 map.

How do I pay?: Your company will be invoiced for the cost of the map after you accept it.

How long does it take?: Data received by 2 p.m. eastern will usually be returned by noon the next business day. 

Is it safe?: Your confidential data will be treated with the utmost care. Our privacy policy insures that your data will not be shared with anyone. Feel free to fax your standard non-disclosure agreement to 330-761-1771 for prompt execution.

Where can I find the data to create the map?: The data you need to create the map probably already exists in your company between the marketing and sales analysis departments. They probably already have this data in Excel.

What if we don't have the competitive data?: Call us. We have a wide variety of marketing consultants who may be able to do your research.

What if my data is not in Excel?: If you can get us the data electronically, we can probably import the file. Depending on the file format, this may increase the cost of the map.

Do you offer maps of other areas?: At this time, we only handle the continental U.S.

How do I get started?: Send your data to consult@MrExcel.com.

Back to top

Simply contact Mr. Excel and he and his Consulting Network can turn your mundane regular tasks into fast, simple applications. 

Using Visual Basic for Application, or VBA, we can help you discover the power of Excel. If you own Excel, you already have Excel/VBA. With VBA and Excel, we can create custom applications that automate your work in Excel, showing you how to fully take advantage of all Excel can do for you while saving you valuable time every week.

We can help you utilize Excel/VBA to automate a wide variety of tasks, including the following:

• Import data from your new ERP system
• Auto-create sophisticated reports which are actually useful for running your business
• Automate the mundane task of formatting weekly reports
• Automatically generate charts and pivot tables 
• Develop bullet-proof user interfaces for collecting meaningful information 
• Develop complete applications 

Click here or send your project requirements and instructions to consult@MrExcel.com for a free estimate for solving your engineering problem with our custom engineering and graphics consulting service. Mr. Excel and his Consulting Network will examine your project requirements and objectives and provide you with a cost estimate for the job.

To learn more about Excel/VBA services available from MrExcel.com, check out what our clients are saying about us:

"We have just finished the meeting and the application was an outstanding success. I am trying to think of one work that describes the astonishment, disbelief, excitement, quizzical and bewilderment, because they are all the expressions I saw from five managers and one director. Anyway Bill, it was very successful - thank you."
V.C., Australia - January 2001 

"You are the Michael Jordan of Excel."
D.B., Southern California - June 2001 

"Phenomenal! I had no idea this could be done with Excel."
G.C., New Orleans - July 2001

Click here or send your data and instructions to consult@MrExcel.com for a free estimate for your Custom Data Analysis service. Mr. Excel and his Consulting Network will examine your project and provide you with a cost estimate for the job.

Check out some real-life applications of Data Analysis Services using Macros available from MrExcel.com:

Example 1:
A business has two files of data from two different sources. File A contains information about item numbers from a legacy system and File B contains different information about item numbers. File A may contain part numbers not found in File B, and vice-versa. The business needs a report with information about all part numbers in either file, with sub-reports of what is missing from File A and File B. Hiring a temporary to perform the mundane task of manually processing the data is likely to be error-prone and take too long. Instead, MrExcel.com can provide a quote for creating a customized macro that can quickly process the data.

Example 2:
During a new system implementation, a business finds that their new system requires receiving data in a specific format. The old system's reports contain unwanted graphics and information on different reports. MrExcel.com quickly eliminated the unwanted information, like headers and footers, inserted the information needed like account numbers for example, and corrected the formatting of the report to suit the business' needs.

Back to top