# ActionDetails_Str

VALUE:
FDIC: Details and Financials - ID  Google Chrome


VALUE:
FDIC: Federal Deposit Insurance Corporation - Internet Explorer


VALUE:
from selenium import webdriver
from selenium.webdriver.chrome.options import Options
from selenium.webdriver.support.ui import Select

from selenium.webdriver.common.by import By

from selenium.webdriver.support.ui import WebDriverWait

from selenium


VALUE:
.webdriver.support import expected_conditions as EC

chrome_options = Options()
chrome_options.add_experimental_option("debuggerAddress", "127.0.0.1:8080")
chrome_driver = r'C:\Selenium\chromedriver.exe'

browser = webdriver.Chrome(chrome_driver, op


VALUE:
This variable is used to store whether the state was found in the drop down list


VALUE:
[%Code_Template]

browser.get('https://www5.fdic.gov/idasp/advSearchLanding.asp')

browser.switch_to.frame('content')


wait = WebDriverWait(browser, 10)
wait.until(EC.presence_of_element_located((By.ID, 'in_bank_state')))

select = Select(browser


VALUE:
.find_element_by_id('in_bank_state'))

try:
	select.select_by_visible_text('[?Lookup("States", "[*CURRENT_LOOP_NUMBER]", "Item No", "State Name")]')
	browser.find_element_by_id('btnSearch').click()
except:
	print('ERROR')

browser.quit()


VALUE:
This is a variable used to store the search result from the FDIC website


VALUE:
[%Code_Template]

browser.switch_to.frame('content')

text = browser.find_element_by_id('divResultTable_info').text
print(text)

browser.quit()


VALUE:
[?Lookup("States", "[*CURRENT_LOOP_NUMBER]", "Item No", "State Name")]


VALUE:
Anywhere in U.S. Alabama Alaska American Samoa Arizona Arkansas California Colorado Connecticut Delaware District Of Columbia Federated States Of Micronesia Florida Georgia Guam Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Marshall I


VALUE:
slands Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Northern Mariana Islands Ohio Oklahoma Oregon Palau Pennsylvania Puerto Rico Rhode Islan


VALUE:
d South Carolina South Dakota Tennessee Texas Utah Vermont Virgin Islands Virginia Washington West Virginia Wisconsin Wyoming


VALUE:
Showing Record 1 to 8 of 8 Institutions found.


VALUE:
FDIC: Details and Financials - ID - Internet Explorer


# Actions

NOTES:
To run the script correctly, first you have to save file named 'Website FDIC" in your Downlads folder first


NOTES:
Read all the states from the Excel document


NOTES:
Save the Excel document as a new file with today's date


NOTES:
Resize the Excel window to make sure it is ALWAYS the same size


NOTES:
Move the Excel window to a proper position


NOTES:
Insert a new first row to contain the column headers


NOTES:
Write the header name of the first column


NOTES:
Resize the Chrome window to make sure it is ALWAYS the same size


NOTES:
Move the Chrome window to the top left corner


NOTES:
Open Internet Explorer and navigate directly to the FDIC website


NOTES:
Resize the IE window to make sure it is ALWAYS the same size


NOTES:
Move the Internet Explorer window to the top left corner


NOTES:
Create a variable containing all the standard code for the Python actions


NOTES:
Repeat the following steps for each state in the list


NOTES:
Create variable to store the result in the below search action


NOTES:
Search for the state in the dropdown and select it + search if possible


NOTES:
If the state was not found, note that in the document, otherwise, proceed to retrieve the search result


NOTES:
Note in the document that the state was not found


NOTES:
Create a variable to store the search result from the FDIC website


NOTES:
Retrieve the number between "of" and "Institutions"


NOTES:
Delete the code containing the template of code


NOTES:
Create variable to store the result in the below search acrion


NOTES:
Search for the current state in the drop down


NOTES:
Read the search result from the FDIC website


