Jump to content

Excel Based Trading


Recommended Posts

when did Excel Based Trading really start?
+ this would include using Excel DDE, Excel RTD, etc


would it be envisaged that Excel Based Trading will get more popular from now on?


as is understood, there are broker platforms which allow one to extract eg OHLP Prices directly into Excel, instead of have to configure an Excel DDE spreadsheet, or Excel RTD spreadsheet
+ any comments on this?

Link to comment
On 06/02/2023 at 20:32, jhclctcrc said:

when did Excel Based Trading really start?
+ this would include using Excel DDE, Excel RTD, etc


would it be envisaged that Excel Based Trading will get more popular from now on?


as is understood, there are broker platforms which allow one to extract eg OHLP Prices directly into Excel, instead of have to configure an Excel DDE spreadsheet, or Excel RTD spreadsheet
+ any comments on this?

may I ask if anyone knows where is a good place where there is a forum on Excel Based Trading?

Link to comment

I don't think the IG spreadsheet is supported anymore and like you have discovered it is tricky and time-consuming to get working.

I've lots of experience using Excel for financial markets/trading purposes as well as using the IG API.

I've built an Excel Add-in which makes using Excel with IG much easier, you don't need to deal with DDE, RTD etc. you can just use standard Excel formulas: https://www.excelpricefeed.com/

I think Excel is great for analysing prices, backtesting, modelling, generating signales etc. but I would not suggest that you try to use it for actual trading.

Andy

Link to comment
6 hours ago, andysinclair said:

I don't think the IG spreadsheet is supported anymore and like you have discovered it is tricky and time-consuming to get working.

I've lots of experience using Excel for financial markets/trading purposes as well as using the IG API.

I've built an Excel Add-in which makes using Excel with IG much easier, you don't need to deal with DDE, RTD etc. you can just use standard Excel formulas: https://www.excelpricefeed.com/

I think Excel is great for analysing prices, backtesting, modelling, generating signales etc. but I would not suggest that you try to use it for actual trading.

Andy

thanks Andy, will checkout your Excel Add-In (but a bit later, as I have to clear a few things first)

 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • image.png

  • Posts

    • I've developed an initial version of a market sentiment checker, which utilizes the concept of weighted log returns to gauge the mood of the financial markets. This tool is designed to simplify the complex task of assessing market sentiment by analyzing fluctuations in price data. By applying weights to log returns, it emphasizes the significance of certain data points over others, offering a more nuanced view of market dynamics. This approach allows for a fundamental analysis of market sentiment and provides insights into the current state of the market at any given moment. It serves as a valuable tool for investors and traders looking to make informed decisions based on the underlying sentiment driving market movements. sentiment-sleuth - Github Link
    • Demo account: Please note that conditions on demo accounts may differ from real accounts. Some brokers may only provide overnight loans on real accounts and not on demo accounts.
    • Swap Rate: Check the swap rates for your open positions. Overnight loans are calculated based on the difference between the interest rates of a currency pair, and if the difference is small or negative, you will not receive a loan.
×
×
  • Create New...
us