{"id":123,"date":"2007-05-12T00:03:36","date_gmt":"2007-05-12T00:03:36","guid":{"rendered":"http:\/\/www.amibroker.org\/userkb\/2007\/05\/12\/example-database\/"},"modified":"2008-03-03T11:46:33","modified_gmt":"2008-03-03T11:46:33","slug":"example-database","status":"publish","type":"post","link":"http:\/\/www.amibroker.org\/editable_userkb\/2007\/05\/12\/example-database\/","title":{"rendered":"Example Database"},"content":{"rendered":"<p>Easy access to free Yahoo data, using AmiBrokers companion down-loader AmiQuote, is a huge bonus for AmiBroker users.<\/p>\n<p>In this tutorial, the first in a series of Users&#8217; Knowledge Base articles on Yahoo data management, new users are introduced to some basic concepts utilizing mainly GUI methods. Walk through examples, using the Dow Jones Industrial Average database installed with AmiBroker, and apply simple customized formulas written in AFL (AmiBroker Formula Language).<\/p>\n<p>FORMULAS FEATURED: BeginValue(); LastValue; DateNum(); BarCount; Status(); FullName(); IsIndex(); GroupID(); MarketID(); SectorID() and IndustryID().<\/p>\n<p>INCLUDING: database location, backup and naming; ticker lists (.tls files); company information pages; symbol addition and deletion; updating quotes; writing and saving formulas in Formula Editor; running Explorations and viewing the results list; data quality checking using the Database Purify Tool; adding favorites to the Web Research list; setting the default and scrolling Yahoo pages in the AmiBroker browser; deleting quotes in Quote Editor; rearranging the Workspace layout using the Docking sticker; Ticker Toolbar searching and more &#8230;&#8230;&#8230;&#8230;&#8230;.<\/p>\n<p><b>Attached Files:<\/b><\/p>\n<ul>\n<li><a href=\"http:\/\/www.amibroker.org\/userkb\/wp-content\/uploads\/2007\/08\/exampledatabase.doc\"><i>exampledatabase.doc (1178 KB)<\/i><\/a> (<em>Word 2002 document<\/em>) <\/li>\n<li><a href=\"http:\/\/www.amibroker.org\/userkb\/wp-content\/uploads\/2007\/06\/x-categories.afl\"><i>x-categories.afl (262 bytes)<\/i><\/a> <\/li>\n<li><a href=\"http:\/\/www.amibroker.org\/userkb\/wp-content\/uploads\/2007\/06\/x-database.afl\"><i>x-database.afl (226 bytes)<\/i><\/a> <\/li>\n<li><\/li>\n<li><sub><em>Click on the link to browse document files on line, or, <strong>Save As <\/strong>to download an editable version, complete with a document map (the document map will only be available to users who own a copy of Word).<\/em><\/sub> <\/li>\n<li><sub><em>To download <strong>.afl <\/strong>files to the desktop right click on the link&#160; and <strong>Save Target As <\/strong>&#8216;filename&#8217; at Program Files\/AmiBroker\/Formulas\/Custom to access them as formulas in the AmiBroker Charts list.<\/em><\/sub> <\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Easy access to free Yahoo data, using AmiBrokers companion down-loader AmiQuote, is a huge bonus for AmiBroker users. In this tutorial, the first in a series of Users&#8217; Knowledge Base articles on Yahoo data management, new users are introduced to some basic concepts utilizing mainly GUI methods. Walk through examples, using the Dow Jones Industrial [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[131],"tags":[],"_links":{"self":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts\/123"}],"collection":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/comments?post=123"}],"version-history":[{"count":0,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts\/123\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/media?parent=123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/categories?post=123"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/tags?post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}