Trading Software excel

Which online trading software? Yahoo! has values but no active trading.

Prebuilt Code for Modeling and Pricing Today’s Complex Derivatives   Justin London shows how to implement pricing algorithms for a wide variety of complex derivatives, including rapidly emerging instruments covered in no other book. Utilizing actual Bloomberg data, London covers credit derivatives, CDOs, mortgage-backed securities, asset-backed securities, fixed-income securities, and today’s increasingly important weather, power, and energy derivatives. His robust models are designed for both ease of use and ease of adaptation, and may be downloaded by the book’s purchasers from a secured Web site.

Order at Amazon for $119.80

I currently import data from my trading software into excel (column A). The problem is that commodities trade in 1/8ths instead of 1/10's. What I mean by this is that when the imported data shows 300.4 it is really 300.5. When it shows 300.2 it is really 300.25. When it shows 300.7 it is really 300.875. I currently manually change all the numbers myself to convert them to 1/10's. I figured out a equation that will convert the numbers =INT(D18)+(D18-INT(D18))*10/8 for me. Right now I just insert the formula in column B and get the numbers I need. My question is would it be possible to write a macro that will convert the numbers for me and replace the old numbers with the revised numbers? Basically I want to replace the imported data in column A with the new numbers created from the formula in column A. I know it would be easy to just use the numbers in column B and paste them over into column A but I like the idea of just importing the data and clicking a button to convert them to 1/10's. I know this sounds confusing so let me know if you need any more details. Basically I want the numbers created from the formula above to replace the numbers in column A. I do not want to use column B to convert the numbers. Thanks Thanks again cozmosis. You just made me work life much easier (saved me about 20 min a day). Thanks again for the original formula and the macro

Converts the decimal portion of numbers in column A from 8ths to 10ths. Sub Convert8to10() ' ' Convert8to10 Macro ' Macro recorded 12/8/2008 ' Convert decimal from 8ths to 10ths Lastrow = Range("A65536").End(xlUp) For Each Cell In Range("A1", Cells(Lastrow, 1)) If IsNumeric(Cell.Value) And _ Cell.Value <> "" Then Cell.Value = Int(Cell.Value) _ + (Cell.Value - Int(Cell.Value)) * 10 / 8 End If Next Cell End Sub

Hi everybody there. I want to keep records of Daily Share prices. I have list of around 1800 plus companies from which i have sorted out for example say 500 companies. I download daily price and trading quantity of 1800plus companies and have to sit and work out to delete unwanted names of the companies and price to keep the companies only which are in my list. I have made graphs of important companies in Excel program. After sorting the companies i copy and paste in each file where i have graphs which automatic updates. What i need is a software or programing in Excel to sort out the companies and their price daily from the download complete list and keep aside the unwanted companies so that i can check the separated companies to see if there is any new company and than delete all myself. By this i only have to copy paste everyday the price and trading quantity of companies in mylist to update the graphs. Can somebody help me for this. Thanks in advance and Best regards

VLOOKUP() should work for your needs, as long as the company names in your spreadsheet match exactly with the info you download. Basically, it's a formula that searches a table for matches (in your case the company name) and returns a cell next to it (any length away is fine). Assuming all your data is on the same row, this should work. In this example, I have your company name you want to look up in A1. The data copied from your daily source is in sheet3,A1:F1800. And the share price is the third column in this table. The name has to be the first column of this table. I give the price as the third column because the second might be volume or something. =VLOOKUP(A1, Sheet3!$A$1:$F$1800, 3, FALSE) If your data is formatted weird (multiple lines per company, and the name and price is on different lines), this may not work. If the data is displayed horizontally (not normal), and the company names are all on one row, and the share price is below each name, you need HLOOKUP().

What I'm looking for is a software that collects historical or current data and builds graphs, shows potentials, indicators, stuff like that. Something like e*trade but not on a web site. I'm looking for an actual software...not excel though. Something that is build specifically for securities analysis. Does such thing exist?

Worden (Stockfinder), Metastock, and Amibroker are three.

Gecko Software Revolutionizing The Trading Software Industry
Gecko Software has also produced many plug-ins to expand the capabilities of their software for it's users to excel in the trading industry. Application Support Analyst, Trading Systems
... of award winning financial trading systems software to some of the world's premier trading and ... knowledge of Microsoft Windows, Word and ... Resolution for Tablet PCs Improves, with Large-Area LCDs Forecast to ...
... low-cost direct type LED backlights, trading off ... delivered in PowerPoint and includes Excel-based ... home, office supplies, software, ... You’ve come a long way baby.
Vista a very established Software Private ... Taleo and many others still trading at 3-8 times ... between all these systems and lets them excel ... Instinet Adds Research Voting to Commission Management
The electronic trading pioneer and provider of ... Group, State Street, UBS and Advent Software, In ... inefficiencies associated with a manual ...