Search results

Thank you so much @fxshrat Its great to know that Amibroker has such capabilities, not just for auto export to excel, but also for auto import from it as well. :) Thanks and regards

Thanks M.ST What you say is true for Auto Scan, but I am talking about AUTO EXPORT of these scan/ exploration results to the EXCEL SHEET. I have not seen such examples till now. If you or anyone else have seen such an example on any forum/site/blog etc. then please share that link. It would be...

Thank you so much botpro. Really appreciated.

Thankyou botpro and Metamega for your views. Metamega, that was a very comprehensive reply. Thanks a lot. You seem to have real good knowledge of Amibroker. Thanks a lot for sending the link to Marcin or Tomasz as well. It will be interesting to see the replies from the main developers...

Hi Friends I am looking for a trading platform which is capable of doing the following - 1. Automatically sending out the SCAN Results / Output to specific excel file and worksheet, after a fixed interval like 5 minutes / 30 minutes. 2. Ability to Read the data from Excel/csv/text files etc...

Thanks for your reply wrbtrader. I myself use Snagit and I am a big fan of it. But as you said it will be a lot of work to prepare these within snagit, therefor I was looking for other options. With Regards

Thank you NoBias for the wonderful tip. This extension is really good for finding out the source of such drawings.

Thank you so much for the idea harami. That looks like a great tool for drawing these.

Please have a look at the attached snapshots. I want to know which software would help in making such detailed snapshots in an efficient manner. All this could be done inside MS Paint as well, by drawing each single price candlestick bar with hand and then arranging them one by one, but that...

Thank you so much for sharing this info. But it is scary to know all this ! I was not aware that it could be so easy for the program developers to steal such sensitive information from the Trader's PC. :eek:

As already mentioned by others, we cannot prevent our trades being shadowed if we are doing it through the normal brokers. I have no practical idea regarding the "broker-neutral execution platform" so I cannot comment on them. But you can very well use multiple brokers and then execute your...

Although I am not sure, but can we use something like this for doing the WEEKLY calculation, by selecting top 7 dates from within the table. WHERE xdate >= (select min(ts) from (select distinct top 7 xdate as ts from [Table_1] order by xdate desc ) And similarly for Monthly we could...

Thanks a ton viktor_k67 for providing the solution. I tried to convert your code according to my table, for doing the calculation for 1 Day % Change "DailyPCT" as follows - Declare @d1 as smalldatetime, @d2 as smalldatetime --get the most recent date set @d1 = (Select top 1 xdate from...

Thanks for your views grashed. And I agree with it. Many other guys also say that SQL Server is not the right tool to do any complex stock market related queries work. There are other database which are specially designed for doing such work. Regarding C# or Java, I would say that I am a total...

Thanks for the link globalrbtrader. I will check it out.

Hi I am using SQL Server 2014 Standard Edition x64. I have a table that has got these 3 columns in it, showing the EOD Price Data for the symbols - xdate symbol price I need to write a query to calculate the Daily/weekly/monthly % Change in Price Daily % Change in Price over past 1 day...

Thank you guys. The thread is quite old now, but very informative for anyone interested in doing analysis with SQL Server or similar databases.

--Create our historical data table create table #google_stock ( quote_date [datetime], open_price [decimal](6,2), close_price [decimal](6,2), high_price [decimal](6,2), low_price [decimal](6,2) ) INSERT INTO #google_stock (quote_date, open_price, close_price, high_price, low_price) VALUES...

-- for those who are interested in calculating moving averages within a SQL Database, this article provides 2 methods. Calculating Moving Averages with T-SQL By Gabriel Priester, 2010/03/04 This article will show you how to calculate moving averages with Financial Market data across time...