Home

Excel 365 fill handle when connected with Excel RTD

%3CLINGO-SUB%20id%3D%22lingo-sub-831622%22%20slang%3D%22en-US%22%3EExcel%20365%20fill%20handle%20when%20connected%20with%20Excel%20RTD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831622%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20using%20Excel%20RTD%20from%20FX%20Blue%20Labs%20to%20connect%20my%20Excel%20365%20(Desktop)%20to%20MT4%20to%20get%20real-time%20forex%20data%20and%20historical%20ones.%3C%2FP%3E%3CP%3EI%20need%20to%20know%20how%20to%20use%20the%20fill%20handle%20to%20fill%20all%20the%20cells%20without%20typing%20the%20formula%20in%20each%20row.%3C%2FP%3E%3CP%3EAn%20example%3A%20After%20connecting%20MT4%20to%20Excel%2C%20I%20type%20this%20formula%20%3DRTD(%22fxbluelabs.excelrtd%22%2C%20%2C%22Account%20Number%22%2C%20%22%40bh%2CGBPUSD%2CH4%2Cclose%2C0%22)%20to%20get%20the%20current%20close%20of%20GBPUSD%20H4.%3C%2FP%3E%3CP%3EIf%20I%20change%20the%20last%20number%20(0)%20to%20(1)%2C%20I%20will%20get%20the%20previous%20close.%3C%2FP%3E%3CP%3EIf%20I%20type%20the%20formula%20as%20%3DRTD(%22fxbluelabs.excelrtd%22%2C%20%2C%22Account%20Number%22%2C%20%22%40bh%2CGBPUSD%2CH4%2Cclose%2C200%22)%20I%20will%20get%20the%20close%20of%20the%20200th%20bar.%3C%2FP%3E%3CP%3ENow%2C%20the%20problem%20is%20that%20when%20I%20selected%20the%20first%20three%20or%20four%20cells%20(in%20a%20column)%20with%20the%20above%20formulas%20and%20try%20to%20use%20the%20fill%20handle%2C%20I%20get%20the%20new%20rows%20filled%20the%20same%20as%20the%20selected%20row%20cells.%20For%20example%2C%20the%20first%20column%20has%20rows%201st%2C%202nd%2C%203rd.%20If%20I%20drag%20the%20first%20column%2C%20it%20is%20filled%20in%20the%20right%20order%20with%204th%2C%205th%2C%206th%2C%20etc..%3C%2FP%3E%3CP%3EBut%20the%20column%20with%20the%20formulas%20that%20are%20linked%20to%20MT4%20is%20not%20being%20filled%20correctly.%20Excel%20just%20repeats%20the%20values%20of%20those%20three%20rows%20in%20the%20second%20column.%3C%2FP%3E%3CP%3EAny%20solution%20for%20this%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-831622%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMT4%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Deep_Thinker
Occasional Visitor

 

Hello,

I am using Excel RTD from FX Blue Labs to connect my Excel 365 (Desktop) to MT4 to get real-time forex data and historical ones.

I need to know how to use the fill handle to fill all the cells without typing the formula in each row.

An example: After connecting MT4 to Excel, I type this formula =RTD("fxbluelabs.excelrtd", ,"Account Number", "@bh,GBPUSD,H4,close,0") to get the current close of GBPUSD H4.

If I change the last number (0) to (1), I will get the previous close.

If I type the formula as =RTD("fxbluelabs.excelrtd", ,"Account Number", "@bh,GBPUSD,H4,close,200") I will get the close of the 200th bar.

Now, the problem is that when I selected the first three or four cells (in a column) with the above formulas and try to use the fill handle, I get the new rows filled the same as the selected row cells. For example, the first column has rows 1st, 2nd, 3rd. If I drag the first column, it is filled in the right order with 4th, 5th, 6th, etc..

But the column with the formulas that are linked to MT4 is not being filled correctly. Excel just repeats the values of those three rows in the second column.

Any solution for this?

Thanks

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies