Currency Day Trading,

Excel file currency conversion program for money exchange spot?

I need a simple excel file which can calculate from one currency to another. It should have big buttons with currency picture, to select which currency is traded, an input field of howmuch foreign currency I receive and an output field which tells me howmuch to give the customer back. Besides that I must be able to input daily exchange rates for all currency’s. An additional plus would be a print receipt option for customer and database option to store all days transaction.

Here’s what I would do: Firstly, I would find a reliable place to get a simple-ish list of exchange rates. Then I would highlight and copy it all to a sheet in Excel, by default Excel files have a Sheet1, Sheet2 and Sheet3. I’d copy it to Sheet1 and rename the sheet Rates. It’ll look ugly and weird, but it’s important not to fix it up.

Then on Sheet2 I would design the interface you described. You’ll need the Insert menu (on Excel 2003 or before, not sure where it is in the stupid Ribbon in crappy Excel 2007 and later) for those elements, like the buttons and the picture. And I would use a Combo Box to pick the currency/country. It takes more setting up, but it’s more natural for people. I would suggest that for the Input and Output fields, you just use the normal Excel cells, it’s the easiest. You can make all the lines on the sheet white to hide them, except for these two cells, to make them stand out and obvious. You can also use the Sheet Protection feature to make sure people can’t type anywhere except the Input cell (this includes the Output cell, so people can’t accidentally type over the formula in there).

The Output cell will have a formula along the lines of:

=C10 * (VLOOKUP(D10, Rates!$A$2:$C$20, 3, FALSE))

…Where C10 is the Input cell, D10 is the chosen country’s code/whatever, Rates is the sheet with the rates on it, A2 is the top left cell of the rates table, C20 is the bottom right cell of the rates table (the dollar signs mean that if you copy this formula, it won’t adjust these values), 3 is the column to return – Column C in this example – and FALSE means that you want EXACT matches, which will make this work even if the countries aren’t in alphabetical order. So this command means to go to Rates, find the row with the country code in the first column, then grab the value in Column C on that row, and multiply it by C10

Finally, I would set up Sheet3 as the receipt, grabbing the values from Sheet2 and putting them in a nice way, properly formatted and such. I would set the Print Area accordingly, then I would make a button on Sheet2 to just print Sheet3.

Doing it this way, it’s a simple copy and paste on Rates (a.k.a. Sheet1) to update the rates. If you had cleaned it up, you’d ALWAYS have to clean it up to make sure things are how they need to be to work.

This IS a bunch of setup work, but once done you just have to copy and paste today’s rates, and the rest works simply. Just enter the number, pick the country, click the Print button.

Currency Trading Guide : About Currency Day Trading

The Ultimate Professional Trader Plus Library $250.00 Receive over 38+ hours on 1 dvd of the highest quality trading education in one package! From our beginner to our more advanced programs, this package will work synergistically to increase your trading knowledge and propel you to trading success. This comprehensive course is delivered to you at your own pace through a multi-media series with complete navigation and online testing capabilities. Thi…

Option Spreads: Generating Exceptional Returns with Tony Ciccone Options Trading $39.99 Widely associated with a high risk level, options are often a case of concern when it comes to trading. By taking a closer look at them, however, their flexibility may actually work in your favor. Options can be used to structure an arsenal of diverse strategic positions – many of them with a very high probability of success and a limited chance of risk. Tony Ciccone, noted investment advisor a…

10 Laws of Risk Management (Interactive CD-Rom) $49.99 Learn the 10 Basic Laws of Risk Management that all Successful Traders Know — Successful traders, no matter what the financial instrument, have all learned the specific rules to Risk Management, Capital Preservation and Discipline. This course will take you through the 10 basic laws – a “Starter’s Kit” for the serious trader. Mike Mc Mahon will list and then show you how to implement these laws i…

Garmin nüvi 850 4.3-Inch Widescreen Portable GPS Navigator $239.99 With the nüvi 800 series, Garmin adds smooth speech recognitionto its bestselling line of sleek portable GPS navigators. As with all nüvis, you get a slim, pocket-sized navigator with a gorgeous display, detailed NAVTEQ maps that let you search by name for more than 6 million points of interest like stores, restaurants or hospitals, and an easy, intuitive interface. All of the 800-series na…

iLane 7100 Series In-Car Hands-Free Solution – Piano Black $59.00 Listen-to, reply, and compose e-mails entirely hands-free simply by speaking out-loud in your car Hear verbal notification of incoming e-mails and SMS messages as they are received Transfer between e-mail and phone functionality with a simple voice command Listen as your calendar events are read aloud to you, on command Compatible with most Bluetooth-enabled BlackBerry Smartphones and will work wi…

High Probability trading $19.88 A common denominator among most new traders is that, within six months of launching their new pursuit, they are out of money and out of trading. High-Probability Trading softens the impact of this “trader’s tuition,” detailing a comprehensive program for weathering those perilous first months and becoming a profitable trader. This no-nonsense book takes a uniquely blunt look at the realities of tr…

How the market makers extract millions of dollars a day & How to grab your share A chance meeting or was the universe just delivering what I was searching for?I was in a crowded cafe at lunchtime enjoying some minestrone soup and whilst pondering the elements that made it so good, my table shot to the left and the soup exited on the right. The culprit, an expensive suit apologized and ordered me another. I tried to make polite conversation but sitting down with his colleague; …

Currency Trading For Dummies $13.54 Your plain-English guide to currency tradingForex markets can be one of the fastest and most volatile financial markets to trade. Money can be lost or made in a matter of seconds, and forex markets are always moving. So how do you keep up? This hands-on, friendly guide shows you how the forex market really works, what moves it, and how you can actively trade in it — without losing your head!A…

Master Scalper + Breakout Hunter Combo Pack – Trade Currency online 24 hours a day with the same system the Pros use to scalp the market.  Fully automated - No programming and No trading experience required – Plug & Trade. Make Money from home with No stress. Version 10, with News Filter, for true Set it and Forget it trading $195.00 There is a lot of money to be made in currency trading. Yet most traders lose money in the Forex market. The reason is simple: human emotions get in the way of their strategies. The mental battle between greed and fear is the killer. “I sold too early” (fear), “the price reversed and turned my profits into losses” (greed), are usual excuses traders have for losing their shirt, even though they “kn…

FOREX Best Selling Trading Robot – Trade Currency online 24 hours a day with the same system the Pros use to scalp the market.  Fully automated - No programming required – Plug & Trade. Make Money from home with No stress – Version 10, with News Filter, for true Set it and Forget it trading $145.00 There is a lot of money to be made in currency trading. Yet most traders lose money in the Forex market. The reason is simple: human emotions get in the way of their strategies. The mental battle between greed and fear is the killer. “I sold too early” (fear), “the price reversed and turned my profits into losses” (greed), are some of the excuses that traders have for losing their shirt, even thou…