bmf | blogs management framework | REST library

I am trying to download some data from BM&FBOVESPA reference rates page.

Their web pages is...

http://www.b3.com.br/en_us/market-data-and-indices/data-services/market-data/reports/derivatives-market/reference-prices/bm-fbovespa-reference-rates/

and the Frame is...

http://www2.bmf.com.br/pages/portal/bmfbovespa/lumis/lum-taxas-referenciais-bmf-ptBR.asp

Here is my code, which is giving me an error: Error in out[j + k, ] : subscript out of bounds

Suppose I have a data.table like this:

I'm try to scrape a table, from B3 site, but the result is a empty data frame.

What's wrong?

I am trying to access a webpage that has only one input box, fill it with a string and then select the first dropdown option that comes from it. The reason to select the first option is because it does not work unless you pick it, even if the text contains exactly the same as the dropdown option.

I have managed to do something like this for this page like this: http://www2.bmf.com.br/pages/portal/bmfbovespa/lumis/lum-ajustes-do-pregao-ptBR.asp

Hi there! Try to play with the VMKAPI ...

I want to select a specific table (I marked in the image what I want to get) but the page has many tables. How do I select the table I want?

Below I have a code to get info about t-log backups for each database in the server. I want to exclude tempdb from this list.

I am currently updating a database that I created for work to classify transactions into a transaction type. This requires me to use an iif() statement that has become too complex to run. Before we get too far along, I want to apologize for the lengthy description, but I want to make sure I provide enough information.

Transactions (RefID's) can be one of the following:

• 3PL
• 4PL
• Air Freight
• Customs Only

One of the complexities of this task involves the fact that a Charge Code ("CC"), similar to an item number or service name, can be 3PL or 4PL depending on the circumstances of the transaction. For example, if the CC of Ocean_Freight exists on a RefID that also has a CC of PO_Management, the transaction is a 3PL transaction. However, if the CC of PO_Management exists without Ocean_Freight on the RefID, this would be a 4PL Transaction.

I have the following CC's which can be used to define a transaction:

3PL Only

• Ocean_Freight
  • this CC will define the transaction unless there is a CC from the "3PL or 4PL Depending on Situation" section below
• Drayage Management
  • this CC will define the transaction unless there is a CC from the "3PL or 4PL Depending on Situation" section below

Air Freight Only

• Air_Freight

3PL or 4PL Depending on Situation

• PO_Management
  • 3PL when CC exists on a RefID with Ocean_Freight or Drayage Management
  • 4PL when CC exists on a RefID without the aforementioned CC's

• CROM Fee

  • 3PL when CC exists on a RefID with Ocean_Freight or Drayage Management
  • 4PL when CC exists on a RefID without Ocean_Freight, Drayage Management, or PO_Management

• EDI

  • 3PL when CC exists on a RefID with Ocean_Freight or Drayage Management
  • 4PL when CC exists on a RefID without Ocean_Freight, Drayage Management, or PO_Management
• Booking Management Fee
  • 3PL when CC exists on a RefID with Ocean_Freight or Drayage Management
  • 4PL when CC exists on a RefID without Ocean_Freight, Drayage Management, PO_Management, or EDI
• Forwarding Fee
  • 3PL when CC exists on a RefID with Ocean_Freight or Drayage Management
  • 4PL when CC exists on a RefID without Ocean_Freight, Drayage Management, PO_Management, EDI, or Booking Management Fee
• Handling Charge
  • 3PL when CC exists on a RefID with Ocean_Freight or Drayage Management
  • 4PL when CC exists on a RefID without Ocean_Freight, Drayage Management, PO_Management, EDI, Booking Management Fee, or Forwarding Fee

Customs Only

As a note - each of the preceding CC's can be considered what I classify as a Transaction Defining Charge Code (TDCC), in the absence of one of these CC's and the presence of the Customs Entry CC, the transaction is defined as a "Customs Only" transaction.

https://imgur.com/e57buni

I previously accomplished this within Access using a nested iif() statement, but in some cases I was pulling duplicate records because I wasn't isolating each of the CC's. For example, if PO_Management and Handling Charge existed on the same transaction, both would get ascribed a value of "4PL", when in reality, I only want one to define the transaction. This is what sent me down this path of repairing the code.

The query that drives most of this is called "Step 2)" and it does a sum(iif(criteria here),1,0) based on whether or not a CC exists on a RefID. It provides a value of >0 if a CC exists on a RefID which allows me to reference this query to determine how I should define a RefID.

To further refine my original methodology, I made another query called "Steps." Within this query is where I apply the logic from above within the CC descriptions section above.

I have tried using a nested iif() statement and also tried using the Switch() function, but both get to the same point, "The expression you entered is too complex." I have done some research and I believe the answer is a Private Function using VBA, but I have had no luck understanding how to create the functions. Does anyone have a better way of attacking this problem? Please find a sample of my latest attempt at a switch() function which kicks out the error below:

I am trying to insert a specific value at 3 differents space boxes. However, I did not find a example that works with the site which I am using.

Site: http://www.b3.com.br/pt_br/market-data-e-indices/indices/indices-de-segmentos-e-setoriais/serie-historica-do-di.htm