Finam 1 minute off

Hi Tomasz,

In Finam, Amiquote will import quotes 1 minute into the future. Example: to recreate this as 1 minute quotes, you can see Amiquote will import the closing on the Friday as 17:01:00 eastern time.

To correct this, I believe you set MSOR=0 instead of MSOR=1 in the url.

Lou

AmiQuote uses import format files. So you can change time shift yourself very easily.
ASCII import command for that task is $TIMESHIFT.

Since you want to shift by one minute ( 1-minute - > 1/60 hour) you would have to add line

$TIMESHIFT -0.01666667

So go to C:\Program files\AmiBroker\Formats folder and open file aqf.format via NotePad or Notepad++ or ... other text editor.

And change content from

# Format definition file for Finam
# by AmiBroker's ASCII Import Wizard
$FORMAT Date_YMD, Time, Open, High, Low, Close, Volume
$BREAKONERR 0
$SKIPLINES 0
$SEPARATOR ,
$CONT 1
$GROUP 255
$AUTOADD 1
$DEBUG 1

to

# Format definition file for Finam
# by AmiBroker's ASCII Import Wizard
$FORMAT Date_YMD, Time, Open, High, Low, Close, Volume
$BREAKONERR 0
$SKIPLINES 0
$SEPARATOR ,
$CONT 1
$GROUP 255
$AUTOADD 1
$DEBUG 1
$TIMESHIFT -0.01666667
2 Likes

Hey thanks for that. I just wanted Tomasz to make the Finam URL code more accurate. No matter what time zone you are in, $TIMESHIFT should be a whole number for everyone actually. (Except in time zones like Newfoundland).